回 帖 发 新 帖 刷新版面

主题:INSERT INTO 语句的语法错误。-郁闷呀

代码如此简单:
String strCon="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+
        Server.MapPath("mypower3511.mdb")+";";
OleDbConnection Con=new OleDbConnection(strCon);
string strSQL1="insert into [Article] (Title,Author,CopyFrom,Key,UpdateTime,Content,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35','sfd',1,'888','wer') ";
Response.Write(strSQL1);
OleDbCommand Cmd1=new OleDbCommand(strSQL1,Con);
Cmd1.Connection.Open();
try     
{
  Cmd1.ExecuteNonQuery();
}
catch(Exception ex)
{
  Response.Write("error11");
            
  System.Web.HttpContext.Current.Response.Write(ex.ToString());
}
finally
{
 Cmd1.Connection.Close();
}

错误信息如下:
insert into [Article] (Title,Author,CopyFrom,Key,UpdateTime,Content,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35','sfd',1,'888','wer') error11System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at webs.login.btn_login_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\hebjs\webs\login.aspx.cs:line 102

解释:sql语句在access库中执行正确,没有任何问题,数据权限也没有问题,但是.net执行就总是出现以上错误[em7]

回复列表 (共3个回复)

沙发

[em7][em6][em7][em7][em7]
向各位求救呀

板凳

string strSQL1="insert into [Article] (Title,Author,CopyFrom,Key,UpdateTime,Content,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35','sfd',1,'888','wer') ";


不用中括号,少个列段




不懂啊,问其他人

3 楼


问题解决了。字段名的事。字段名key 与.net 的保留字冲突了。

我来回复

您尚未登录,请登录后再回复。点此登录或注册