How can turn datatable into dictionary ?

Question

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;

Nitin Sontakke · 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.

Rajanikant Hawaldar · Answer

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; } }

Amit Mohanty · Answer

Try this public static List string , 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() .ToDictionary string , object >(row => row.Field string >(0), row => row.Field object >(1)); }

How can turn datatable into dictionary ?

Answers (3)