Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //INSERT INTO Customer
- SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["ComplaintReportsConnectionString1"].ConnectionString);
- conn1.Open();
- string query1 = String.Format("Insert Into Customer(Customer_id,NRIC,First_Name,Last_Name,Company_Name,Phone_No,Fax_No,Email,Address_Line1,Address_Line2,City,State_Province,Postal_Code,Country)VALUES(' ',@NRIC,@First_Name,@Last_Name,@Company_Name,@Phone_No,@Fax_No,@Email,@Address_Line1,@Address_Line2,@City,@State_Province,@Postal_Code,@Country,select SCOPE_IDENTITY();)", conn1);
- SqlCommand cmd1 = new SqlCommand(query1, conn1);
- cmd1.Parameters.AddWithValue("@NRIC", TextBox2.Text);
- cmd1.Parameters.AddWithValue("@First_Name", TextBox3.Text);
- cmd1.Parameters.AddWithValue("@Last_Name", TextBox4.Text);
- cmd1.Parameters.AddWithValue("@Company_Name", TextBox5.Text);
- cmd1.Parameters.AddWithValue("@Phone_No", TextBox6.Text);
- cmd1.Parameters.AddWithValue("@Fax_No", TextBox7.Text);
- cmd1.Parameters.AddWithValue("@Email", TextBox8.Text);
- cmd1.Parameters.AddWithValue("@Address_Line1", TextBox9.Text);
- cmd1.Parameters.AddWithValue("@Address_Line2", TextBox10.Text);
- cmd1.Parameters.AddWithValue("@City", TextBox11.Text);
- cmd1.Parameters.AddWithValue("@State_Province", TextBox12.Text);
- cmd1.Parameters.AddWithValue("@Postal_Code", TextBox13.Text);
- cmd1.Parameters.AddWithValue("@Country", TextBox14.Text);
- //cmd1.Parameters.AddWithValue("@Customer_id", TextBox17.Text);
- var customerID = Convert.ToInt32(cmd1.ExecuteScalar());
- conn1.Close();
Add Comment
Please, Sign In to add comment