Hi,

I have an application which is based on a MSAccess 2000 database with a number of related tables. The application contains some forms which have comboboxes and listboxes that need to give the related values from the tables.

Now I have in each form created a dataadapter and a dataset for each table I need in that specific form, but I think this produces a lot of overhead code. I was thinking about creating a class that I can reuse in every form. THe class should do the following:
- create a connection to a database
- create an oledbdataadapter
- create a dataset
- create a listbox that contains the value of the dataset

Is this possible? How do I have to programm this: do i need a windows form or a class? How can I use the class in the other forms?

I'm a newbie to OOP, so please give me some hints and a code example if possible?

Thank you very much for your time;

Tom