我用的的是access数据库 插入数据提示inset into 语法错误,我知道是插入发布日期那里有问题但是不知道什么问题
sql 语句 我在access里面执行没有什么问题啊string Username=Request.Form["name"];
string Content=Request.Form["content"];
string strDb="db.mdb";
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()+"',date() )" , objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();
sql 语句 我在access里面执行没有什么问题啊string Username=Request.Form["name"];
string Content=Request.Form["content"];
string strDb="db.mdb";
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()+"',date() )" , objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();
date()-->getdate()吧?
你还可以用datetime.now.toString(),C#里的