C# INSERT INTO 语句的语法错误,求解!!!
string con1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ...\data\fileinfosys.mdb;Persist Security Info=False;Jet OLEDB:Database Password=123;";
string constring = "INSERT INTO [item_directory](id,name,superior,finished,no,pno) VALUES(" + ite.Id + ",'" + ite.Name.ToString() + "'," + ite.Superior + "," + ite.Finished + ",'" + ite.No.ToString() + "','" + ite.ParentNo.ToString() + "')";
OleDbConnection dbCon = new OleDbConnection(con1);
OleDbCommand dbCmd = new OleDbCommand(constring, dbCon);
try
{
dbCon.Open();
dbCmd.ExecuteNonQuery();
}
运行提示:INSERT INTO 语句的语法错误!
求解?
谢谢!