请教高手：“insert into 语句语法错误”是什么意思？

Question

Insert 语句在语法上有错误！

Answer 1

试着把你的Sql语句发出来看一下。

Answer 2

把你的sql语句发出来,,大家才能帮忙

Answer 3

insert into [表名](列名1,列名2...) values (值1,值2...)

Answer 4

thisConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\C#\Access\特采计算.mdb";
            thisAdapter = new OleDbDataAdapter("SELECT * FROM 条带采留宽设计", thisConnection);
            OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
            thisAdapter.Fill(thisDataSet, "条带采留宽设计");            //返回记录数
            int count = thisDataSet.Tables["条带采留宽设计"].Rows.Count;            DataRow thisRow = thisDataSet.Tables["条带采留宽设计"].NewRow();
            //给"编号"列添加值
            if (count == 0)
            {
                thisRow["方案"] = 1;
            }
            else
            {
                DataRow lastRow = thisDataSet.Tables["条带采留宽设计"].Rows[count - 1];//找“编号”列最后一行的数值，得下一行行号
                thisRow["方案"] = Convert.ToInt32(lastRow["方案"]) + 2;
            }            //DataRow indexRow=this.thisDataSet.Tables["下载文章记录"].Rows.Find("89");            thisRow["采宽b(m)"] = 2;
            thisRow["留宽a(m)"] = 2;
            thisRow["采深H(m)"] = 2;
            thisRow["采厚M(m)"] = 2;
            thisRow["煤柱强度"] = 2;
            thisRow["煤柱载荷"] = 2;
            thisRow["安全系数K"] = 2;
            thisRow["煤柱宽高比"] = 2;
            thisRow["煤柱核区率"] = 2;
            thisRow["采出率"] = 2;            thisDataSet.Tables["条带采留宽设计"].Rows.Add(thisRow);            thisAdapter.Update(thisDataSet, "条带采留宽设计");            thisConnection.Close();            DataGridView条带采留宽设计.DataSource = thisDataSet.Tables["条带采留宽设计"];

Answer 5

"insert   into   [表名](列名1,列名2...)   values   (值1,值2...)"
如果值是变量得话应该
"insert   into   [表名](列名1,列名2...)   values   ('"+值1+"','"+值2..."')"

Answer 6

上面就是我写的sql语句，请问高人，有什么错误啊？急！！！！！

Answer 7

程序运行到thisAdapter.Update(thisDataSet,   "条带采留宽设计"); 时，就提示：“insert   into   语句语法错误”，请教高人，这是什么意思啊？

Answer 8

insert       into       [表名] (列名1,列名2...)       values       ('"+值1+"','"+值2..."')

Answer 9

数据库的数据类型和要赋的值是相符的啊，怎么还是报错：：“insert       into       语句语法错误”？急！！！！

Answer 10

private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection thisConnection = new OleDbConnection();
            DataSet thisDataSet=new DataSet();            thisDataSet.Clear();
            thisConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\C#\Access\特采计算.mdb";
            OleDbDataAdapter thisAdapter = new OleDbDataAdapter("Select * from 条带采留宽设计", thisConnection);
            OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
            thisAdapter.Fill(thisDataSet, "条带采留宽设计");            DataRow thisRow = thisDataSet.Tables["条带采留宽设计"].NewRow();
            thisRow["方案"] = 1;
            thisRow["采宽b(m)"] = "1";
            thisRow["留宽a(m)"] = "1";
            thisRow["采深H(m)"] = "1";
            thisRow["采厚M(m)"] = "1";
            thisRow["煤柱强度"] = "1";
            thisRow["煤柱载荷"] = "1";
            thisRow["安全系数K"] = "1";
            thisRow["煤柱宽高比"] = "1";
            thisRow["煤柱核区率"] = "1";
            thisRow["采出率"] = "1";
            thisDataSet.Tables["条带采留宽设计"].Rows.Add(thisRow);
            thisAdapter.Update(thisDataSet, "条带采留宽设计");///////运行到这个语句时就报错：insert into 语句语法错误　　　　         
 thisConnection.Close();
            条带采留宽设计DataGridView.DataSource = thisDataSet.Tables["条带采留宽设计"];        }