DataSource Controls :: How To Connect To Mysql With C#

oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = AnymoreComputers; User id=WeakUser2;Password=1234";

my site is working and running wrote in c# and mssql 2005,

now i want to make it run with mysql.....i converted all my data base...and created the same users (same names)

anc copied all to my sql .

the question is how do i connect to mysql wit c# ......

my regular connection for mssql :

oledbCon.ConnectionString = "Provider = SQLOLEDB.1; DATA Source = (local); Initial Catalog = test1; Integrated Security = SSPI; User ID=WeakUser2;Password=1234";
the connection to mysql :
oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = test1; User id=WeakUser2;Password=1234";

this connection doesnt works ... where is my mistake ? what hsould i do ... ?

and this is the error ig get when i run my solution :"The ConnectionString property has not been initialized."

i am using OleDbDataAdapter and dataSet ....