Hi
I am using access database , vb.net
to filter my datagridview I used
Sales_ItemsDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_Items.Select(("Convert(category, 'System.String') LIKE '" & search2 & "'")
now my problem
my date is string in the Database
date format is 31/12/2001
and i want to filter the dategridview between 2 dates so i uesed
Sales_ListDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_List.Select(("Convert(invoice_date, 'System.String') <= '" & DateTimePicker2.Value & "' AND Convert(invoice_date, 'System.String') >= '" & DateTimePicker1.Value & "'"))
but sure that gave me funny results as it considered the date as string...
but i failed to change the
("Convert(invoice_date, 'System.String')
to date format
can any one help Please.....