6-15.aspx

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

<%@ Page Language="C#" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Script 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");
   DataView dv = new DataView(ds.Tables["grade"]);
   dv.RowFilter = " 数学 > 60";
   dv.Sort = "学号 desc, 数学 DESC";
   Response.Write("满足条件的记录有：" + dv.Count + "条");
   dg.DataSource = dv;
   dg.DataBind();
   Conn.Close();
}
</script>
<ASP:DataGrid id="dg" runat="server"/>