Thanks Christian, I'm going to try it now. sorry about the misunderstanding about VB6, I tend to think in that language. I know it's been obsolete for a long time, but there is still lots of VB6 code out there. I've not forgiven Uncle Billy for ditching it like that, although I can understand why. Chiefy

it looks really easy like that. I'll give it a try when I get back to work. In VB6 I would raise a class 'Inventory' containing all the fields I've already mentioned. The class manager would then apply all the 'get and 'set' attributes to the class members (I'm probably not using the right descriptions here). I would then raise a collection of class Inventory. I then would connect to my database, return a recordset of Inventory, and iterate through it, adding the information into the fields of the collection: do until recordset.eof = true inventory collection .add (the columns of the inventory table) loop Thanks for you help C# is great....

I put a message on this board a couple of hours ago, but I can't see it so I think I might have been bumped. anyway, I'll try again. I'm a very experienced (20Yrs +) VB developer, and have used classes and collections so much that I raise them without thinking of how I do them. now I'm trying to transfer to C# I'm trying to find a way of doing the same thing. I have an inventory table consisting of the following fields: ID - int SKU - string Description - string Unit - string QtyOnSite - double ValOnSite - double I can raise an inventory class, but now i want to read all the information from a sqlserver table into a collection of type inventory. Could any of you wizards give me a clue as to how to do this please? Chiefy

Eddy, I don't know if you are being sarcastic or what:) Uncle Billy has been forcing me to buy upgrades ever since VB2 hit the shelves a long way back.

Translation into English - "How can we get more money to maintain our ludicrously high salaries, and still appear to be doing something"

I've just gone through my re-birth from a 20Year veteran VB6 developer to a neophyte without a clue c# and .NET developer. I'm using the c# express download that Uncle Bill gave us for free, and I must admit, I am very impressed with it, and would not dream of going back. However, I see looming on the horizon a version 4.0!!!!so do you think that Uncle Bill will give us paupers free copies of that as well? or have we been drawn into the .NET web and be forced to buy upgrades.