Hi all i want to display two unrelated tables in the same datagridview. I m using merge method of datasets but in vain. Any idea Plz

Dare I ask why? Why not use 2 different views next to each other?

Actually I want it to be done throuth DataSets. Actually it is an assignment

I meant dataviews as in table on the form, I was expecting it to be 2 datasets.

Yes LIZr I have 2 DataSets And i Have Merged Them through Merge method of datasets. But Still I m not getting my result
I have Tried following
ds1.Merge(ds2);
dataGridView1.DataSource = ds1.Tables[0].DefaultView;

Any idea plz

K, but merge probably doesnt do what you're expecting.

Im guessing if you had tables such as

and

Im guessing you wanted

yes?

Hi,
try this

ds1.Merge(ds2);
dataGridView1.DataSource = ds1.Tables[0];
dataGridView1.DataBind();