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

  • Thread starter Thread starter Aussie Rules
  • Start date Start date
A

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
 
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 ?
Click to expand...

Look at DataSet.Load()
 
Aussie said:
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)
Click to expand...

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)
 
Hi,

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

You can use SQL Server Compact Edition or SQL Server Express, both are
free SQL Server products from Microsoft :-)

what do i have to do to get my result into a dataset ?
Click to expand...

To create a dataset you need to:

1. Open a Connection
2. Create a Command Object
3. Create a empty Dataset
4. Create a table adapter
5. Assign the command object to the table adapater
6. Fill the dataset with the table adapter

It's a lot of steps, but do it a couple times and it's not so bad.

Here is an example:

http://msdn2.microsoft.com/en-us/library/bh8kx08z(VS.71).aspx
 
Back
Top