typedataset not defined in System.Data.OleDb?

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,062
Latest member
OrderKetozenseACV

Latest Threads

Top