6-05.aspx

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

<% @ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
 void submit_Click(Object sender,EventArgs e) { 
   OleDbConnection Conn=new OleDbConnection(); 
   Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+
                       "Data Source="+Server.MapPath("person.mdb");
   Conn.Open();
   string sql="select * from grade";
   if (mytext.Text!="")
     sql="select * from grade where 姓名 like '%"+mytext.Text+"%'";
   Message.Text=sql;
   OleDbCommand Comm=new OleDbCommand(sql,Conn);
   OleDbDataReader dr=Comm.ExecuteReader();   
   dg.DataSource=dr;
   dg.DataBind();
   Conn.Close();
}
</script>
请输入被查询的人名关键字<br>
<form name="myform" runat="server">
<asp:TextBox  id="mytext" size="50" runat="server"/><br>
<asp:Button  id="submit"  onClick=submit_Click runat="server" Text="查询">
</asp:Button><br>
<asp:label id="Message" runat="server"/><br>
<asp:DataGrid id="dg" runat="server" />
</form>