语法错误 (操作符丢失) 在查询表达式 ''<a href="http://cn.stareastnet.com/images2/User_pic/2004-12-31-9-41491.jpg" target=_blank><IMG SRC="http://cn.stareastnet.com/images2/User_pic/2004-12-31-9-41491.jpg" border=0 alt=?????????? onload="javascript:if(this.width>screen.width*0.6) {this.resize' 中。
请问怎么解决???string ArticleGutse=chacks.ToUbb(FreeTextBox1.Text);
string TB_ArticleNamese=chacks.ToUbb(TB_ArticleName.Text);
string connstr9 = ConfigurationSettings.AppSettings["conString"];
OleDbConnection conn9 = new OleDbConnection(connstr9);
string OleDb9="insert into TB_Article (TB_ArticleGut,TB_ArticleFace,TB_ArticleName,TB_ArticleClass,TB_ArticleMotif,TB_ArticleTime,TB_ArticleLookNo,TB_ArticleRevertNo,TB_ArticleUser,TB_ArticleLastRevertTime) values ('"+ArticleGutse+"','"+RadioButtonList1.SelectedItem.Value+"','"+huati.SelectedValue.ToString()+""+TB_ArticleNamese+"','"+TB_bbsClassIDse.Text+"','1','"+shijian.Text+"','0','0','"+TB_UserName1.Text+"','"+shijian.Text+"')";
OleDbCommand cmd9 = new OleDbCommand(OleDb9 , conn9);
conn9.Open();
cmd9.ExecuteNonQuery();
conn9.Close();'"+huati.SelectedValue.ToString()+""+TB_ArticleNamese+"'
这个是整个一个字段
就是说如果ArticleGutse不含有代码的话可以插入的
只要含有源代码 就会出错
请问怎么解决???string ArticleGutse=chacks.ToUbb(FreeTextBox1.Text);
string TB_ArticleNamese=chacks.ToUbb(TB_ArticleName.Text);
string connstr9 = ConfigurationSettings.AppSettings["conString"];
OleDbConnection conn9 = new OleDbConnection(connstr9);
string OleDb9="insert into TB_Article (TB_ArticleGut,TB_ArticleFace,TB_ArticleName,TB_ArticleClass,TB_ArticleMotif,TB_ArticleTime,TB_ArticleLookNo,TB_ArticleRevertNo,TB_ArticleUser,TB_ArticleLastRevertTime) values ('"+ArticleGutse+"','"+RadioButtonList1.SelectedItem.Value+"','"+huati.SelectedValue.ToString()+""+TB_ArticleNamese+"','"+TB_bbsClassIDse.Text+"','1','"+shijian.Text+"','0','0','"+TB_UserName1.Text+"','"+shijian.Text+"')";
OleDbCommand cmd9 = new OleDbCommand(OleDb9 , conn9);
conn9.Open();
cmd9.ExecuteNonQuery();
conn9.Close();'"+huati.SelectedValue.ToString()+""+TB_ArticleNamese+"'
这个是整个一个字段
就是说如果ArticleGutse不含有代码的话可以插入的
只要含有源代码 就会出错
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= " +Server.MapPath(Request.ApplicationPath+"\\jinxc.mdb") ;
OleDbCommand cmd = conn.CreateCommand ();
cmd.CommandText = "select * from area";
OleDbDataAdapter mysqldataadapter;
mysqldataadapter = new OleDbDataAdapter ();
DataSet mydataset;
mydataset = new DataSet();
OleDbCommandBuilder mysqlcommandbuilder;
mysqlcommandbuilder = new OleDbCommandBuilder (mysqldataadapter);
mysqldataadapter.SelectCommand = cmd;
mysqldataadapter.Fill(mydataset,"area");
DataTable mydatatable;
mydatatable = mydataset.Tables["area"];
DataGrid1.DataSource = mydatatable;
DataGrid1.DataBind();
conn.Dispose ();
conn.Close ();