public DataSet getAll2()
{
ms2 = new MySqlData();
my2 = new MySqlConnection("data source=192.168.1.8_3306;server=192.168.1.8;DATABASE=pidb;UID=root;PWD=pidb2012;");
if (my2.State == ConnectionState.Closed)
my2.Open();
DataSet ds;
try
{
string cmd = "select * from fileline where isdump<>'unload' order by filename desc";
ds= ms2.Getds(cmd,"b");
}
catch
{
return null;
}
my2.Close();
return ds;
}总是提示Fill: SelectCommand.Connection 属性尚未初始化。初学C#, 小白求大神指教啊
MySqlData ms2;这是全局的
{
MySqlDataAdapter sqlda = new MySqlDataAdapter(M_str_sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds, M_str_table);
sqlda.Dispose();
return myds;
}
public System.Data.DataSet Getds(string M_str_sqlstr, string M_str_table)
{
using(MySqlDataAdapter sqlda = new MySqlDataAdapter(M_str_sqlstr, sqlcon))
{
DataSet myds = new DataSet();
sqlda.Fill(myds, M_str_table);
return myds;
}
}
{
MySqlDataAdapter sqlda = new MySqlDataAdapter(M_str_sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds, M_str_table);
sqlda.Dispose();
return myds;
}请问sqlcon这一个全局变量的初始化在哪里,如果没有的话,请你修改这个函数,把my2这个值当作参数传进函数中,最终改为public System.Data.DataSet Getds(string M_str_sqlstr, string M_str_table,SqlConnection sqlcon)
{
MySqlDataAdapter sqlda = new MySqlDataAdapter(M_str_sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds, M_str_table);
sqlda.Dispose();
return myds;
}在这里做修改ds= ms2.Getds(cmd,"b"); 改为ds=ms2.Getds(cmd,"b",my2);