How to connect to MySQL 5.0. via C# .Net and the MySql Connector/Net

How to connect to MySQL 5.0 using c# and mysql connector/net!: "How to connect to MySQL 5.0. via C# .Net and the MySql Connector/Net"

This article and tutorial describes and demonstrates how you can connect to MySQL in a c# application.
First, you need to install the mysql connector/net, it is located at: http://dev.mysql.com/downloads/connector/net/1.0.html
Next create a new project
Next add reference to: MySql.Data
Next add "using MySql.Data.MySqlClient;"
Finally add the following code to your application:

{
string MyConString = "SERVER=localhost;" +"DATABASE=mydatabase;" +"UID=testuser;" +"PASSWORD=testpassword;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from mycustomers";
connection.Open();
Reader = command.ExecuteReader();
while (Reader.Read())
{
string thisrow = "";
for (int i= 0;ithisrow+=Reader.GetValue(i).ToString() + ",";
listBox1.Items.Add(thisrow);
}
connection.Close();
}

www.visli.com