covert datatable to dictionary
| label | labelnumber |
|---|---|
| A | 584 |
| B | 536 |
| C | 985 |
| D | 324 |
| E | 587 |
| F | 123 |
1 Like
dt.AsEnumerable.ToDictionary(of string,string)(Function(r) r(0).tostring,Function(r) r(1).tostring)
try this
Assign Activity
dictLK | DataType: Dictionary(Of String, String) =
YourDTVar.AsEnumerable.ToDictionary(Function (x) x("label").toString.Trim, Function (x) x("labelnumber").toString.Trim)
Or when the number is needed as int32
Assign Activity
dictLK | DataType: Dictionary(Of String, int32) =
YourDTVar.AsEnumerable.ToDictionary(Function (x) x("label").toString.Trim, Function (x) CInt(x("labelnumber").toString.Trim))
Hi @rakhila396
You can try this
dataTable.AsEnumerable().ToDictionary(Function(row) row("label").ToString(), Function(row) Convert.ToInt32(row("labelnumber")))
dt.AsEnumerable.ToDictionary(function(x) x("label").ToString,function(y) y("labelnumber").ToString)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.