OleDbConnection conn = new OleDbConnection("数据库连接字符串");
conn.Open();
OleDbCommand cmd = new OleDbCommand("", conn);
string[] chengji = Request.Form["chengji"].Split(',');
string[] XueKe = Request.Form["XueKe"].Split(',');
string[] DanYuan = Request.Form["DanYuan"].Split(',');
try
{
for (int i = 0; i < chengji.Length; i++)
{
if (string.IsNullOrEmpty(chengji[i]))
{
chengji[i] = "0";
}
//若成绩在数据表中是字符型字段的话,下面的语句改成
//cmd.CommandText = "insert into 数据表 (chenji,xueke,danyuan) values('" + chengji[i] + "','" + XueKe[i] + "','" + DanYuan[i] + "')";
cmd.CommandText = "insert into 数据表 (chenji,xueke,danyuan) values(" + chengji[i] + ",'" + XueKe[i] + "','" + DanYuan[i] + "')";
cmd.ExecuteNonQuery();
}
}
catch
{
Response.Write("数据插入出错");
}
finally
{
conn.Close();
}