我想向access的reader表中插入一条记录
表reader的结构为 :
readerID(主键) 文本
readerName 文本
readerPassword 文本
readerPhone 文本
readerStartTime 时间/日期 只有这个允许空
主要的代码如下:
using SDO = System.Data.OleDb;
string sConncet = string.Format("Provider={0};Data Source={1}{2}", "Microsoft.Jet.OLEDB.4.0;", System.AppDomain.CurrentDomain.BaseDirectory, "Library.mdb");
SDO.OleDbConnection dbConn = null;
dbConn = new SDO.OleDbConnection(sConncet);
dbConn.Open();
SDO.OleDbCommand dbCmd;
string sql;
public void createCmd(string table, string rID, string rname, string rpwd, string rphone)
{
sql = "insert into" + " " + table + " " + "values" + "(" + "'" + rID + "'" + "," + "'" + rname + "'" + "," + "'" + rpwd + "'" + "," + "'" + rphone + "'" + "," + "'" + DateTime.Now + "'" + ")" + " " + "go";
}
dbCmd = new SDO.OleDbCommand(sql, dbConn);
dbConn.Close();