环境 asp.net / Access / c#string curTime1 = System.DateTime.Today.ToLongDateString().ToString() // X年X月X日的格式
...........
string check = "SELECT [date] FROM [table1] WHERE [date] = '" + curTime1 + "'";
...........
OleDbCommand comcheck = new OleDbCommand(check, conncheck);
OleDbDataReader drcheck = comcheck.ExecuteReader(); //这里出错
...........我从数据库里找出与curTime1相同内容的数据,然后提示出错:
System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。请问哪里错了 谢谢...
...........
string check = "SELECT [date] FROM [table1] WHERE [date] = '" + curTime1 + "'";
...........
OleDbCommand comcheck = new OleDbCommand(check, conncheck);
OleDbDataReader drcheck = comcheck.ExecuteReader(); //这里出错
...........我从数据库里找出与curTime1相同内容的数据,然后提示出错:
System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。请问哪里错了 谢谢...
string check = "SELECT [date] FROM [table1] WHERE convert(varchar(10),[date],21) = '" + curTime1 + "'";
...........
string check = "SELECT [date] FROM [table1] WHERE [date] = '" + curTime1 + "'";====》》string check = "SELECT [date] FROM [table1] WHERE [date] = getdate();
你的[data]是int类型??