我在access数据库里建了张表如下:
用户表:
UID 自动编号 (主键)
User 文本
PWD 文本
state 文本
EnterTime 日期/时间
OutTime 日期/时间sql语句如下:string strSQL = "";
strSQL = strSQL + "INSERT INTO [用户表]([User],[PWD],[state],[EnterTime],[OutTime]) ";
strSQL = strSQL + "VALUES('" + this.txt_name.Text + "', ";
strSQL = strSQL + " '" + this.txt_pwd.Text + "', ";
strSQL = strSQL + " '0', ";
strSQL = strSQL + " '" + DateTime.Now.ToLongDateString() + "', ";
strSQL = strSQL + " '')";
怎么老是说标准表达式中数据类型不匹配啊?还有,再问下 insert 语句一定要把字段名都列出来吗?
用户表:
UID 自动编号 (主键)
User 文本
PWD 文本
state 文本
EnterTime 日期/时间
OutTime 日期/时间sql语句如下:string strSQL = "";
strSQL = strSQL + "INSERT INTO [用户表]([User],[PWD],[state],[EnterTime],[OutTime]) ";
strSQL = strSQL + "VALUES('" + this.txt_name.Text + "', ";
strSQL = strSQL + " '" + this.txt_pwd.Text + "', ";
strSQL = strSQL + " '0', ";
strSQL = strSQL + " '" + DateTime.Now.ToLongDateString() + "', ";
strSQL = strSQL + " '')";
怎么老是说标准表达式中数据类型不匹配啊?还有,再问下 insert 语句一定要把字段名都列出来吗?
string strSQL = "";
strSQL = strSQL + "INSERT INTO [用户表]([User],[PWD],[state],[EnterTime],[OutTime]) ";
strSQL = strSQL + "VALUES('" + this.txt_name.Text + "', ";
strSQL = strSQL + " '" + this.txt_pwd.Text + "', ";
strSQL = strSQL + " '0', ";
strSQL = strSQL + " #" + DateTime.Now.ToLongDateString() + "#, ";
strSQL = strSQL + " '')";
访问我的博客 程序员日记 http://www.ideaext.com
insert into A(name, date) values("1", #2009-1-20#)