On the datepicker's valuechanged event you can do something like this
DataSet ds = ((BindingSource)(dataGridView1.DataSource)).DataSource as DataSet;
DataRow[] res = ds.Tables[0].Select("date = '" + dateTimePicker1.Value.ToShortDateString() + "'");
dataGridView2.DataSource = res;