asp.net 添加数据

来源：百度知道 编辑：UC知道 时间：2024/07/04 07:57:58
这段代码 在插入日期的时候老是有错误 我数据库里面的类型是日期类型，
string Username=Request.Form["name"];
string Content=Request.Form["content"];
string strDb="db.mdb";
DateTime pubdate=System.DateTime.Now.Date;
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
strConnection+=Server.MapPath(strDb);
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand("insert into message (content,name,time) Values ('"+Content.ToString()+"','"+Username.ToString()+"''"+pubdate+"')" , objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();
我用的是 access 数据库 用asp.net 写的下面的sql 语句有什么问题啊，怎么老是错误
insert into message (content,name,time) Values ('"+Content.ToString()+"','"+Username.ToString()+"',now())

string Username=Request.Form["name"];
string Content=Request.Form["content"];
string strDb="db.mdb";
DateTime pubdate=System.DateTime.Now.Date;
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
strConnection+=Server.MapPath(strDb);
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand("insert into message(content,name,time)Values('"+Content+"','"+Username+"',#"+pubdate+"#)" , objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();

把OleDbCommand objCommand = new OleDbCommand("insert into message (content,name,time) Values ('"+Content.ToString()+"','"+Username.ToString()+"''"+pubdate+"')" , objConnection);
换为
OleDbCommand objCommand = new OleDbCommand("insert into mes