CODEWITHSUNDEEP
c#.netvb.netdatagridviewdatatable
Asad Chohan
Asad Chohan

Reputation: 29

Filling Datatable with DataGridView data in VB/C# .NET

How can I fill Datatable with DataGridView data (VB/C# .NET)?

Upvotes: 1

Views: 9653

Answers (1)

TalentTuner
TalentTuner

Reputation: 17556

Assuming that it is a Winform

below code can be of help

        //dgv is the name of your data grid view.

        DataTable dt = new DataTable();
        DataColumn[] dcs = new DataColumn[]{};

        foreach (DataGridViewColumn c in dgv.Columns)
        {
            DataColumn dc = new DataColumn();
            dc.ColumnName = c.Name;
            dc.DataType = c.ValueType;
            dt.Columns.Add(dc);

        }

        foreach (DataGridViewRow r in dgv.Rows)
        {
            DataRow drow = dt.NewRow();

            foreach (DataGridViewCell cell in r.Cells)
            {
                drow[cell.OwningColumn.Name] = cell.Value;
            }

            dt.Rows.Add(drow);
        }

Upvotes: 5

Related Questions