如何在vb.net的mysql中使用Between进行搜索?
我试过一些代码,但不起作用。
这是示例数据库:
___________________________
| date |
-----------------------------
|Wednesday, December 4, 2013|
-----------------------------
here is my code in vb.net:
Dim sqlquery As String = "SELECT * FROM complaint WHERE date BETWEEN '" & dtepicker1.text & "' and '" & dtepicker2.text & "'"
Dim sqlcmd As New MySqlCommand
With sqlcmd
.CommandText = sqlquery
.Connection = connectionsrvr
End With
尝试。。
"SELECT * FROM complaint WHERE date BETWEEN '" & dtepicker1.Value & "' and '" & dtepicker2.Value & "'"
和另一种选择
"从投诉中选择*WHERE date>'"&dtepicker.text&"'与日期<'"&dtepicker2.text&"'"