study_dataadapter

Imports System.Data
Imports System.Data.OleDb
Public Class WebForm1
    Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Dim MYCONNECTION As OleDbConnection
    Dim MYDATAADAPTER As OleDbDataAdapter
    Dim MYDATASET As DataSet = New DataSet
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        MYCONNECTION = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/TEST.mdb")
        'Dim MYCOMMAND As New OleDbCommand("SELECT * FROM test", MYCONNECTION)
        MYDATAADAPTER = New OleDbDataAdapter("SELECT * FROM test", MYCONNECTION)
        MYDATAADAPTER.Fill(MYDATASET, "TEST")
        DataGrid1.DataSource = MYDATASET.Tables("TEST").DefaultView
        DataGrid1.DataBind()
        MYCONNECTION.Close()
    End Sub
End Class