首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

access,INSERT INTO 语句的语法异常

2011-12-15 
access,INSERT INTO 语句的语法错误Exception Details: System.Data.OleDb.OleDbException: INSERT INTO

access,INSERT INTO 语句的语法错误
Exception Details: System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。

C# code
protected void Button1_Click(object sender, EventArgs e)    {        hostname = Request.QueryString["id"].ToString();//全局变量,此处无错。        string str = System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["dbPath"]);        OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str);        String strSQL = "SELECT * FROM [reviews] WHERE Host='"+hostname+"'";        OleDbDataAdapter objCmd = new OleDbDataAdapter(strSQL, myConn);        DataSet ds = new DataSet();        objCmd.Fill(ds, "reviews");        if (ds.Tables["reviews"].Rows.Count == 0)        {            string myInsertQuery = "insert into reviews (t-link,t-content) values ('" + TextBox2.Text + "','" + TextBox3.Text + "')";              OleDbCommand myOleDbCommand = new OleDbCommand(myInsertQuery);            myOleDbCommand.Connection = myConn;            myConn.Open();            myOleDbCommand.ExecuteNonQuery();//显示此行出错。            myConn.Close();        }        else        {           ....        }    }


[解决办法]
把你拼接完的SQL语句打出来看看
[解决办法]
t-link,t-content不是合法的字段名, 不能有 '-'

[解决办法]
改为
insert into reviews ([t-link],[t-content]) 
试一下

热点排行