解决问题的方法很简单,就是把表名和字段名用[ ] 括起来即可,
现在还不知道这么解决的原因,有待查证
附:别人解决的方法
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