C sharp mysql connection useing Class

anand kulkarni

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhirendra Misra12y ago
Accepted 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 kulkarni12y ago
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 kulkarni12y ago
Greate !!! Dhirendra , It works Like Charm !!!!
Thank you very Much . For your help .
anand kulkarni12y ago
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;
}
}
Dhirendra Misra12y ago
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