how do you connect to mysql database

[jlisec01]

Hey guys, just curious if anyone knows a good reference site, talks about how to connect to a mysql database, also if I do connect to a mysql database after switching over to access, would just the connection be different? thanks.

[WindowsHosting]

Hello,

You could check here - http://aspnet101.com/aspnet101/tutorials.aspx?id=39

Regards

[NightStalker-DNS]

Google can be your friend here.

No, not just the connection will change. They query syntax with also differ slightly depending on the usage.

[william_d_smith]

There are 2 methods to realize ASP.NET connect to Mysql Database.

1) use mysql support default "provider(http://www.mysql.com/products/connector/net/)".

using MySql.Data.MySqlClient; 

........ 
 MySqlConnection myConnection=new MySqlConnection("server=localhost;user id=root;password=XXXX;database=baby"); 
   string sql="select * from admin"; 
   MySqlDataAdapter myda=new MySqlDataAdapter(sql,myConnection); 
   DataSet mydataset=new DataSet(); 
   myda.Fill(mydataset,"admin"); 
           mydatagrid.DataSource=mydataset; 
   mydatagrid.DataBind(); 

2) use ODBC.NET.