Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Populate a Dictionary
Message
From
18/03/2011 15:33:02
 
 
To
18/03/2011 11:36:15
General information
Forum:
ASP.NET
Category:
LINQ
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01504070
Message ID:
01504159
Views:
52
>Try the following:
Dictionary<string, string> MyDictionary = ds.Tables[0].AsEnumerable().ToDictionary(dr => dr["KeyName"].ToString(), dr => dr["KeyValue"].ToString());

Excellent suggestion, Rob ... I wanted to mention an additional syntax one could use to cover the situation where your KeyValue, and thus the item in your dictionary, may not be a string:
Dictionary<string, int> MyDictionary = ds.Tables[0].AsEnumerable().ToDictionary(dr => dr.Field<string>("KeyName"), dr => dr.Field<int>("KeyValue"));
~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform