麻烦高手帮助一下。给出访问的方法的?一直都没接触过MYSQL的
------解决方案--------------------------------------------------------
- C# code
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"];