I am new to C# and to Visual Studio 2011.
I am trying to learn C# and many things, and for example I am trying to make a login form, which on login attempt will make a connections to a database and then verify the user and password in order to access the remainder of the program. Here are my questions:
1- Because I have multiple form, should I have some sort of main class opening database connection once and leave it open until the end, or should it be open and closed on each form on event time.
2- I am simply learning, and I am using Access as my database. I am wondering how to connect to it, using 2011 access, hard to understand clearly what MSDN is trying to say, they don't have much tutorial on beta.
Thanks in advance