H
H
HelpIT2021-01-12 14:51:30
ASP.NET
HelpIT, 2021-01-12 14:51:30

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 question

Ask a Question

731 491 924 answers to any question