Daca ai un Datatable
ca sursa de date la grid poti folosi ce a zis @adrian.stanculescu mai sus
Ce baza de date folosesti ?
LE:
var results = from row1 in dt.AsEnumerable()
where row1.Field<int>("id") == 1
select row1;
dataGridView1.DataSource = results.CopyToDataTable();
Am testat-o acum. Functioneaza