Convert dataGridView to dataTable

Question

I have a method which returns a dataTable and I use that to populate a dataGridView which works fine.
Then I want to capture the situation where user did modifications to that dataGridView (add new recs, delete, updates).
So what I tried is this
DataTable dt = (DataTable) dataGridView1.DataSource;
but everytime dt returns as null.

Any idea how to fix this?

Roei Bar · Answer

you can use this DataTable dtFromGrid = new DataTable(); dtFromGrid = dataGridView1.DataSource as DataTable; this will work

dany · Answer

i have this message : Impossible d'effectuer un cast d'un objet de type 'System.RuntimeType' en type 'System.Data.DataTable'.

Sameer Shaikh · Answer

Thanx this really works for me... I used ur code i this way. BindingSource bs = new BindingSource(); bs.DataSource=dataGridView1.DataSource; DataTable dat = (DataTable)(bs.DataSource);

Alan Liverance · Answer

Here's a quick C# solution with a simple 2 column DataGridView DataTable dt = new DataTable(); dt.Column.Add(column1 typeof(string)); dt.Column.Add(column2 typeof(string)); foreach(DataGridViewRow dgvR in myDataGridView) { dt.Rows.Add(dgvR.Cells[0].Value dgvR.Cells[1].Value); }

Nolan Sunico · Answer

You can convert the data from Datagridview to a datatable by using a custom function in vb.net. I have found relevant article on this: http://www.sourcehints.com/articles/how-to-convert-datagridview-data-to-datatable.html

George Alexandrov · Answer

Doesn't DataGridView object apply all changes with a table back to the DataTable object? Check it during debug mode.

Bilal Salas · Answer

thanks for replay but I want to copy datagrideview data to dataset to edit the database not opposite ? thank you.

Ruben Gonzalez · Answer

try this: da = new DataAdapter(); dt = new DataTable(); da.Fill(dt); dt.Locale = System.Globalization.CultureInfo.InvariantCulture; BindingSource bs = new BindingSource(); bs.DataSource = dt; dataGridView.DataSource = bs;

Bilal Salas · Answer

Hi I am stuck with the same problem please help me!!

Ruben Gonzalez · Answer

I tried that advice but I'm getting a null value for my datatable: DataTable dtUpdaterEditor = new DataTable (); dtUpdaterEditor = dgvUpdaterEditor.DataSource as DataTable ; The dgvUpdaterEditor.Datasource member shows a record count of 32000 the dtUpdaterEditor member is null. Thanks for any advice. Ruben.

garuka · Answer

Hi Thanks. But my problem is once I get the data by calling that method and bind the returning dataTable to dataGridView I don't know how to get the dataset (yourDataSet)

Roei Bar · Answer

here you go: BindingSource bs = (BindingSource)dgv.DataSou rce; DataTable dt =((yourDataSet) (bs.DataSource)).Tables[0] ; which yourDataSet is the dataset that is binded to your DataGridView .