ASP.Net简单更新方法举例

    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", "张三");
        command.Parameters.Add(parm);
        try
        {
            conn.Open();
            return command.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            return -1;
        }
        finally
        {
            conn.Close();
        }
    }