测试代码如下,你们执行后看看ds里面的table,bb里面是aa的内容.太垃圾了:
DataSet ds = new DataSet();
MySQLConnection conn = new MySQLConnection();
conn.ConnectionString = "Data Source=test;Location=localhost;User ID=root;Password=root;Character Set =gb2312";
MySQLDataAdapter da = new MySQLDataAdapter("SELECT * FROM aa", conn);
da.Fill(ds, "aa");
da.SelectCommand.CommandText = "SELECT * FROM bb";
da.Fill(ds, "bb");
DataSet ds = new DataSet();
MySQLConnection conn = new MySQLConnection();
conn.ConnectionString = "Data Source=test;Location=localhost;User ID=root;Password=root;Character Set =gb2312";
MySQLDataAdapter da = new MySQLDataAdapter("SELECT * FROM aa", conn);
da.Fill(ds, "aa");
da.SelectCommand.CommandText = "SELECT * FROM bb";
da.Fill(ds, "bb");
conns.ConnectionString = "USER ID=sa;PASSWORD=sa;INITIAL CATALOG=test; DATA SOURCE=.;CONNECT TIMEOUT=30";
SqlDataAdapter das = new SqlDataAdapter("SELECT * FROM aa", conns);
das.Fill(ds, "aa");
das.SelectCommand.CommandText = "SELECT * FROM bb";
das.Fill(ds, "bb");
1、不知lz是不是用的mysql.net,这个东西不是mysql官方的,而是开源程序员自己编写的。
2、mysql没有收取你的费用,mysql没有理由来承担过错。
3、再说了,软件这东西,难免有bug,你敢保证你写的软件没有bug?遇到这样的问题,有源代码就dubug下,如果没有源代码,就给作者发邮件,这才是负责的态度。
MySQLConnection conn = new MySQLConnection();
conn.ConnectionString = "Data Source=test;Location=localhost;User ID=root;Password=root;Character Set =gb2312";
MySQLDataAdapter da = new MySQLDataAdapter("SELECT * FROM aa", conn);
DataTable dt = new DataTable();
da.Fill(dt);
ds.Tables.Add(dt);
DataTable dt1 = new DataTable();
da.SelectCommand.CommandText = "SELECT * FROM bb";
da.Fill(dt);
ds.Tables.Add(dt1);
有事情要解决事情,我们是开发者