basic MS Access Question.. get a data into a dataset

[Aussie Rules]

Hi,

Just learning how to use VB.net and Access databases. I am use to working
against a SQL server.

I have a Oledb connection to an access database. I have created a query in
the access database that I want to create a dataset in my vb app using the
query data.

I am able to get the query results into a reader, but I need it in a
dataset, as a thirdpart grid i am using requires a dataset (as it has a
iBindinglist)

my code for the datareader is :

dim dbConnection As New OleDbConnection
dbConnection.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data
Sou... ETC..)
dbConnection.Open()
dim command As New OleDbCommand("select * from projectcosts", dbConnection)

dim reader As OleDbDataReader = command.ExecuteReader()
what do i have to do to get my result into a dataset ?

Thanks

[Jack Jackson]

On Sat, 16 Feb 2008 06:59:52 -0000, "Aussie Rules" <au****@nospam.com>
wrote:

>Hi,

Just learning how to use VB.net and Access databases. I am use to working
against a SQL server.

I have a Oledb connection to an access database. I have created a query in
the access database that I want to create a dataset in my vb app using the
query data.

I am able to get the query results into a reader, but I need it in a
dataset, as a thirdpart grid i am using requires a dataset (as it has a
iBindinglist)

my code for the datareader is :

dim dbConnection As New OleDbConnection
dbConnection.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data
Sou... ETC..)
dbConnection.Open()
dim command As New OleDbCommand("select * from projectcosts", dbConnection)

dim reader As OleDbDataReader = command.ExecuteReader()
what do i have to do to get my result into a dataset ?

Look at DataSet.Load()

[Steve Gerrard]

Aussie Rules wrote:

Hi,

Just learning how to use VB.net and Access databases. I am use to
working against a SQL server.

I have a Oledb connection to an access database. I have created a
query in the access database that I want to create a dataset in my vb
app using the query data.

dim dbConnection As New OleDbConnection
dbConnection.ConnectionString =
("Provider=Microsoft.ACE.OLEDB.12.0;Data Sou... ETC..)
dbConnection.Open()
dim command As New OleDbCommand("select * from projectcosts",
dbConnection)

I would ditch the reader, and use an adapter, something like this:

Dim ds As New DataSet
Dim da As New OleDbDataAdapter(command)
da.Fill(ds)