How to make a DataTable from DataGridView without any Datasource?

c# datagridview datatable windows-forms-designer
Mobin picture Mobin · Jun 24, 2010 · Viewed 66.6k times · Source

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

In other words DataTable same as DataGridView Values

Answer

Hans Olsson picture Hans Olsson · Jun 24, 2010

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);
}

Related questions

how to add the checkbox to the datagridview from coding

how to add the checkbox to the datagridview from coding in windows form. i have a datatable with one column as value=true; and in another datatable i had settings for that column as value='Checkbox' so if my value …

Read More
How to add new DataRow into DataTable?

I have a DataGridView binded to a DataTable (DataTable binded to database). I need to add a DataRow to the DataTable. I'm trying to use the following code: dataGridViewPersons.BindingContext[table].EndCurrentEdit(); DataRow row = table.NewRow(); for (int i = 0; i &…

Read More
How to add a button to a column in the DataGridView

DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Software Title", typeof(string))); dt.Columns.Add(new DataColumn("Version", typeof(string))); dt.Columns.Add(new DataColumn("Uninstall", typeof(System.Windows.Forms.Button))); DataRow dr = dt.NewRow(); dr[0] = "App"; dr[1] = "1.0"; Button …

Read More