数据库插入语句

来源:百度知道 编辑:UC知道 时间:2024/06/06 00:01:53
string gonggaoselect = "insert into liuyanban ( writer,wenzhang,date) values ('" + name + "','" + neirong + "',#" + regtime + "#)";
OleDbConnection conn = new OleDbConnection(strconn);
OleDbCommand gonggaocmd = new OleDbCommand(gonggaoselect, conn);
conn.Open();
gonggaocmd.ExecuteNonQuery();
conn.Close();

把( writer,wenzhang,date) 这句话放进去就提示说语句错误 应该没错的啊里面的逗号也是英文的逗号,
怎么回师哦

string gonggaoselect = "insert into liuyanban ( writer,wenzhang,[date]) values ('" + name + "','" + neirong + "',#" + regtime + "#)";

你调用的liuyanban里面有writer,wenzhang,date这3个字段么?
有没有定义?