ASP.NET MYSQL HELP: How to filter datagrid using two datepickers
Please help me, I have been stuck on this all day!!
I am wanting to filter results of wpf datagrid using two datepickers. My query i have so far is as follows
My code has no errors but the dataset returns as empty even though I have got records which correspond to query.
MySqlConnection cs = new MySqlConnection(connectionSQL);
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter("Select * from Transactions WHERE date BETWEEN '"+datePicker1.Text +"' AND '"+datePicker2.Text +"' ", cs);
MySqlCommandBuilder cmd = new MySqlCommandBuilder(da);
this.dataGrid1.ItemsSource = ds.Tables.DefaultView;
Does datepicker require any binding in xaml? DBase date field has type of date. and saves dates with this format 2013-03-11