I use DataView Control in ASP.Net. But i can not bind it with my MS Access Database. So please give me a source code to do this.
Data Grid View
Respected Sir,
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ankur GuptaPosted May 25, 2010, 4:35 AM
Dim conn As New System.Data.OleDb.OleDbConnection
conn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = C:\GrandviewNHDemo300.mdb ;Persist Security info = False")
conn.Open()
Dim objDataAdapter As New OleDbDataAdapter("Select * from syscod", conn)
Dim ds As New Data.DataSet
objDataAdapter.Fill(ds, "Tabel0")
DataGrid1.DataSource = ds
DataGrid1.DataBind()