上午帖子http://community.csdn.net/Expert/topic/4362/4362905.xml?temp=.9145624
上午没有细看现在发现不抱错了 但是进不去数据库这是我response。write出来的sql语句和错误
insert into [Article] ([Title],Author,CopyFrom,[Key],UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('11','1','11','11','2005-11-1 15:28:52',True,'通过简单的数据',false,1,'','')System.Data.OleDb.OleDbErrorCollection
添加数据库代码如下:
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',1,'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();
}
问题:自己写的文字可以进数据库,从word拷过来的不行
上午没有细看现在发现不抱错了 但是进不去数据库这是我response。write出来的sql语句和错误
insert into [Article] ([Title],Author,CopyFrom,[Key],UpdateTime,Passed,Content,IncludePic,ClassID,Editor,DefaultPicUrl) values ('11','1','11','11','2005-11-1 15:28:52',True,'通过简单的数据',false,1,'','')System.Data.OleDb.OleDbErrorCollection
添加数据库代码如下:
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',1,'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();
}
问题:自己写的文字可以进数据库,从word拷过来的不行
一般word拷过来的里面垃圾很多,是不是你的字段设置的太短了?