如图,这是我的数据库,名字叫student;表名叫information;我想输入学号stuno(例001),点击确定按钮,Label能显示001的成绩mark。
用VS2010编译的,数据库是SQL 2008.
protected void Button1_Click(object sender, EventArgs e)
{
string mark = this.TextBox1.Text; //获取学号
string select_sql = "select information set stuno='" + mark + "'where stuno='" + mark + "'";
OperateDataBase odb = new OperateDataBase();
bool select_data = odb.ExceSql(select_sql);
......
}
这里面应该怎么写呀