CODEWITHSUNDEEP
c#asp.netvisual-studio
Hazior
Hazior

Reputation: 694

How to convert List<List<string>> to a DataTable

How would I convert List<List<string>> to a DataTable? I am trying to set the DataSource of a gridview to a List<List<string>> variable.

Upvotes: 4

Views: 11892

Answers (3)

Andrew
Andrew

Reputation: 96

public static DataTable ToDataTable(this List<List<string>> list)
{
    DataTable dt = new DataTable();
    list.First().ForEach(colname => dt.Columns.Add(colname));
    foreach (List<string> row in list.Skip(1))
        dt.Rows.Add(row.ToArray());
    return dt;
}

Upvotes: 3

rickythefox
rickythefox

Reputation: 6851

This can easily be done using extension methods.

Add this class to your solution

static class ListExtensions
{
    public static DataTable ToDataTable(this List<List<string>> list)
    {
        DataTable tmp = new DataTable();
        foreach (List<string> row in list)
        {
            tmp.Rows.Add(row.ToArray());
        }
        return tmp;
    }
}

then use the extension method like this:

List<List<string>> myList = new List<List<string>>();
// Fill with values...
DataTable table = myList.ToDataTable();

Upvotes: 5

Denis Biondic
Denis Biondic

Reputation: 8201

I would rather set DataSource of the grid to BindableList, which you would perhaps create easier, instead of double nested List, you would have List of Rows (where the Row is business entity represented, for example Customer).

Upvotes: 2

Related Questions