转换数据表到对象[,](Convert DataTable to object[,])

2019-10-23 05:01发布

如何转换数据表到数组?

从源数据表我转换为对象[,]

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

Answer 1:

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


文章来源: Convert DataTable to object[,]