list to dataset using C#

Question

How to convert list to dataset using c#?

@AmRan, I'm not a downvoter but this is duplicated, Also OP doesn't say what try before. — Saeed Amiri, Mar 08 '11 at 11:13

score 3 · Accepted Answer · answered Mar 08 '11 at 11:08

//
// Conventional way
//
private DataSet GetDataSetConventional(List<FileSearchResultItem> list)
{
    DataSet _result = new DataSet();
    _result.Tables.Add("results");
    _result.Tables("results").Columns.Add("A");
    _result.Tables("results").Columns.Add("B");
    _result.Tables("results").Columns.Add("C");
    _result.Tables("results").Columns.Add("D");
    _result.Tables("results").Columns.Add("E");
    _result.Tables("results").Columns.Add("F");
    _result.Tables("results").Columns.Add("G");

    foreach (FileSearchResultItem item in list) {
        DataRow newRow = _result.Tables("results").NewRow();
        newRow("A") = item.Index;
        newRow("B") = item.Image;
        newRow("C") = item.Name;
        newRow("D") = item.Size;
        newRow("E") = item.Files;
        newRow("F") = item.IsDirectory;
        _result.Tables("results").Rows.Add(newRow);
    }
    return _result;
}

score 0 · Answer 2 · answered Mar 08 '11 at 11:10

0

Take a look here

You basically use a for loop to go through the list and map the list items to DataTable items creating a new row each iteration.

answered Mar 08 '11 at 11:10

MattP

2,798
2
31
42

list to dataset using C#

2 Answers2