string strConn, strSQL;
strConn = "Provider=Microsoft.JET.OLEDB.4.0;" + "data source=" + Server.MapPath("..\\app_data\\xsb.mdb");
OleDbConnection sqlconnet2 = new OleDbConnection(strConn);
sqlconnet2.Open();
//////////////////////////////////////////////
strSQL = "select sum(分值) from xsb where 班级='初一(1)班' and 星期=1 and 周次=" + TextBox1.Text;
OleDbCommand sqlcom2 = new OleDbCommand(strSQL, sqlconnet2);
fen[1,1] = sqlcom2.ExecuteScalar().ToString();
//////////////////////////////////////////////
strSQL = "select sum(分值) from xsb where 班级='初一(2)班' and 星期=1 and 周次=" + TextBox1.Text;
sqlcom2 = OleDbCommand(strSQL, sqlconnet2);
fen[2, 1] = sqlcom2.ExecuteScalar().ToString();
/////////////////////////////////////////////
红色这句话错误,请教各位大侠如何改,谢谢!
strConn = "Provider=Microsoft.JET.OLEDB.4.0;" + "data source=" + Server.MapPath("..\\app_data\\xsb.mdb");
OleDbConnection sqlconnet2 = new OleDbConnection(strConn);
sqlconnet2.Open();
//////////////////////////////////////////////
strSQL = "select sum(分值) from xsb where 班级='初一(1)班' and 星期=1 and 周次=" + TextBox1.Text;
OleDbCommand sqlcom2 = new OleDbCommand(strSQL, sqlconnet2);
fen[1,1] = sqlcom2.ExecuteScalar().ToString();
//////////////////////////////////////////////
strSQL = "select sum(分值) from xsb where 班级='初一(2)班' and 星期=1 and 周次=" + TextBox1.Text;
sqlcom2 = OleDbCommand(strSQL, sqlconnet2);
fen[2, 1] = sqlcom2.ExecuteScalar().ToString();
/////////////////////////////////////////////
红色这句话错误,请教各位大侠如何改,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货