dataset2.aspx

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

ASPX
44
字号
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<html>
<Script Language=C# Runat=Server>
  void Page_Load(Object Src, EventArgs E)
   {
      OleDbConnection dtConn;
      OleDbDataAdapter dtCmd;
      DataSet dtSet;
      String sSQL;
      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();
    }
     
     
</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 + -
显示快捷键?