Answer the question
In order to leave comments, you need to log in
The System.Web.UI.WebControls.TextBox appears in the Textbox when I click on the Update button. How can this be fixed?
protected void btnUpdate_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings
["StudentConnectionString"].ConnectionString);
conn.Open();
string updateQuery = "update Students set firstName = '"+ txtBoxfName + "'," +
" lastName = '"+ txtBoxlName +"', " +
"studentNo = '" + Convert.ToInt32(txtBoxStudentNo.Text) +
"' where id_student = '"+ Convert.ToInt32(txtPK.Text) +"'";
SqlCommand cmd = new SqlCommand(updateQuery, conn);
cmd.ExecuteNonQuery();
Label2.Text = "student successfully updated";
txtBoxfName.Text = " ";
txtBoxlName.Text = " ";
txtBoxStudentNo.Text = " ";
conn.Close();
}
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question