"yes i am using database
(access 2007)"
So, just use a query:
Dim dtStart As DateTime = dtpStartDate.Value
Dim dtEnd As DateTime = dtpEndDate.Value
Using cmd As New OleDbCommand("SELECT * FROM MyTable WHERE MyDateColumn BETWEEN @ST AND @EN", con)
cmd.Parameters.AddWithValue("@ST", dtStart)
cmd.Parameters.AddWithValue("@EN", dtEnd)
...
End Using