6-11.aspx

来自「这是一个很好的基于数据库的系统」· ASPX 代码 · 共 21 行

<% @ Page Language="C#" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Script language="C#" runat="server">
void Page_Load(Object Src, EventArgs E) { 
	OleDbConnection Conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
                    "Data Source="+Server.MapPath("person.mdb"));
	string strSQL="select * from grade";
	OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
	OleDbDataAdapter da=new OleDbDataAdapter();
	da.SelectCommand=Comm;
	Conn.Open();
	DataSet ds = new DataSet();
	da.Fill(ds,"grade");
	dg.DataSource=ds.Tables["grade"].DefaultView;
	dg.DataBind();
	Conn.Close();
}
</script>
<ASP:DataGrid id="dg" runat="server"/>