C sharp mysql connection useing Class

Question

Hello Experts I have down loaded http://www.codeproject.com/Tips/423233/How-to-Connect-to-MySQL-Using-Csharp this example . of C sharp connection to mysql . It works fine . But My problem is this example explains the connection from form button click. I want to use class for connection purpose . So while loading a form it will check that connection is made successfull for not . I am Vfp9 programmer this same i am using in vfp9/mysql from last 5 years . But here on c Sharp I stucked up. Thanks in advance . regards anand kulkarni

Dhirendra Misra · Answer

Hello Anand What I understood from your question that you want to call OpenConnection method from your form load event. If it is so change access modifier of your method OpenConnection() to internal from private and same for CloseConnection method. like this : internal bool OpenConnection() { ..... } Form load event as private void Form1_Load(object sender EventArgs e) { DBConnect objDBConnect = new DBConnect(); MessageBox.Show(objDBConnect.OpenConnection().ToString()); } Hope this answer your question. If not please show your code what have you written in button click event. Thanks

anand kulkarni · Answer

Greate !!! Dhirendra  It works Like Charm !!!! Thank you very Much . For your help .

Dhirendra Misra · Answer

Hi Anand You can reuse that code in page load events as well. For details refer link. http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

anand kulkarni · Answer

Hi Dhirendra To the above code I have tried to get some table values . As for the same condition means while loading the from and through the class . Means when I get the successful connection while load the form same time I want pull out mysql table values to text box . I Have tried but after spending some hours I posted it here . Connection class is same as above Regards Aanand S. Kulkarni

anand kulkarni · Answer

Hi Dhirendra  Thanks for reply  Still I am in confussion . I want to call a class of dbconnection string from form load just take a look at it . I have created a class which connect the db  Insert  Select  Edit and delete . Every thing is going fine but the problem is Every time I have to click on the butn to then it checks the connection is done or not . upto this it is ok . But What i want is to Call dbconnection at form load event . Please see the class code . It working fine . using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; using System.Diagnostics; using System.IO ; using MySql.Data.MySqlClient; namespace ConnectCsharpToMysql { class DBConnect { private MySqlConnection connection; private string server; private string database; private string uid; private string password; //Constructor public DBConnect() { Initialize(); } //Initialize values private void Initialize() { server = localhost; database = mydb; uid = myuid; password = mypwd; string connectionString; connectionString = SERVER= + server + ; + DATABASE= + database + ; + UID= + uid + ; + PASSWORD= + password + ;; connection = new MySqlConnection(connectionString); } //open connection to database private bool OpenConnection() { try { connection.Open(); return true; } catch (MySqlException ex) { //When handling errors you can your application's response based on the error number. //The two most common error numbers when connecting are as follows: //0: Cannot connect to server. //1045: Invalid user name and/or password. switch (ex.Number) { case 0: MessageBox.Show(Cannot connect to server. Contact administrator); break; case 1045: MessageBox.Show(Invalid username/password please try again); break; } return false; } } //Close connection private bool CloseConnection() { try { connection.Close(); return true; } catch (MySqlException ex) { MessageBox.Show(ex.Message); return false; } }