Hi,
I would like to create a class to specify the type of connection i would like to use (SQL, OLEDB, ODBC etc.). This shall include in specifying the data adapter, data reader, dataset and so on.
The idea is generally like this. Assume i have four screens. Every screen links to my database (abc.mdb). Instead of typing the connection command and the adapter command, now i want to create a object class. All the four screen will acess this class object to obtain the connection access, including the way of connection would be. The four screens will have to pass in parameter to specify the required table(s)
I hope my description does not confuse you. In short, I want to write a class that can help my life easier when changing the connection class from MS Access to SQL server. (instead of changing it screen by screen). Please help to advise if you have this area of knowledge and experience.
FYI, I am doing VB.net web application. Thanks
Enter your message below
Sign in or Join us (it's free).