Get the selected Month as '1','2',...'10','11' , etc from the list box. Query the dataSource for PurchaseDate in the month and display the resultant set in the table.
I have my access table , with column PurchaseDate, in which the dates are like '1/10/2012', '11/1/2012'...
I have a table which contains a date column called 'PurchaseDate'
I have a list box which displays the months. When I click a month , I need to query the dataSource and collect the rows which have the purchase date in the 'SelectedMonth'.
dv2 = New DataView(ds.Tables(0), "PurchaseDate LIKE...