Convert DataTable to Dictionary in C#

Frightened Ferret answered on April 18, 2022 Popularity 8/10 Helpfulness 5/10

answer Convert DataTable to Dictionary in C#

Convert DataTable to Dictionary in C#

Comment

private List<Dictionary<string, object>> DataTableToDictionary(DataTable dt)
{
    var dictionaries = new List<Dictionary<string, object>>();
    foreach (DataRow row in dt.Rows)
    {
        Dictionary<string, object> dictionary = Enumerable.Range(0, dt.Columns.Count).ToDictionary(i => dt.Columns[i].ColumnName, i => row.ItemArray[i]);
        dictionaries.Add(dictionary);
    }

    return dictionaries;
}

Popularity 8/10 Helpfulness 5/10 Language csharp

Source: gist.github.com

Tags: c# datatable dictionary

Link to this answer
Share Copy Link

Contributed on Apr 18 2022

Frightened Ferret

0 Answers Avg Quality 2/10

Convert DataTable to Dictionary in C#

Contents

More Related Answers

Convert DataTable to Dictionary in C#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.