代码如下:
private void button14_Click(object sender, EventArgs e)
{
OleDbConnection myconn = new OleDbConnection("Server=192.168.0.217;Database=kfbdata;user id=eos;password=eossoft;port=3306;Provider=MySqlProv;Character Set=gb2312");
myconn.Open();
string CommandText = "select * from stusers";
DataSet ds = new DataSet();
OleDbDataAdapter myreader = new OleDbDataAdapter(CommandText, myconn);
myreader.Fill(ds, "hard");
dataGridView2.DataSource = ds.Tables["hard"];
}
执行 myreader.Fill(ds, "hard");的时候报错:‘MySqlProv”失败,没有可用的错误消息,结果代码: DB_E_ERRORSINCOMMAND(0x80040E14)。
是什么原因?
private void button14_Click(object sender, EventArgs e)
{
OleDbConnection myconn = new OleDbConnection("Server=192.168.0.217;Database=kfbdata;user id=eos;password=eossoft;port=3306;Provider=MySqlProv;Character Set=gb2312");
myconn.Open();
string CommandText = "select * from stusers";
DataSet ds = new DataSet();
OleDbDataAdapter myreader = new OleDbDataAdapter(CommandText, myconn);
myreader.Fill(ds, "hard");
dataGridView2.DataSource = ds.Tables["hard"];
}
执行 myreader.Fill(ds, "hard");的时候报错:‘MySqlProv”失败,没有可用的错误消息,结果代码: DB_E_ERRORSINCOMMAND(0x80040E14)。
是什么原因?
using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open();