Guest User

Untitled

a guest
Apr 10th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ASP 0.93 KB | None | 0 0
  1. //INSERT INTO Complaint
  2. SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ComplaintReportsConnectionString1"].ConnectionString);
  3. conn2.Open();
  4.  
  5. string query2 = String.Format("Insert Into Complaint(Complaint_Date,Complaint_Details,Type_id,Status_id,Channel_id)VALUES(@Complaint_Date,@Complaint_Details,@Type_id,@Status_id,@Channel_id)", conn2);
  6. SqlCommand cmd2 = new SqlCommand(query2,conn2);
  7.  
  8. cmd2.Parameters.AddWithValue("@Complaint_Date", TextBox16.Text);
  9. cmd2.Parameters.AddWithValue("@Complaint_Details", TextBox15.Text);
  10.  
  11. //customerID from customer's table
  12. cmd2.Parameters.AddWithValue("@Customer_id", customerID);
  13.  
  14. cmd2.Parameters.AddWithValue("@Type_id", type.SelectedValue);
  15. cmd2.Parameters.AddWithValue("@Channel_id", Channel.SelectedValue);
  16. cmd2.Parameters.AddWithValue("@Status_id", Status.SelectedValue);
  17.  
  18. cmd2.ExecuteNonQuery();
  19. conn2.Close();
  20. Response.Redirect("CustomerComplaint.aspx");
Add Comment
Please, Sign In to add comment