CODEWITHSUNDEEP
c#arraysdatatables
askeet
askeet

Reputation: 719

Convert DataTable to object[,]

How convert DataTable to Array?

Source my converter from DataTable to object[,] 

        uint rows = (uint)table.Rows.Count; 
        uint columns = (uint)table.Columns.Count;

        var data = new object[rows, columns];
        int i = 0;
        foreach (System.Data.DataRowView drv in table.DefaultView)
        {
            System.Data.DataRow ViewRow = drv.Row;
            data[i] = drv.Row.ItemArray.Clone() as object[];// Wrong number of indices inside []; expected 2    

            i++;
        }

Upvotes: 2

Views: 1664

Answers (1)

Jony Adamit
Jony Adamit

Reputation: 3416

uint rows = (uint)table.Rows.Count; 
uint columns = (uint)table.Columns.Count;

var data = new object[rows, columns];
int i = 0;
foreach (System.Data.DataRowView drv in table.DefaultView)
{
    for( int x = 0; x<columns; x++)
{
    System.Data.DataRow ViewRow = drv.Row;
    data[i, x] = drv[x];

    i++;
}
}

Upvotes: 3

Related Questions