C#

  public Hashtable GetAllUsersAndIDs()<br />
{<br />
SqlConnection dbc = new SqlConnection(Config.ConnectionString); <br />
Hashtable userTable = new Hashtable();<br />
dbc.Open();<br />
try<br />
{   <br />
SqlCommand sqlCommand = new SqlCommand(<br />
"SELECT DISTINCT UserGroupID, Name  " +<br />
"FROM UserGroupTable " +<br />
"ORDER BY Name",<br />
dbc);<br />
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();<br />
long userGroupID;<br />
UGUserNode user;<br />
while (sqlDataReader.Read()) <br />
{<br />
if (!sqlDataReader.IsDBNull(0))<br />
{   <br />
userGroupID = sqlDataReader.GetInt64(1);<br />
if (nodes.ContainsKey(userGroupID))<br />
{<br />
//we have already seen this node!<br />
user = (UGUserNode) nodes[userGroupID];<br />
}<br />
else<br />
{<br />
user = new UGUserNode();<br />
user.LoginName = sqlDataReader.GetString(0);<br />
user.ID = sqlDataReader.GetInt64(1);<br />
user.IsActive = true;<br />
nodes.Add(userGroupID, user);<br />
}<br />
userTable.Add(userGroupID,nodes[userGroupID]);<br />
}<br />
}<br />
         <br />
sqlDataReader.Close();<br />
}<br />
catch(Exception e)<br />
{ Console.WriteLine(e.Message);}<br />
finally {dbc.Close();}<br />
return userTable;<br />
}