C
Christian Pické
Hi,
Take a look at this (sorry, it's in C#):
public DataSet GetMyDataSet()
{
OleDbConnection oConnection = new
OleDbConnection(GetConnectionString());
OleDbCommand oCommand = new OleDbCommand("SELECT * FROM myTable");
OleDbDataAdapter oAdapter = new OleDbDataAdapter();
oAdapter.SelectCommand = oCommand;
DataSet oDataSet = new DataSet();
oConnection.Open();
oAdapter.Fill(oDataSet);
return oDataSet;
}
You don't need to use a DataReader to fill a dataset. You use a datareader
to read records one by one.
Kind regards,
Christian
Take a look at this (sorry, it's in C#):
public DataSet GetMyDataSet()
{
OleDbConnection oConnection = new
OleDbConnection(GetConnectionString());
OleDbCommand oCommand = new OleDbCommand("SELECT * FROM myTable");
OleDbDataAdapter oAdapter = new OleDbDataAdapter();
oAdapter.SelectCommand = oCommand;
DataSet oDataSet = new DataSet();
oConnection.Open();
oAdapter.Fill(oDataSet);
return oDataSet;
}
You don't need to use a DataReader to fill a dataset. You use a datareader
to read records one by one.
Kind regards,
Christian