Connect MYSQL From C# coding

Can You pl. explain me to how connect MYSQL by C# coding? what are the class need?

 

You will have to check up the support on this one. But it can be done I mean a lot of applications use both technologies rolled into one.

 

Since C# is Microsoft, use the MySQL ODBC connector (download it from the MySQL site) and use an ODBC (ADODB is easy) connection.

 

hi l want to ask , how to run , c # from sorce code which l havve download fromnet

 

first you need to download Connector/Net 1.0.10
i found this on the web:

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();
}

 

Thank you so uch , thank u again, l will try, l know with php but l have to try with c#