Currently I have a button, 2 datetimepickers, a datagridview, and a combobox. What I like to do is the user will select the FromDate and ToDate and then with a keyword from a combobox it will search in a datagridivew according to the date range and the combobox's value.
I already implemented a search function for the combobox in the button click event:
Dim con As New OleDbConnection(Get_Constring) Dim dt As New DataTable con.Open() Dim da As New OleDbDataAdapter("SELECT * from EncodingComplete where Client like '" & ComboBox1.Text & "%'", con) da.Fill(dt) DataGridView1.DataSource = dt con.Close()
How would I code the date range?