数据操作代码如下
//string strSQL1="insert into Article (Title,Author,CopyFrom,Key,UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('"+strTitle+"','"+strAuthor+"','"+strCopyFrom+"','"+strKey+"','"+DataTime+"',"+strpassed+",'"+s+"',"+strIncludePic+","+strClassID+",'"+strEditor+"','"+strDeaultPicUrl+"')";
string strCon="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+
Server.MapPath("database\\mypower3511.mdb")+";";
OleDbConnection Con=new OleDbConnection(strCon);
Con.Open();
//Response.Write(strSQL1);
string strSQL1="insert into Article (Title,Author,CopyFrom,Key,UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35',True,'sfd12',false,1,'888','') ";
Response.Write(strSQL1);
OleDbCommand Cmd1=new OleDbCommand(strSQL1,Con);
try {
Cmd1.ExecuteNonQuery();
}
catch(System.Data.OleDb.OleDbException a)
{
Response.Write(a.Errors.ToString());
}
finally
{
Con.Close();
}
错误提示如下:
werwerwerwerinsert into Article (Title,Author,CopyFrom,Key,UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35',True,'sfd12',false,1,'888','') System.Data.OleDb.OleDbErrorCollection
我把sql语句注释掉了,用下面的那个取到值后的语句直接插入的。数据库无反应。声明此语句直接在数据库的分析器中执行无错误。
//string strSQL1="insert into Article (Title,Author,CopyFrom,Key,UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('"+strTitle+"','"+strAuthor+"','"+strCopyFrom+"','"+strKey+"','"+DataTime+"',"+strpassed+",'"+s+"',"+strIncludePic+","+strClassID+",'"+strEditor+"','"+strDeaultPicUrl+"')";
string strCon="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+
Server.MapPath("database\\mypower3511.mdb")+";";
OleDbConnection Con=new OleDbConnection(strCon);
Con.Open();
//Response.Write(strSQL1);
string strSQL1="insert into Article (Title,Author,CopyFrom,Key,UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35',True,'sfd12',false,1,'888','') ";
Response.Write(strSQL1);
OleDbCommand Cmd1=new OleDbCommand(strSQL1,Con);
try {
Cmd1.ExecuteNonQuery();
}
catch(System.Data.OleDb.OleDbException a)
{
Response.Write(a.Errors.ToString());
}
finally
{
Con.Close();
}
错误提示如下:
werwerwerwerinsert into Article (Title,Author,CopyFrom,Key,UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('f','f','s','sf','2005-10-26 16:29:35',True,'sfd12',false,1,'888','') System.Data.OleDb.OleDbErrorCollection
我把sql语句注释掉了,用下面的那个取到值后的语句直接插入的。数据库无反应。声明此语句直接在数据库的分析器中执行无错误。
解决方案 »
- 数据库读取显示的问题
- 如何让数据控件绑定时显示编辑页面?
- 如何在代码页中取非服务器端的控件名称呢?。。。。。。。急呐。。。。。谢谢各位啦。。。。。
- 页面问题
- 后台 赋前台的值
- 用Jmail做过邮件发送程序的帮下忙,奇怪的问题.在线等了
- 怎么样在JAVASCRIPT中调用ASP.NET的后台涵数
- 焦头烂眼: 无耐的发现一个用现有.NET控件无法实现的两栏流布局, 哪位高手能解决叩三个响头, 绑你为师? 不信邪?
- 用UrlRewriter.Net模块实现url重写,传递多个参数的问题。试了好种组合都不行。
- 级联菜单下拉列表框怎么做什么来?谢谢!
- 问一下ViewState怎么用?
- 求.net聊天室源码 谢谢
values ('f','f','s','sf','2005-10-26 16:29:35','1','sfd12','0',1,'888','')