[shado1796]

بغيت اقولك انه الكود الي كنت انا استخدمه في البحث بين تاريخين في

كود :

Dim sqlstring As String = ""

        sqlstring = "Select * from Table1 Where Date >=@Date1 And Date <=@Date2"

        Dim CMD As New OleDbCommand(sqlstring, con)
        CMD.Parameters.Clear()
        CMD.Parameters.AddWithValue("@Date1", OleDbType.VarChar).Value = CDate(TextBox1.Text)
        CMD.Parameters.AddWithValue("@Date2", OleDbType.VarChar).Value = CDate(TextBox2.Text)
        con.Open()
        Dim dr As OleDbDataReader = CMD.ExecuteReader
        If dr.HasRows Then
            Me.ListView1.Items.Clear()
            While dr.Read
                Dim LVI As ListViewItem = Me.ListView1.Items.Add(dr.Item("ID").ToString)
                LVI.SubItems.Add(dr.Item("UserName").ToString)
                LVI.SubItems.Add(dr.Item("MobileNumber").ToString)
        
            End While
        End If

        dr.Close()
        CMD.Dispose()
        con.Close()