6-16.aspx

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

<%@ 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"],"", "姓名", 
		DataViewRowState.CurrentRows);
	int rowIndex = dv.Find("小张");
	if (rowIndex == -1)
		Response.Write("没有找到！");
	else
		Response.Write(dv[rowIndex]["姓名"].ToString() + 
						dv[rowIndex]["数学"].ToString());
	//dg.DataSource = dv;
	dg.DataBind();
	Conn.Close();
}
</script>
<ASP:DataGrid id="dg" runat="server"/>