Question how can I view data between two date on DataGridView

[allaith1985]

hi

I need your help

when I want show data on DataGridView I use this (SQL) sentence

sql="select c_no,c_name from operations where c_date between " & textbox1.text & " and " & textbox2.text & " "

textbox1.text=DateTimepicker1.value
textbox2.text=DateTimepicker1.value

I use Access database

but I have wrong on sql sentence

please

 

[cjard]

read the DW2 link in my signature, section on "Creating a Form To Search Data"