public void authorititescontacted()
{
SqlCommand cmd = new SqlCommand("Proc_Anti_Ragging1", con);
cmd.CommandType = CommandType.StoredProcedure;
string collegeId = Session["CollegeId"].ToString();
cmd.Parameters.AddWithValue("@CollegeId", collegeId);
cmd.Parameters.AddWithValue("@Qtype", 2);
cmd.Parameters.AddWithValue("@authoritites_Name", txtauthorititesname.Text);
cmd.Parameters.AddWithValue("@authoritites_Designation", txtauthorititesdesig.Text);
cmd.Parameters.AddWithValue("@authoritites_Contact", txtauthorititescontact.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
cmd.Parameters.AddWithValue("@authoritites_Name", txtauthorititesname1.Text);
cmd.Parameters.AddWithValue("@authoritites_Designation", txtauthorititesdesig2.Text);
cmd.Parameters.AddWithValue("@authoritites_Contact", txtauthorititescontact3.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
What I have tried:
i want o insert data in database column is same but when textbox id change then row will change in database
below is my code please help