C#中使用ACCESS插入语法出错

来源：互联网发布：手机焓湿图计算软件编辑：程序博客网时间：2024/05/16 15:58

解决问题的方法很简单，就是把表名和字段名用[ ] 括起来即可，

现在还不知道这么解决的原因，有待查证

附：别人解决的方法

string sql = "INSERT INTO [YTC] ([ID],[Contours],[HalfContours]) VALUES(@ID,@C,@H)";
          SQLiteConnection connection = new SQLiteConnection(@"Data Source=d:/我的文档/Visual Studio 2008/Projects/WriteConoursToDB/WriteConoursToDB/bin/Debug/NewDB.sqlite");
          connection.Open();
          SQLiteTransaction transaction = connection.BeginTransaction();
          SQLiteCommand command = new SQLiteCommand(sql, connection);
          command.Parameters.Add(new SQLiteParameter("@ID", DbType.Int32));
          command.Parameters.Add(new SQLiteParameter("@C", DbType.String));
          command.Parameters.Add(new SQLiteParameter("@H", DbType.String));
          command.Parameters["@ID"].Value = 4587;
          command.Parameters["@C"].Value = Value;
          command.Parameters["@H"].Value = Value;
          command.ExecuteNonQuery();
          transaction.Commit();
          command.Dispose();
          connection.Close();
          connection.Dispose();
          transaction.Dispose();

http://bbs.csdn.net/topics/350011055

2015-01-07

0 0