我想写一个添加学生信息的程序,链接的是access数据库,然后运行点击之后说我INSERT INTO 语句的语法错误。想请大家帮我看看我的代码哪里不对。。。
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = Base.DBCon();
conn.Open();
String sql = "insert into 学生表(学号,姓名,性别,年级,专业,密码)values('"+TextBox1.Text + "','"+TextBox2.Text+"','"+ TextBox3.Text+"','"+TextBox4.Text+"','"+TextBox5.Text+"','"+TextBox6.Text+"',)";
OleDbCommand comm = new OleDbCommand(sql, conn);
comm.ExecuteNonQuery();
int flag = comm.ExecuteNonQuery();
if (flag > 0)
{
Response.Write("<script>alert('添加成功');location='XueShengTianJia.aspx'</script>");
}
else
{
Response.Write("<script>alert('添加失败');location='XueShengTianJia.aspx'</script>");
}
con.Close();
}