Convert DataRow to Dictionary of Key Value

[ppr (Peter Preuss)]

This can be done with LINQ
Lets assume the first row schould be converted, following statement can be used:

dtSample.Rows(0).ItemArray.Select(Function (item, index) new KeyValuePair(Of String, Object)(dtSample.Columns(index).ColumnName, item)).toDictionary(Of String, Object)(Function (d) d.Key, Function (d) d.Value)

EDIT:
sharing simplified statetement and demo XAML:
YourDataTableVar.AsEnumerable.ToDictionary(Of String, String)(Function (r) r(YourKeyCol).toString, Function (r) r(YourValueCol).toString)

Convert Datatable to Dictionary

@ZARA_Clark_Vincent_M Welcome to the forum: find starter help here: DataTable_2Col_ToDictionary.xaml (6.5 KB) In general it is about: use assign left side your dict right side: YourDataTableVar.AsEnumerable.ToDictionary(Of String, String)(Function (r) r(YourKeyCol).toString, Function (r) r(YourValueCol).toString)