How to get an underlying DataTable from a control (i.e. under DataGridView)?

Question

dataGridView1.DataSource = myDataSet1;
dataGridView1.DataMember = "SomeTable";

And now I want to get the refference to DataTable back from my dataGridView1. Something like this:

DataTable dt = (DataTable)dataGridView1.DataSource... ;

I'm aware of BindingContext, but couldn't find the way to get DataTable refference back.

Got it.

DataSet dataSet = (DataSet)dataGridView1.DataSource;
string tableName = dataGridView1.DataMember;
DataTable dt =dataSet.Tables[tableName];

setting dataSET as datasource and trying to get dataTABLE.... — Renatas M., Mar 02 '12 at 11:50
I also provide a DataMember to point to a particular table in the DataSet — Excelan, Mar 02 '12 at 12:03

AnarchistGeek · Accepted Answer · 2012-03-02T11:57:42.767

1

you are assigning Dataset as datasource to your gridview. So, the line below would help u.

DataTable dt = ((DataSet)dataGridView1.DataSource).Tables[index];

Assuming that you have only one datatable in your dataset. you can also use your table name instead of index.

edited Mar 02 '12 at 11:57

answered Mar 02 '12 at 11:51

AnarchistGeek

score 0 · Answer 2 · edited May 23 '17 at 10:34

0

You can convert it in this way

BindingSource bs = (BindingSource )dgrid.DataSource;
DataTable tCxC = (DataTable ) bs.DataSource

edited May 23 '17 at 10:34

Community

answered Mar 02 '12 at 11:54

score 0 · Answer 3 · answered Mar 02 '12 at 11:57

You can either be resilient (to avoid null error) or take a chance.

The short version is:

DataTable dt = ((DataSet) dataGridView1.DataSource).Tables[0];

A more resilient approach (not assuming the view is bound to a DataSet):

DataSet ds = dataGridView1 as DataSet;  
if (ds != null)  DataTable dt = ds.Tables[0];

Obviously you can inspect/check the number of tables in the DataSet.

3 Answers3