dataset.aspx

来自「我收集完成的 asp.net 源程序第2部分」· ASPX 代码 · 共 36 行

ASPX
36
字号
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
public void Page_Load(Object src,EventArgs e)
{
	//连接语句
	string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\db1.mdb;";
	string strSel = "select * from Score";
	DataSet ds = new DataSet();

	OleDbConnection MyConn = new OleDbConnection(MyConnString);
	OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
	MyAdapter.Fill(ds,"Score");

	score.DataSource = ds;
	score.DataMember = "Score";
	score.DataBind();

}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<b>演示DataSet</b>
<asp:DataGrid id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
</form>
</body>
</html>

⌨️ 快捷键说明

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