为什么说我的SQL语句有错?(初学者)
执行后报下面的错误:
insert into tblReply (ReID,Memo) values (2,'xxxxxxxxxx')System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
程序:
clsData.cs
__________________________________
using System;
using System.Data;
using System.Data.OleDb;
namespace clsGuest
{
/// <summary>
/// clsData 的摘要说明。
/// cslData:处理连接数据库存的代码封装。
/// </summary>
public class clsData
{
///私有成员变量申明
///connStr:连接数据库的字符串
///conn:连接数据库的对象
private string connStr;
private OleDbConnection conn;
public clsData()
{
//
// TODO: 在此处添加构造函数逻辑
//
//connStr="Provider=SQLOLEDB;server=localhost;uid=sa;pwd=hy;database=pubs";
connStr="PROVIDER=Microsoft.jet.OLEDB.4.0;data source=sysGuest.mdb";
conn=new OleDbConnection(connStr);
}
public clsData(string strConn)
{
connStr=strConn;
conn=new OleDbConnection(connStr);
}
public OleDbConnection Open()
{
conn.Open();
return conn;
}
public void Close()
{
conn.Close();
}
/*程序测试主函数
public static void Main()
{
clsData sysDb=new clsData("PROVIDER=Microsoft.jet.OLEDB.4.0;data source=sysGuest.mdb");
try
{
sysDb.Open();
Console.WriteLine("数据库已打开!");
}
catch(Exception se)
{
Console.WriteLine(se.Message.ToString());
}
finally
{
Console.WriteLine("这是连接数据库的!");
}
}*/
}
}
__________________________________________
clsReply.cs
______________________________________
using System;
using System.Data;
using System.Data.OleDb;
namespace clsGuest
{
/// <summary>
/// clsReply 的摘要说明。
/// </summary>
public class clsReply
{
private int ReID;
private int id;
private string Memo;
private string sql;
private OleDbConnection conn;
private OleDbCommand cmd;
private clsData sysData;
public clsReply()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public clsReply(int StrId,string StrMemo)
{
ReID = StrId;
Memo = StrMemo;
}
public clsReply(int StrId)
{
id=StrId;
}
public void NewReply()
{
sysData = new clsData();
conn = sysData.Open();
sql = "insert into tblReply (ReID,Memo) values (" + ReID + ",'" + Memo + "')";
Console.Write(sql);
cmd = new OleDbCommand (sql,conn);
cmd.ExecuteNonQuery();
}
public void Delete()
{
sysData = new clsData();
conn = sysData.Open();
sql = "delete from tblReply where id="+id;
cmd = new OleDbCommand(sql,conn);
cmd.ExecuteNonQuery();
}
public static void Main()
{
clsReply re=new clsReply(2,"xxxxxxxxxx");
Console.WriteLine("实例化新用户");
try
{
re.NewReply();
Console.WriteLine("记录添加成功!");
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
}
}
}
_____________________________
我执行的是clsReply.cs