VS2008中的SqlDataSource 能访问MYSQL数据库吗?
麻烦高手帮助一下。给出访问的方法的?一直都没接触过MYSQL的
[解决办法]
string conStr = "server=Microsoft.Jet.OLEDB.4.0;database=mysql;user id=jason;pwd=jason;"; OdbcConnection con = new OdbcConnection(conStr); OdbcCommand cmd = new OdbcCommand(); cmd.CommandText = "select * from host"; cmd.Connection = con; con.open(); OdbcDataAdapter adapter = new OdbcDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds, "t1"); dataGridView1.DataSource = ds.Tables["t1"];