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