How to retrieve values from dictonary to datatable

Question

0.00/5 (No votes)

See more:

Hi

I have list of data collected from traversing the notepad file and storing it in a dictionary and finally i print the output in console. Now i need to take this data into the datatable and then print it. Can anyone suggest me how to do this or achieve?

My code

C#

static void unzip()
  {
      try
      {
          int counter = 1;
          var files = new List<string>(Directory.GetFiles(path, "*.zip*", SearchOption.AllDirectories));
          Dictionary<string, int> Messagetype = new Dictionary<string, int>();
          foreach (var item in files)
          {

              try
              {
                  // Dictionary<string, int> Messagetype = new Dictionary<string, int>();
              //var zipFileName = item;
              //var targetDir = Path.Combine(path, "unpack");
              //FastZip fastZip = new FastZip();
              //string fileFilter = null;
              //fastZip.ExtractZip(item, targetDir, fileFilter);


                  Console.WriteLine(counter++);

              Console.WriteLine("Unzipping " + counter + item.Substring(52));




              using (var zipInputStream = new ZipInputStream(File.OpenRead(item)))
              {
                  using (var fileStream = new FileStream(item, FileMode.Open, FileAccess.Read))
                  {
                      var zipFile = new ZipFile(fileStream);
                      ZipEntry zipEntry;

                      while ((zipEntry = zipInputStream.GetNextEntry()) != null)
                      {
                          var textStream = zipFile.GetInputStream(zipEntry);
                          using (var textLine = new StreamReader(textStream))
                          {
                              string message;
                              while ((message = textLine.ReadLine()) != null)
                              {
                                  if (string.IsNullOrEmpty(message)) continue;
                                  string[] parts = message.Split(new[] { "|" }, StringSplitOptions.None);
                                  if (!Messagetype.ContainsKey(parts[1]))
                                      Messagetype[parts[1]] = 0;
                                  Messagetype[parts[1]]++;
                              }
                          }
                      }
                  }
              }
              }
              catch (Exception ex1)
              {
                   Console.WriteLine( "File Name - " + item + " Error -" + ex1.Message);
                  //throw;
              }



          }
          foreach (var ms in Messagetype.Keys)
          {
              Console.WriteLine(ms + "-" + Messagetype[ms]);
          }

What I have tried:

Unable to add it to the datatable

Posted 8-Aug-16 16:01pm

ShaHam11

Updated 8-Aug-16 20:41pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2016-08-08T20:41:00

There's no inbuilt method to achieve that, but you can write custom "helper class":

C#

void Main()
{
	Dictionary<string, int> Messagetype = new Dictionary<string, int>();
	
	Messagetype.Add("a", 1);
	Messagetype.Add("b", 1);
	Messagetype.Add("c", 2);
	Messagetype.Add("d", 2);
	Messagetype.Add("e", 3);
	
	DataTable dt = HelperClass.ToDataTable(Messagetype);
	
	//dt contains Dictionary data
}

// Define other methods and classes here
public static class HelperClass
{

	public static DataTable ToDataTable(Dictionary<string, int> d)
	{
		DataTable dt = new DataTable();
		dt.Columns.Add("Item1", typeof(string));
		dt.Columns.Add("Item2", typeof(int));
		
		var result = d.Select(x=> dt.LoadDataRow(new object[] {x.Key, x.Value}, false));
		
		dt = result.CopyToDataTable();
		
		return dt;
	}
	
}

For further details, please see:
DataTable.LoadDataRow Method (Object[], Boolean) (System.Data)[^]
Creating a DataTable From a Query (LINQ to DataSet)[^]

[EDIT]
Bruno, Thank you for your valuable comment!
[/EDIT]