C# initialize connection to mysql database c# - Net-Raft.com

Welcome aboard! We are happy you are here and wish you good net-raft!




Just a Web Code Solution
join us

how to initialize a connection to mysql database using C# ?


 1161

C#


3

//Initialize

private void Initialize()
{
server = "localhost";
database = "yourdatabase";
uid = "username";
password = "password";
string connectionString;
connectionString = "SERVER=" + server + ";" + "DATABASE=" +
database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

connection = new MySqlConnection(connectionString);

}


// open connection

private bool OpenConnection()
{
try
{
connection.Open();
return true;
}
catch (MySqlException ex)
{
switch (ex.Number)
{
case 0:
MessageBox.Show("Connection is refused!");
break;

case 1045:
MessageBox.Show("Invalid username/password!");
break;
}
return false;
}
}


By        
The power of the user (%)
5%



The most helpful C# solutions

detect ie C#detect ie C#C#

Click to see more ...

  4.6K     853

get latitude and longitude from ip address c#get latitude and longitude from ip address c#C#

Click to see more ...

  2.8K     257

get real user country C#get real user country C#C#

Click to see more ...

  1.7K     252

Get real client ip address using C# ?Get real client ip address using C# ?C#

Click to see more ...

  1.8K     247

check if cookie exists c#check if cookie exists c#C#

Click to see more ...

  6.3K     173

get city country region timezone c#get city country region timezone c#C#

Click to see more ...

  2.7K     163

How to detect the browser opera using C# in asp.net ?How to detect the browser opera using C# in asp.net ?C#

Click to see more ...

  2.3K     136

get hostname using C#get hostname using C#C#

Click to see more ...

  1.1K     127

Get real client latitude and longitude using C# ?Get real client latitude and longitude using C# ?C#

Click to see more ...

  829     127

how to initialize a connection to mysql database using C# ?how to initialize a connection to mysql database using C# ?C#

Click to see more ...

  1.2K     122

Welcome aboard!
We are happy you are here and
wish you good net-raft!