How to bind Dataset to DataGridView in windows application

Question

I have created Windows Application. In this, I have multiple tables in dataset, now I want to bind that to a single DataGridView. Can anybody help me?

Answer 1

following will show one table of dataset

DataGridView1.AutoGenerateColumns = true; DataGridView1.DataSource = ds; // dataset DataGridView1.DataMember = "TableName"; // table name you need to show 

if you want to show multiple tables, you need to create one datatable or custom object collection out of all tables.

if two tables with same table schema

dtAll = dtOne.Copy(); // dtOne = ds.Tables[0] dtAll.Merge(dtTwo); // dtTwo = dtOne = ds.Tables[1]  DataGridView1.AutoGenerateColumns = true; DataGridView1.DataSource = dtAll ; // datatable 

sample code to mode all tables

DataTable dtAll = ds.Tables[0].Copy(); for (var i = 1; i < ds.Tables.Count; i++) {      dtAll.Merge(ds.Tables[i]); } DataGridView1.AutoGenerateColumns = true; DataGridView1.DataSource = dtAll ;