22-12-16, 01:54 AM
ايضاً بإمكانك استخدام الطريقة التالية
PHP كود :
Dim pm(1) As OleDbParameter
pm(0) = New OleDbParameter("@Date1", OleDbType.Date)
pm(0).Value = DateTimePicker1.Value.Date
pm(1) = New OleDbParameter("@Date2", OleDbType.Date)
pm(1).Value = DateTimePicker2.Value.Date
da = New OleDbDataAdapter("select * from جدول1 where تاريخ between @Date1 and @Date2", cn)
da.Fill(Dt)
Me.DataGridView1.DataSource = Dt

