Example of simple ASP. Net update Method

Public int Update ()
{
String SQL = "update student set xingming = @ xingming wherexuehao = @ xuehao ";
DataTable dt = new DataTable ();
SqlConnection conn = new SqlConnection ();
Conn. ConnectionString = @ "Data Source = (LocalDB) \ v11.0; AttachDbFilename = | DataDirectory | \ Database. mdf; Integrated Security = True ";
SqlCommand command = new SqlCommand (SQL, conn );
SqlParameter parm = new SqlParameter ("@ xuehao", "001 ");
Command. Parameters. Add (parm );
Parm = new SqlParameter ("@ xingming", "Zhang San ");
Command. Parameters. Add (parm );
Try
{
Conn. Open ();
Return command. ExecuteNonQuery ();
}
Catch (SqlException ex)
{
Return-1;
}
Finally
{
Conn. Close ();
}
}