How to connect to MySQL 5.0 using c# and mysql connector/net!

Main Menu

Home

Product Sections

Articles

.net Network Security

Flash

Fireworks

PHP

DB/C

Java

Email File Extensions

EML email file extension

MSG email file extension

TNEF email file extension

TXT email file extension

HTML email file extension

Java Script

OISV - Organization of Independant Software Vendors - Charter Member

Recommended Links

Find good sites at

Web Master:

Keith Birchfield

	MySql Excel Exporter BitDaddys Corp. FREE More Info Free Download
Create Excel Spreadsheets from your MySQL data. more ...

MySQL Tutorials Table Of Contents

Part 1: Start MySQL and Create Databases and Tables (Create)

Part 2: Add Data (Insert and Replace)

Part 3: Show Data (Select)

Part 4: Delete Data (Delete and Drop)

Part 5: Backup Data (Dump)

How to use 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:

private void button1_Click(object sender, System.EventArgs e)
		{
			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;i<Reader.FieldCount;i++)
						thisrow+=Reader.GetValue(i).ToString() + ",";
				listBox1.Items.Add(thisrow);
			}
			connection.Close();
		}