How can i connect my app to mysql?

Greetings everyone,

I just discovered this forum which seems to be a reliable source of information about C# programming and databases implementation.

Now, I give a try wondering whether one of you knows how to install ByteFX .NET 0.76 with SharpDevelop 2.0. I firstly downloaded and installed the driver on my machine, but I can't use it...

       "using ByteFX.Data.MySqlClient;"

An error displays that ByteFX can not be found... I read about somewhat an assembly or something, but I can't be sure. Might someone help me resolve this issue ?

Thank you in advance.

WILL.

you need to download a driver for that.
there are few connectors in the net.
you can try bytefx or something substantial.

Happy coding :)

Using NameSpace :

using System.Data;
using System.Data.OleDb;

Put this code in function:

OleDbConnection conn=new OleDbConnection("");
            conn.ConnectionString="Provider=MySQLProv;Data Source=mysql;";
            try
            {
                conn.Open();
                if (conn.State==ConnectionState.Open)
                MessageBox.Show("Connection to MySQL opened through OLE DB Provider");
                conn.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

Using NameSpace :

using System.Data;
using System.Data.OleDb;

Put this code in function:

OleDbConnection conn=new OleDbConnection("");
            conn.ConnectionString="Provider=MySQLProv;Data Source=mysql;";
            try
            {
                conn.Open();
                if (conn.State==ConnectionState.Open)
               MessageBox.Show("Connection to MySQL opened through OLE DB Provider");
                conn.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

Using NameSpace :

using System.Data;
using System.Data.OleDb;

Call this function:

           private void connectToMySql()
            {
             OleDbConnection conn=new OleDbConnection("");
             conn.ConnectionString="Provider=MySQLProv;Data Source=mysql;";
             try
             {
                 conn.Open();
                 if (conn.State==ConnectionState.Open)
                     MessageBox.Show("Connection to MySQL opened through OLE DB Provider");
                 conn.Close();
             }
             catch(Exception ex)
             {
                MessageBox.Show(ex.Message);
             }
          }