OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"); conn.Open(); string cmdtxt = "Update users set rq=@rq"; OleDbCommand cmd = new OleDbCommand(cmdtxt, conn); cmd.Parameters.Add("@rq", OleDbType.DBDate).Value = DateTime.Now; cmd.ExecuteNonQuery();
还是不行额 insert into cl_article(channelid,classid,title,fonttype,fontcolor,ontop,hot,editor,[content],updatetime,status,deleted,hits,islink,htmlfileurl,picurl,specialid,keyword,infomoney,backpoint,backpointrate,backmoney,backmoneyrate,[receive])values(1,1,'测试',0,'',0,0,'1','测试','2009-10-25 00:00:00',1,0,0,0,'','',0, '技术',0,0,0,0,0,0) 数据库连接没问题的,就是提示: System.Data.OleDb.OleDbException: 多步 OLE DB 操作产生错误。如果可能,请检查每个 OLE DB 状态值。没有工作被完成。
insert into cl_article(channelid,classid,title,fonttype,fontcolor,ontop,hot,editor,[content],updatetime,status,deleted,hits,islink,htmlfileurl,picurl,specialid,keyword,infomoney,backpoint,backpointrate,backmoney,backmoneyrate,[receive])values(1,1,'测试',0,'',0,0,'1','测试','2009-10-25 00:00:00',1,0,0,0,'','',0, '技术',0,0,0,0,0,0)
OleDbParametar time=new OleDbParametar("@time","#"+DateTime.Now.ToString()+"#");
这样写吗?
conn.Open();
string cmdtxt = "Update users set rq=@rq";
OleDbCommand cmd = new OleDbCommand(cmdtxt, conn);
cmd.Parameters.Add("@rq", OleDbType.DBDate).Value = DateTime.Now;
cmd.ExecuteNonQuery();
insert into cl_article(channelid,classid,title,fonttype,fontcolor,ontop,hot,editor,[content],updatetime,status,deleted,hits,islink,htmlfileurl,picurl,specialid,keyword,infomoney,backpoint,backpointrate,backmoney,backmoneyrate,[receive])values(1,1,'测试',0,'',0,0,'1','测试','2009-10-25 00:00:00',1,0,0,0,'','',0, '技术',0,0,0,0,0,0)
数据库连接没问题的,就是提示:
System.Data.OleDb.OleDbException: 多步 OLE DB 操作产生错误。如果可能,请检查每个 OLE DB 状态值。没有工作被完成。