插入查询错误在插入sql语句时显示语法错误 [英] Insert query errors shows Syntax error in insert into sql statement

问题描述

我尝试了几次，但它显示错误。它无效。



保存代码如下。

I tried several times but it shows the error.it is not working.

Save Code as follows.

for (int i = 0; i < DGV_Fac_SMS.RowCount; i++)
{
      sql = "insert into Tb_Faculty_Schedule_Timetable [Name],[Mobile No],[Message];
      sql = sql + " values ( '" + (DGV_Fac_SMS.Rows[i].Cells[0].Value.ToString()) + "','" + (DGV_Fac_SMS.Rows[i].Cells[1].Value.ToString()) + "','" + (DGV_Fac_SMS.Rows[i].Cells[2].Value.ToString()) + "')";

      GFun.Error = " ";
      GFun.InsertAccessData(sql);
      if (GFun.Error.ToString() != "")
      {
             MessageBox.Show(GFun.Error.ToString(), "Error");
             return;
      }

      GFun.OleDbCon.Close();
  
      MessageBox.Show("Record Inserted Successfully", "Records Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

当我点击保存按钮时，错误显示如下。


$ b插入到sql语句中的$ b

When I click the save button, error shows as follows.

syntax error in  insert into sql statement.

插入查询中的错误是什么？

我试了几次，但是显示错误。

What is the mistake in insert query ?
I tried several times, but it shows the error.

推荐答案

你做完了......

You have done...

sql = "insert into Tb_Faculty_Schedule_Timetable [Name],[Mobile No],[Message];

sql = sql + " values ( '" + (DGV_Fac_SMS.Rows[i].Cells[0].Value.ToString()) + "','" + (DGV_Fac_SMS.Rows[i].Cells[1].Value.ToString()) + "','" + (DGV_Fac_SMS.Rows[i].Cells[2].Value.ToString()) + "')";

- >在第一行代码中，您最后错过了报价在分号之前，由 @Jegan Thiyagesan 说。



所以，它应该变成......

-> In first line of code, you missed a quote at last before semicolon as said by @Jegan Thiyagesan.

So, it should become...

sql = "insert into Tb_Faculty_Schedule_Timetable [Name],[Mobile No],[Message]";

sql = sql + " values ( '" + (DGV_Fac_SMS.Rows[i].Cells[0].Value.ToString()) + "', '" + (DGV_Fac_SMS.Rows[i].Cells[1].Value.ToString()) + "','" + (DGV_Fac_SMS.Rows[i].Cells[2].Value.ToString()) + "')";

正确并告诉我们是否有帮助。

谢谢...

Correct and let us know it helped or not.
Thanks...

这篇关于插入查询错误在插入sql语句时显示语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！