dataset1.aspx

来自「《精通ASP.NET网络编程》附带实例」· ASPX 代码 · 共 47 行

ASPX
47
字号
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<html>
<Script Language=VB Runat=Server>
   Sub Page_Load(Sender As Object, e As EventArgs)
      Dim dtConn As OleDbConnection
      Dim dtCmd As OleDbDataAdapter
      Dim dtSet As DataSet
      Dim sSQL As String
      sSQL = "Select * From 学生成绩表;"

      dtConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Sample.mdb"))

      dtCmd = New OleDbDataAdapter(sSql, dtConn)

    
      dtSet = New DataSet
      dtCmd.Fill(dtSet)
      myDataGrid.DataSource=dtSet.Tables(0).DefaultView
      myDataGrid.DataBind()
    ENd Sub 
     
     
</Script>
<body>

    <h3><font face="Verdana">使用DataSet读取数据</font></h3>

    <form runat=server>

      <ASP:DataGrid id="myDataGrid" runat="server"
        BorderColor="black"
        BorderWidth="1"
        GridLines="Both"
        CellPadding="3"
        CellSpacing="0"
        Font-Name="Verdana"
        Font-Size="8pt"
        HeaderStyle-BackColor="#aaaadd"
      />

  </form>


</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?