我想从Visual Studio 2015中过滤我的数据

Question

我想以日期为主要条件对数据库中的数据进行排序，其中 2 个日期时间选择器 1 作为开始日期，另一个作为此代码的限制，但我不知道正确的查询形式...我的从看起来像这样，第一个DTP名称是DTPDari和第二个DTPSampai

Call KONEKSI()
CMD = New OleDbCommand("SELECT * FROM Pembayaran where tanggal_pembayaran BEETWEEN '" & DTPDari.Value & "'AND tanggal_pembayaran = '" & DTPSampai.Value & "'", CONN)
DR = CMD.ExecuteReader
DR.Read()`

Answer 1

从我从您的问题中了解到的一点点，您可以使用以下任何一种

(语法未测试(

SELECT * FROM Pembayaran where tanggal_pembayaran
WHERE        (tanggal_pembayaran BETWEEN '" & DTPDari.Value & "' AND '" & DTPSampai.Value & "')

或

SELECT * FROM Pembayaran where tanggal_pembayaran   
WHERE        (tanggal_pembayaran > '" & DTPDari.Value & "') and    (tanggal_pembayaran < '" & DTPSampai.Value & "') 

根据您的要求添加函数示例

Sub GetDetails()

Dim connectionString As String = ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString.ToString()
Dim connection As New SqlConnection(connectionString)
Dim queryString2 = "SELECT       *
FROM            dbo.Customers
WHERE        (CreationDate BETWEEN @param1 AND @param2)"
Dim cmd As SqlCommand = New SqlCommand()
cmd.CommandText = queryString2
cmd.Connection = connection
cmd.Parameters.AddWithValue("@Param1", from_DateTimePicker.Value.Date)
cmd.Parameters.AddWithValue("@param2", to_DateTimePicker.Value.Date)
connection.Open()
Dim reader As SqlDataReader = cmd.ExecuteReader()
While reader.Read()
Console.WriteLine("{0}", reader(0))
'here fill on datatable Or anything you want
End While
connection.Close()
End Sub