Hi ,
Check this
protected void Button1_Click(object sender, EventArgs e)
{
using (
SqlConnection con =
new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("UPDATE dbo.cate SET cate = @cate , chk = @chk where id = @id", con))
{
cmd.Parameters.AddWithValue("@cate", txt1.Text);
cmd.Parameters.AddWithValue("@chk", chk.Checked);
cmd.Parameters.AddWithValue("@id", lbl1.Text);
cmd.ExecuteNonQuery();
}
}
}
Best Regards
M.Mitwalli