typedataset not defined in System.Data.OleDb?

[Dan]

Hi,

I try to use dataset with OLEdb Access, but dataset is not defined (asp.net
2.0) when using VWD.

Imports System.Data.OleDb
Dim a As GridView
Dim d As OleDbDataAdapter
Dim ds As DataSet

Dim oConnection As OleDbConnection
oConnection = New OleDbConnection()

Dim comd As OleDbCommand
Dim sql As String
sql = "SELECT ...;"

Dim sConnectionString As String
sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source
= c:\mydb.mdb"
d = New OleDbDataAdapter(sql, sConnectionString)
ds = New DataSet()
a = New GridView

da.Fill(ds, "field1")
a.DataSource = ds
a.DataBind()
oConnection.Close()

Thanks

[Dan]

I found it.
Imports system.data and not only system.data.oledb
....

"Dan" <xx*@ddd.fv> wrote in message
news:uU*************@TK2MSFTNGP04.phx.gbl...

Hi,

I try to use dataset with OLEdb Access, but dataset is not defined (asp.net 2.0) when using VWD.

Imports System.Data.OleDb
Dim a As GridView
Dim d As OleDbDataAdapter
Dim ds As DataSet

Dim oConnection As OleDbConnection
oConnection = New OleDbConnection()

Dim comd As OleDbCommand
Dim sql As String
sql = "SELECT ...;"

Dim sConnectionString As String
sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\mydb.mdb"
d = New OleDbDataAdapter(sql, sConnectionString)
ds = New DataSet()
a = New GridView

da.Fill(ds, "field1")
a.DataSource = ds
a.DataBind()
oConnection.Close()

Thanks