Ask oneself that answers by oneself
Have already solved this problem
using System.Data.Odbc;
OdbcConnection conn;
OdbcDataAdapter ap;
DataSet ds = new DataSet();
string constr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=TEST;UID=root;PW D=pass;OPTION=3";conn = new OdbcConnection(constr);
conn.Open();
ap = new OdbcDataAdapter(cmdstr,conn);
ap.Fill(ds,"MyTable");
this.dgMy.DataSource = ds;
this.dgMy.DataMember = "MyTable";
|