INSERT INTO 语句的语法错误,直接通过ACCESS可以顺利执行SQL语句,但是通过ExecuteNonQuery()执行却其实语法错误,我搞了2个钟头了,实在没辙,帮帮忙!
屯屯屯 2009-04-16 02:16:30 NSERT INTO 语句的语法错误,直接通过ACCESS可以顺利执行SQL语句,但是通过ExecuteNonQuery()执行却其实语法错误,我搞了2个钟头了,实在没辙,帮帮忙!
public static void log_xieru(string text,string feifa,string ip,string user)
{
string time = System.DateTime.Now.ToString();
OleDbConnection myconn = DB.CreateDB();
myconn.Open();
string sqlstr = "INSERT INTO log_user(timeok,textok,feifa,ip,user) VALUES('" + time + "','" + text + "','" + feifa + "','" + ip + "','" + user + "')";
OleDbCommand cmd1 = new OleDbCommand(sqlstr, myconn);
cmd1.ExecuteNonQuery();
myconn.Close();
}
数据库中的字段全部为文本型的,调试sqlstr里面的内容是:INSERT INTO log_user(timeok,textok,feifa,ip,user) VALUES('2009-4-16 2:03:49','user= pas= time= ','用户使用非客户端访问','127.0.0.1',' ')
DB.log_xieru("user="+user+" pas="+pas+" time="+time,"用户使用非客户端访问",Request.ServerVariables["REMOTE_ADDR"].ToString(),user);这个是调用方法,请知道的帮帮我,谢谢了。