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 + -
显示快捷键?