con.Open();
//string un = TextBox1.Text;
SqlCommand cmd1 = new SqlCommand("UPDATE userdet SET username = @username, FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName, Organisation = @Organisation, Bussiness = @Bussiness, Address1 = @Address1, Address2 = @Address2, City = @City, State = @State, Country = @Country, PinCode = @PinCode, Tel = @Tel, Email = @Email, Doj = @Doj, fax = @fax, website = @website, description = @description, dat = @dat WHERE (username = @username) OR (FirstName = @FirstName) OR (MiddleName = @MiddleName) OR (LastName = @LastName) OR (Organisation = @Organisation) OR (Bussiness = @Bussiness) OR (Address1 = @Address1) OR (Address2 = @Address2) OR (City = @City) OR (State = @State) OR (Country = @Country) OR (PinCode = @PinCode) OR (Tel = @Tel) OR (Email = @Email) OR (Doj = @Doj) OR (fax = @fax) OR (website = @website) OR (description = @description) OR (dat = @dat)", con);
SqlCommand cmd2 = new SqlCommand("update usertable set username=@username,password=@password,ustatus=@ustatus where username=@username or password=@password or ustatus=@ustatus", con);
//cmd1.Parameters.AddWithValue("@UserName", TextBox2.Text);
// cmd1.Parameters.AddWithValue("@username1", TextBox1.Text);
// cmd2.Parameters.AddWithValue("@username", TextBox1.Text);
cmd1.Parameters.AddWithValue("@username", TextBox2.Text);
cmd1.Parameters.AddWithValue("@FirstName", TextBox3.Text);
cmd1.Parameters.AddWithValue("@MiddleName", TextBox4.Text);
cmd1.Parameters.AddWithValue("@LastName", TextBox5.Text);
cmd1.Parameters.AddWithValue("@Organisation", TextBox6.Text);
cmd1.Parameters.AddWithValue("@Bussiness", TextBox7.Text);
cmd1.Parameters.AddWithValue("@Address1", TextBox8.Text);
cmd1.Parameters.AddWithValue("@Address2", TextBox9.Text);
cmd1.Parameters.AddWithValue("@City", TextBox10.Text);
cmd1.Parameters.AddWithValue("@State", TextBox11.Text);
cmd1.Parameters.AddWithValue("@Country", TextBox12.Text);
cmd1.Parameters.AddWithValue("@PinCode", TextBox13.Text);
cmd1.Parameters.AddWithValue("@Tel", TextBox14.Text);
cmd1.Parameters.AddWithValue("@Email", TextBox15.Text);
cmd1.Parameters.AddWithValue("@Doj", TextBox16.Text);
cmd1.Parameters.AddWithValue("@fax", TextBox17.Text);
cmd1.Parameters.AddWithValue("@website", TextBox18.Text);
cmd1.Parameters.AddWithValue("@description", TextBox19.Text);
cmd1.Parameters.AddWithValue("@dat", TextBox20.Text);
cmd1.ExecuteNonQuery();
cmd2.Parameters.AddWithValue("@username", TextBox2.Text);
cmd2.Parameters.AddWithValue("@password", TextBox21.Text);
cmd2.Parameters.AddWithValue("@ustatus", TextBox22.Text);
cmd2.ExecuteNonQuery();
Label21.Text = "Updated";
con.Close();
while executing. all the rows in the table is getting changed. actually if i set username in userdet as primary key its not updating. why? i want to upadate that too. please help