想在ds中fill多个数据表,但是每次fill后ds中只有最后一个表。咋回事呢???public class DataRecord
{
private string SQL;
private string DSN;
private string DSTABLE;
private SqlConnection conn;
public SqlDataAdapter da;
public static DataSet ds;
public DataRecord(string sql,string dsn,string dstable)
{
SQL=sql;
DSN=dsn;
DSTABLE=dstable;
conn=new SqlConnection(DSN);
da=new SqlDataAdapter(SQL,conn);
ds=new DataSet();
}
public DataSet Fill()
{
da.Fill(ds,DSTABLE);
return ds;
}
}
{
private string SQL;
private string DSN;
private string DSTABLE;
private SqlConnection conn;
public SqlDataAdapter da;
public static DataSet ds;
public DataRecord(string sql,string dsn,string dstable)
{
SQL=sql;
DSN=dsn;
DSTABLE=dstable;
conn=new SqlConnection(DSN);
da=new SqlDataAdapter(SQL,conn);
ds=new DataSet();
}
public DataSet Fill()
{
da.Fill(ds,DSTABLE);
return ds;
}
}
{
private string SQL;
private string DSN;
private string DSTABLE;
private SqlConnection conn;
public SqlDataAdapter da;
public static DataSet ds=new DataSet();
public DataRecord(string sql,string dsn,string dstable)
{
SQL=sql;
DSN=dsn;
DSTABLE=dstable;
conn=new SqlConnection(DSN);
da=new SqlDataAdapter(SQL,conn);
}
public DataSet Fill()
{
da.Fill(ds,DSTABLE);
return ds;
}
}
public static DataSet ds=new DataSet();应该就对了吧.
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx