我想用DTPICKER控件查询SQL数据库中的数据.请问如果查询某个时间段内的数据语句应该怎么写,比如要查询:2008-1-3到2008-1-6之间的.(日期是由DTPICKER控件获取的)
下面是我的代码.
Private Sub Command1_Click()
Adodc1.RecordSource = "select * from 状态数据 where (时间 like '%" & (DTPicker1.Value) & "%')"
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
If Adodc1.Recordset.EOF Then
MsgBox "无此记录"
Text1.Text = ""
Exit Sub
End If
小弟刚接触VB一些语句不太明白,希望各位高手指点一下.谢谢~~
下面是我的代码.
Private Sub Command1_Click()
Adodc1.RecordSource = "select * from 状态数据 where (时间 like '%" & (DTPicker1.Value) & "%')"
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
If Adodc1.Recordset.EOF Then
MsgBox "无此记录"
Text1.Text = ""
Exit Sub
End If
小弟刚接触VB一些语句不太明白,希望各位高手指点一下.谢谢~~
DTPicker1.value & "' and '" & _
DTPicker2.value & " 23:59:59'"