C# convert list to datatable (inner list and dictionery also)

I need to create DataTable() from my List class. My DataTable should contain all the values of List or Dictionery which is in List class.I want the rows to be duplicated with all values of Dictionery or List values.

I want all the other properties to be duplicated with respect to List.. i.e Non System.Collections.Generic properties should be duplicated based on the lenght of the System.Collections.Generic properties.

For Ex:

Employee object has name, age,List, Dictionery

say,

name = "mike" 
 
age = "30" 
 
List certificateGot = new List<String> 
 
CertificateGot.Add("MSCE"); 
 
CertificateGot.Add("MCP");

Now add CertificateGot to List object..

Dictionery<string,string> prevCompNameandPlace = new Dictionery<string, string>(); 
 
prevCompNameandPlace.Add("xyz", "London") 
prevCompNameandPlace.Add("abc", "USA")

Now add prevCompNameandPlace to List object..

In my datatable I need like this

       Name    Age    CertificateGot NamePlace 
 
       Mike     30      MSCE          -- 
       Mike     30      MCP           -- 
       Mike     30      --           xyz,London 
       Mike     30      --           abc,USA

Any help would be appreciated.

Regards, T.N.Nagasundar

Try this:

using System;

using System.Collections.Generic;

using System.Data;

class Employee

{

public string Name {get; set;}

public string Age {get; set;}

public List CertificateGot {get; set;}

public Dictionary PrevCompNameAndPlace {get; set;}

}

class Test

{

static void Main()

{

Employee e = new Employee();

e.Name = "mike";

e.Age = "30";

List certificateGot = new List();

certificateGot.Add("MSCE");

certificateGot.Add("MCP");

e.CertificateGot = certificateGot;

Dictionary prevCompNameAndPlace = new Dictionary();

prevCompNameAndPlace.Add("xyz", "London");

prevCompNameAndPlace.Add("abc", "USA");

e.PrevCompNameAndPlace = prevCompNameAndPlace;

DataTable dt = new DataTable("Employee");

dt.Columns.Add("Name", typeof(string));

dt.Columns.Add("Age", typeof(string));

dt.Columns.Add("Cerificate", typeof(string));

dt.Columns.Add("PrevCompNameAndPlace", typeof(string));

foreach (string cert in e.CertificateGot)

{

dt.Rows.Add(e.Name, e.Age, cert, "");

}

foreach (string prevCompName in e.PrevCompNameAndPlace.Keys)

{

dt.Rows.Add(e.Name, e.Age, "", prevCompName + ", " + e.PrevCompNameAndPlace[prevCompName]);

}

// check it worked

Console.WriteLine("{0, -10} {1, -3} {2, -14} {3}\n", "Name", "Age","CertificateGot","NamePlace");

foreach(DataRow row in dt.Rows)

{

string row2 = (row[2].ToString() != "") ? row[2].ToString() : "--";

string row3 = (row[3].ToString() != "") ? row[3].ToString() : " --";

Console.WriteLine("{0, -10} {1, -3} {2, -14} {3}", row[0], row[1], row2, row3);

}

Console.ReadKey();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Try this:

using System;
using System.Collections.Generic;
using System.Data;

class Employee
{
public string Name {get; set;}
public string Age {get; set;}
public List CertificateGot {get; set;}
public Dictionary PrevCompNameAndPlace {get; set;}
}

class Test
{
static void Main()
{
Employee e = new Employee();
e.Name = "mike";
e.Age = "30";
List certificateGot = new List();
certificateGot.Add("MSCE");
certificateGot.Add("MCP");
e.CertificateGot = certificateGot;
Dictionary prevCompNameAndPlace = new Dictionary();
prevCompNameAndPlace.Add("xyz", "London");
prevCompNameAndPlace.Add("abc", "USA");
e.PrevCompNameAndPlace = prevCompNameAndPlace;

DataTable dt = new DataTable("Employee");
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Age", typeof(string));
dt.Columns.Add("Cerificate", typeof(string));
dt.Columns.Add("PrevCompNameAndPlace", typeof(string));
foreach (string cert in e.CertificateGot)
{
dt.Rows.Add(e.Name, e.Age, cert, "");
}

foreach (string prevCompName in e.PrevCompNameAndPlace.Keys)
{
dt.Rows.Add(e.Name, e.Age, "", prevCompName + ", " + e.PrevCompNameAndPlace[prevCompName]);
}

// check it worked
Console.WriteLine("{0, -10} {1, -3} {2, -14} {3}\n", "Name", "Age","CertificateGot","NamePlace");
foreach(DataRow row in dt.Rows)
{
string row2 = (row[2].ToString() != "") ? row[2].ToString() : "--";
string row3 = (row[3].ToString() != "") ? row[3].ToString() : " --";

Console.WriteLine("{0, -10} {1, -3} {2, -14} {3}", row[0], row[1], row2, row3);
}

Console.ReadKey();
}
}
0