How can turn datatable into dictionary ?

Suhas Kurse

7y11.8kLearn iOS Programming

I am using Visual Studio 2017.

I want to convert datatable into dictionary, so that I can iterate over the testid key. The datable has 8 columns.

So after converting I should be able to iterrate over it as shown below

string testy=dbDict(Testid).ColumnName.toString();

Thank you for the answer;

3 Replies

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

Nitin Sontakke7y ago
Accepted answer
If possible, please be very explicit about what exactly you are trying to achieve here. You can iterate in data from data table also. May be you can write linq also. Or write a small function which would return the desired data.

Just for the sake of relatively small benefit do not add unnecessary complexity. Hope you get the point.

Awaiting your response.
0
Rajanikant Hawaldar7y ago
Hi Suhas, i created sample console application for your requirement please check it.
class Program
    {
        static void Main(string[] args)
        {
            Dictionary<int, Dictionary<string, string>> dict = new Dictionary<int, Dictionary<string, string>>();
            foreach (var item in GetTable().Rows)
            {
                Dictionary<string, string> temp = new Dictionary<string, string>();
                temp.Add(((System.Data.DataRow)item).ItemArray[0].ToString(), ((System.Data.DataRow)item).ItemArray[1].ToString());
                dict.Add(Convert.ToInt32(((System.Data.DataRow)item).ItemArray[0]), temp);
            }
        }
        static DataTable GetTable()
        {
            // Here we create a DataTable with four 2.
            DataTable table = new DataTable();
            table.Columns.Add("Sid", typeof(int));
            table.Columns.Add("Name", typeof(string));
            table.Columns.Add("Designatio", typeof(string));
            // Here we add 2 DataRows.
            table.Rows.Add(1, "David","SE");
            table.Rows.Add(2, "Sam","TL");
            return table;
        }
    }
0
Amit Mohanty7y ago
Try this
public static Liststring, string>> GetData(DataTable dt)
{
    return dt.AsEnumerable().Select(
        row => dt.Columns.Cast().ToDictionary(
            column => column.ColumnName,
            column => row[column].ToString()
        )).ToList();
}
Or
internal Dictionary<string,object> GetData(DataTable dt)
{
    return dt.AsEnumerable()
      .ToDictionarystring, object>(row => row.Field<string>(0),
                                row => row.Field<object>(1));
}
0