Creating Data table using Key Value set in C#

Question

I have dictionaries with key value as follows Dic1(Name,Anu), Dic2(Age,22), Dic3(Name,Cas),Dic4(Age,25), Dic5(Sex,Male) . I want to create a data table with Name, Age and Sex as Column header and mapped with corresponding Values as the row data.

Name Age Sex Anu 22 null Cas 25 Male

It would be awesome if you could provide a [mcve], with some sample data included (so we can use that as our starting point). — mjwills, Oct 27 '18 at 12:04
Do you know how to work with `DataTable`s in C#? Did you read the docs? — Mohammad Dehghan, Oct 27 '18 at 12:10

Siavash · Answer 1 · 2018-10-27T12:19:04.837

You should add DataColumn , DataRow separately, the below method convert a List collection to DataTable based on a sample , Change the columns by your own problem.

static DataTable Convert(List<string[]> list)
{
    DataTable table = new DataTable();
    int columns = 0;
    foreach (var array in list)
    {
        if (array.Length > columns)
        {
            columns = array.Length;
        }
    }
    for (int i = 0; i < columns; i++)
    {
        table.Columns.Add();
    }
    foreach (var array in list)
    {
        table.Rows.Add(array);
    }
    return table;
}

You can call that method by the following sample method:

static void sample()
{
    List<string[]> list = new List<string[]>();
    list.Add(new string[] { "Column 1", "Column 2", "Column 3" });
    list.Add(new string[] { "Row 2", "Row 2" });
    list.Add(new string[] { "Row 3" });

    DataTable table = Convert(list);
    dataGridView1.DataSource = table;
}

Thanks for the solution. I modified this as per my requirement and it works — Anu, Oct 28 '18 at 04:54

Creating Data table using Key Value set in C#

1 Answers1