study_dataadapter手工显数据

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

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

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection

    End Sub
    Protected WithEvents OleDbConnection1 As System.Data.OleDb.OleDbConnection

    '注意: 以下占位符声明是 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

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim myconnection As OleDbConnection
        Dim mydataadapter As OleDbDataAdapter
        Dim mydataset As DataSet
        Dim mydatatable As DataTable
        Dim mydatarow As DataRow
        Dim mydatacolumn As DataColumn

        myconnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/TEST.mdb")
        mydataadapter = New OleDbDataAdapter("SELECT top 3 * FROM test", myconnection)
        mydataset = New DataSet
        mydataadapter.Fill(mydataset, "test")
        mydatatable = mydataset.Tables("test")
        For Each mydatacolumn In mydatatable.Columns
            Response.Write(mydatacolumn.ColumnName)
            ' Response.Write("<br>")
        Next
        Response.Write("<br>")
        For Each mydatarow In mydatatable.Rows
            For Each mydatacolumn In mydatatable.Columns
                Response.Write(mydatarow(mydatacolumn))

            Next
            Response.Write("<br>")
        Next
        myconnection.Close()
    End Sub

End Class

 

IDart_col_subart_titlephotofileuploadtimeIP
25507主任医师2004-7-25 15:04:34127.0.0.1
25517副主任医师2004-7-25 15:04:58127.0.0.1
25527护士2004-7-25 15:05:22127.0.0.1