OleDbDataAdapter1.SelectCommand.Parameters.Add()的问题。。。。。。。。急求 50分

[MoonXia]

OleDbDataAdapter1.SelectCommand.Parameters.Add("@时间", System.Data.OleDb.OleDbType.Date)
OleDbDataAdapter1.SelectCommand.Parameters("@时间").Value = DateTimePicker1.Value
OleDbDataAdapter1.SelectCommand.CommandText = "SELECT classroom_Info.* FROM classroom_Info WHERE(时间 = ?)"


请问这几句话对不对？？？

[greystar]

使用oledb的话,那参数没有名称为?


OleDbDataAdapter1.SelectCommand.CommandText = "SELECT classroom_Info.* FROM classroom_Info WHERE(时间 = ?)"

OleDbDataAdapter1.SelectCommand.Parameters.Add(System.Data.OleDb.OleDbType.Date)
OleDbDataAdapter1.SelectCommand.Parameters(0).Value = DateTimePicker1.Value

应该是这样吧

[ejoe313]

WHERE(时间 = @时间)

[MoonXia]

不是SQL语言问题

[MoonXia]

执行时没有出错，只是执行之后。。Datagrid没有显示我要的东西

[wuyq11]

OleDbDataAdapter1.SelectCommand.Parameters.Add("@DE", System.Data.OleDb.OleDbType.Date)
OleDbDataAdapter1.SelectCommand.Parameters("@DE").Value = DateTimePicker1.Value
OleDbDataAdapter1.SelectCommand.CommandText = "SELECT * FROM classroom_Info WHERE(时间 =@DE)"

[wuyq11]

DateTimePicker1.Value.Date

[wangjuenhui520]

"@时间" 不是数值 或真正的时间格式的时候建议使用 '' 把 @时间圈起来
如下:
OleDbDataAdapter1.SelectCommand.Parameters.Add("@DE", System.Data.OleDb.OleDbType.Date)
OleDbDataAdapter1.SelectCommand.Parameters("@DE").Value = DateTimePicker1.Value
OleDbDataAdapter1.SelectCommand.CommandText = "SELECT * FROM classroom_Info WHERE(时间 ='@DE')"

或直接使用:
时间格式
oledbdataadapter1.selectcommand.commandtext = "select * From classroom_info where(时间="@DateTimePicker1.Value @")"

其他格式

oledbdataadapter1.selectcommand.commandtext = "select * From classroom_info where(时间='"@DateTimePicker1.Value @"')"

[MoonXia]

谢谢你啊。。。。。。我弄出来了。

改成你写的
DateTimePicker1.Value.Date
就可以了