How to make a DataTable from DataGridView without any Datasource?

Question

I want to get a DataTable from DataGridView of the Grid values.

In other words DataTable same as DataGridView Values

Can't you just instantiate a new datatable and set it as the datasource of the gridview? — Flynn1179, Jun 24 '10 at 10:32

score 49 · Accepted Answer · edited Dec 13 '17 at 16:28

49

Might be a nicer way to do it but otherwise it would be fairly trivial to just loop through the DGV and create the DataTable manually.

Something like this might work:

DataTable dt = new DataTable();
foreach(DataGridViewColumn col in dgv.Columns)
{
   dt.Columns.Add(col.Name);    
}

foreach(DataGridViewRow row in dgv.Rows)
{
    DataRow dRow = dt.NewRow();
    foreach(DataGridViewCell cell in row.Cells)
    {
        dRow[cell.ColumnIndex] = cell.Value;
    }
    dt.Rows.Add(dRow);
}

edited Dec 13 '17 at 16:28

user9094667

3
2

answered Jun 24 '10 at 10:34

Hans Olsson

54,199
15
94
116

2

You may want to preserve the column types in the cloned DataTable, by adding `col.CellTemplate.ValueType` argument to the `dt.Columns.Add` in line 4. (I got FormatException without this thing, when processing the copied table.) – P.W. Sep 16 '19 at 17:00

score 13 · Answer 2 · answered May 15 '12 at 15:55

13

You can cast the DataSource object from the DataGridView to a DataTable

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

answered May 15 '12 at 15:55

Trenton Wallace

131
1
2

6

It should be noted that this will not work if the DataSource is a BindingList, though I was very hopeful. – Van Amburg Jun 04 '15 at 16:12

score 5 · Answer 3 · answered Nov 10 '12 at 09:18

5

you can use the following code also, this code fill not effect on your DataGridView when you do some add or delete rows in the datatable

DataTable dt = new DataTable();
dt = Ctype(dataGridView1.DataSource,DataTable).copy();

answered Nov 10 '12 at 09:18

Vishal Gavle

369
2
5

score 0 · Answer 4 · answered Sep 24 '21 at 12:29

You can try as follow:

using System.Data;
using System.Windows.Forms;

namespace BLL
{
    public class Class_DataGridview_To_DataTable
    {
        public static DataTable UDF_Convert_DataGridView_To_Datatable(DataGridView ImpGrd)
        {
            DataTable ExportDataTable = new DataTable();
            foreach (DataGridViewColumn col in ImpGrd.Columns)
            {
                ExportDataTable.Columns.Add(col.Name);
            }

            foreach (DataGridViewRow row in ImpGrd.Rows)
            {
                DataRow dRow = ExportDataTable.NewRow();
                foreach (DataGridViewCell cell in row.Cells)
                {
                    dRow[cell.ColumnIndex] = cell.Value;
                }
                ExportDataTable.Rows.Add(dRow);
            }

            return ExportDataTable;
        }
    }
}

How to make a DataTable from DataGridView without any Datasource?

4 Answers4

Linked