22-12-16, 04:43 PM
شكرا لكم احبتى لقد بحثت على يوتيوب فيديو به هذا الكود و هو يعمل معى
Dim searchdate1 As Date = DateTimePicker1.Value
Dim searchdate2 As Date = DateTimePicker2.Value
dt.Clear()
da = New OleDbDataAdapter("select * from جدول1 where تاريخ > #" & searchdate1.Year & "/" & searchdate1.Month & "/" & searchdate1.Day & "# and تاريخ < #" & searchdate2.Year & "/" & searchdate2.Month & "/" & searchdate2.Day & "#", cn)
da.Fill(dt)
Me.DataGridView1.DataSource = dt
Dim searchdate1 As Date = DateTimePicker1.Value
Dim searchdate2 As Date = DateTimePicker2.Value
dt.Clear()
da = New OleDbDataAdapter("select * from جدول1 where تاريخ > #" & searchdate1.Year & "/" & searchdate1.Month & "/" & searchdate1.Day & "# and تاريخ < #" & searchdate2.Year & "/" & searchdate2.Month & "/" & searchdate2.Day & "#", cn)
da.Fill(dt)
Me.DataGridView1.DataSource = dt