I want to ask how to update data in database? I'm using the code as the below.
string value1 = TextBox1.Text;
string value2 = TextBox2.Text;
string value3 = TextBox3.Text;
string value4 = TextBox4.Text;
string value5 = TextBox5.Text;
string strsql = "Update Form Set Name='" + TextBox2.Text + "', Designation='" + TextBox3.Text + "',Mobile_No='" + TextBox4.Text + "' Address='" + TextBox5.Text + "' where Id='" + TextBox1.Text + "';
dbComm = new SqlCommand(strsql, dbConn);
dbConn.Open();
int rc = dbComm.ExecuteNonQuery();
dbConn.Close();