How do you connect a MySQL database to a C# WinForm Application?
I can establish a connection using a Microsoft SQL Server, but cannot for the life of me figured out how it's done using MySQL.
解决方案
Use this code:
string myConnectionString = "server=localhost;database=testDB;uid=root;pwd=abc123;";
private void button1_Click(object sender, EventArgs e)
{
string connetionString = null;
MySqlConnection cnn ;
connetionString = "server=localhost;database=testDB;uid=root;pwd=abc123;";
cnn = new MySqlConnection(connetionString);
try
{
cnn.Open();
MessageBox.Show ("Connection Open ! ");
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Can not open connection ! ");
}
}
Make sure that you have a proper reference in your code:
using MySql.Data.MySqlClient;
And this connection string is just an example. You have to see what is your connection string ofc. And also search for these kind of questions because I'm sure that there is a bunch of similar or even the same questions on StackOverflow.