Data Grid View

Question

Respected Sir 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.

Ankur Gupta · Answer

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