hi,

The following code used with MouseDoubleClick event to copy a selected row from dataGridView1 to dataGridView2

private void dataGridView1_MouseDoubleClick(object sender, MouseEventArgs e)

{

...

try this query,it works for me

select * from testdate where datepart(dd,date1)=datepart(dd,getdate())-1

so ,i hope this work for you