6-10.aspx

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

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