数据库里如何用update更改表内数据

UPDATE 表1 set 成绩 = 82 where 学号 = 2000070401’and 课程编号 =‘A010001’

UPDATE 表1 set 姓名 =‘刘刚’,性别 = '女'，班级编号 =‘20010704’
where 学号 = '2000070404'

比如:
string sql = "update news set title=@title,body=@body where id=@id";
OleDbParameter[] para = new OleDbParameter[] {
new OleDbParameter("@title", txttitle.Text.Trim()),
new OleDbParameter("@body", this.body.Value.ToString()),
new OleDbParameter("@id",int.Parse(Request["id"].ToString()))
};
DBClass.ExecuteNonQueryCan(sql, para)

update tbl_name set courseNo='A010001',courseGrade=82 where stuNo='2000070401';
update tbl_name set stuName='刘刚',sex='女'，classNo='20010704' where stuNo='2000070401';

UPDATE youtable set score = 82 where xuehao = '2000070401’and coursenum =‘A010001’

UPDATE youtable set name =‘刘刚’,sex = '女'，classnum =‘20010704’
where xuehao = '2000070404'