loginc2.ascx

来自「《精通ASP.NET网络编程》附带实例」· ASCX 代码 · 共 62 行

<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<script language="C#" runat="server">
  //单纯的属性
  public  string BackColor="white";
  //UserID:帐号的属性
  public string UserID
  {
   get
    {
     return Text1.Text;  //传回Text1的内容，成为UserID的属性值
    }
   set
    {
     Text1.Text=value;  //将UserID的属性值设定给Text1
    }
  }
 //UserID:密码的属性
  public string Password
   {
   get
    {
     return Text2.Text;  //传回Text2的内容，成为Password的属性值
    }
   set
    {
     Text2.Text=value;  //将Password的属性值设定给Text2
    }
   }

  public Boolean IsLoginOK()
   {
      string Provider, SQL, ConnStr;
      Provider="Microsoft.Jet.OLEDB.4.0;";
      ConnStr = "Provider="+Provider+"Data Source="+Server.MapPath("Sample.mdb");
      SQL = "Select * From Users Where UserID='"+UserID+"' And Password='"+Password+"'";
      OleDbDataAdapter Cmd = new OleDbDataAdapter(SQL,ConnStr);
      DataSet ds= new DataSet();
      Cmd.Fill(ds, "Users");
      DataTable dt= ds.Tables["Users"];
      if(dt.Rows.Count > 0)
         return true;
      else 
         return false;
  }     
</script>
<Table BgColor="<%=BackColor%>" BorderColor="Black" Cellspacing="10">
  <tr>
    <td>帐号:</td>
    <td><asp:TextBox id="Text1" runat="server"/></td>
  </tr>
  <tr>
    <td>密码:</td>
    <td><asp:TextBox id="Text2" TextMode="Password" runat="server"/>
    </td>
  </tr>
  <tr>
    <td></td>
    <td><asp:Button Text="登录" runat="server"/></td>
  </tr>
</Table>