A class for DataBase Connection Codes

[shahab2025]

Dear Sir I have many forms in my vb.net projects I have to write(copy) all connection codes to connect DB for each form Is any better way???? for example a class or a dll to help me ???? Generally I want another method (class or dll file) to call for loading of my forms... Sorry about my bad english... Thanks

[darkyro]

yu can create a class with this code: Public con As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & My.Settings.dbBase.ToString & ";Jet OLEDB:Database Password=" & My.Settings.dbBasePass.ToString & ";") where i use a settings option to store the informations converted to string : data base : My.Settings.dbBase.ToString password : My.Settings.dbBasePass.ToString i hope help you ^^ my english is not good too ^^" ;)

[The Man from U N C L E]

Standard object orientated multitier design patterns help here. Been around for years. You need to abstract all your dataAccess code (creating the connection, calling SQL etc.) into a separate DataAccess class. Then from any form in the application just call your dataaccess class. MSDN tutorial 1: Creating a Data Access Layer[^] should give you a good start point.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk

[The Man from U N C L E]

I should add that althought the MSDN articl I posted about is for ASP.Net Web Applications the DataAccess logic and code is identical for Windows Forms applications.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk