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
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