07-03-13, 03:28 AM
بغيت اقولك انه الكود الي كنت انا استخدمه في البحث بين تاريخين في
كود :
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()
