MySqlConnection cs = new MySqlConnection(connectionSQL); cs.Open(); 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); da.Fill(ds); this.dataGrid1.ItemsSource = ds.Tables[0].DefaultView;