Hi There,

I want to create a collections class where I can populate a class with items in a SQL DB and then iterate through them via my code...

This is the scenario:

I have got a table which keeps application settings. Now I want to expose these settings per application via a web service.... so in my webservice I want to expose an object which is called "AppSettings"

so then in my application I want to call it in some kind of way like the following:


Code:
For Each Item as string in WebService.Appsettings.items(ApplicationID_Integer) 

Dim SettingID as string = item.ID 
Dim SettingName as string = item.Name 
Dim SettingValue as string = item.Value 

Loop

I hope what I want is clear... so I want retrieve the settings for that application (the table has got appID as an integer) and then put it in an array or collection with the properties that I specify... then on the client side I want to call this class and then iterate through the settings and use them...

How can I do this? I have been googling but I can't find anything

Thanks alot in advance!