OleDBConnection
-
Hi all, Im kinda starter in C#.net, im trying to build a system, first thing's to establish a connection to an MSAccess DB, I want to make my connection public so all forms can use it by just calling it. I'm trying to work on creating a class for it but im having hardtime making it work... How can I make a public connection in a class and call it in my forms? Thanks in advance
-::maximus::-
-
Hi all, Im kinda starter in C#.net, im trying to build a system, first thing's to establish a connection to an MSAccess DB, I want to make my connection public so all forms can use it by just calling it. I'm trying to work on creating a class for it but im having hardtime making it work... How can I make a public connection in a class and call it in my forms? Thanks in advance
-::maximus::-
Try to make a class like "DatabaseManager" to do all the databaseoperations Please make all the methods as public so that all the classes can access them You can use the following public methods 1.OpenConnection() 2.CloseConnection() 3.ExcecuteQuery(string query) 4 ExecuteQuery(string query,out Dataset dt) Just call Excecute query function with a query,and you can managethe open and close connection from this function. If you expect any output(like search) then you can use the overloaded function which gives a dataset.
My small attempt...
-
Hi all, Im kinda starter in C#.net, im trying to build a system, first thing's to establish a connection to an MSAccess DB, I want to make my connection public so all forms can use it by just calling it. I'm trying to work on creating a class for it but im having hardtime making it work... How can I make a public connection in a class and call it in my forms? Thanks in advance
-::maximus::-
Hi, the idea with one class for the hole project is a good one. You can create a oleDbDataAdpater with the Windows Forms generator. Then you copy the source and put it into a new class, which is created by your own. Set the modifier to public and now you can use your class in the hole project. regards spotl