My main objective is to get data from an Ordered dictionary into some sort of storage (Data Table, list etc.). However I was not able to implement that.

Ordered Dictionary returned as arraylist and then creates a dataGridView and populates the GirdView.

My application is not WinForms or WPF, it's simply a class (although I can create a console app). So I can't have the luxury of dataGridView.

I created a dataTable and extracted data from GridView into dataTable. In order to see all my insert functionality works as expected.

However, I need to find a solution to convert an Ordered Dictionary into a dataTable /list/or any sort of storage unit.

Here is details:

I have an Ordered Dictionary. This Dictionary has valuesDictionary(<ID, ColumnList>), ColumnList is a collection of type ColumnList object.

A description of what is behind the scene of the dictionary data structure:

ColumnList object is something like Column1, Column2,……..,Column200, so total 200 columns with their respective values.

This is a row in an Access Table that has a unique ID (row ID), and 200 columns. These columns data types are varchar, long integer, double, float etc.

How do I convert the dictionary into a data table or appropriate storage ?

How do I get each key and all values from the ColumnList (all columns value from the Dictionary, Ex: Column1, Column2,……..,Column200) ?

How do I add each column appropriate data type in the data table or appropriate storage ?

Then utilize it to insert data into the corresponding table in Access DB.

I search various places but have not found a dialogue or solution that matches my requirements.

Your assistance will be monumental help.

Thank you.