{"id":59,"date":"2008-02-11T03:24:36","date_gmt":"2008-02-11T03:24:36","guid":{"rendered":""},"modified":"2008-02-11T03:24:36","modified_gmt":"2008-02-11T03:24:36","slug":"59","status":"publish","type":"post","link":"https:\/\/www.poloo.org\/?p=59","title":{"rendered":"\u5229\u7528C#\u6765\u505aASP.NET\u7684\u767b\u9646\u9875\u9762"},"content":{"rendered":"

\u4e00\u3001\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93
\u3000\u3000\u65b0\u5efa\u4e00\u4e2aaccess\u6570\u636euser.mdb\u3002
\u3000\u3000\u65b0\u5efa\u4e00\u4e2auser\u8868\uff0c\u6dfb\u52a0\uff1aUserId\uff08\u6587\u672c\u7c7b\u578b\uff09\u53caPassword\uff08\u6587\u672c\u7c7b\u578b\uff09\u4e24\u4e2a\u5b57\u6bb5\u3002
\u4e8c\u3001\u65b0\u5efa\u4e00\u4e2adefault.aspx\u6587\u4ef6\u3002
\u3000\u3000\u5728Web Form\u91cc\uff1a
\u3000\u3000\u52a0\u5165\u4e24\u4e2aLabel\u63a7\u4ef6,Text\u5c5e\u6027\u5206\u522b\u4e3a\u201c\u767b\u5f55\u540d\u201d\u548c\u201c\u5bc6\u7801\u201d\uff1b
\u3000\u3000\u52a0\u5165\u4e24\u4e2aTextBox\u63a7\u4ef6,ID\u5c5e\u6027\u5206\u522b\u4e3a\u201cUserid\u201d\u548c\u201cPwd\u201d\uff0cText\u5c5e\u6027\u5747\u4e3a\u7a7a\uff1b
\u3000\u3000\u52a0\u5165\u4e24\u4e2aRequiredFieldValidato\u63a7\u4ef6\uff0cID\u5c5e\u6027\u5206\u522b\u4e3a\u201crfvUserid\u201d\u548c\u201crfvPwd\u201d\uff0cText\u5c5e\u6027\u5206\u522b\u4e3a\u201c\u8bf7\u8f93\u5165\u767b\u5f55\u540d\uff01\u201d\u548c\u201c\u8bf7\u8f93\u5165\u767b\u5f55\u5bc6\u7801\uff01\u201d\uff0cControlToValidate\u5c5e\u6027\u5206\u522b\u4e3a”Userid”\u548c”Pwd”\uff1b
\u3000\u3000\u52a0\u5165\u4e00\u4e2aButton\u63a7\u4ef6,ID\u5c5e\u6027\u4e3a\u201cLogButton\u201d\uff0cText\u5c5e\u6027\u522b\u4e3a\u201c\u767b\u5f55\u201d\uff1b
\u3000\u3000\u6700\u540e\u52a0\u5165\u4e00\u4e2aLabel\u63a7\u4ef6\uff0cID\u5c5e\u6027\u4e3a\u201cMsg\u201d\u3002
\u3000\u3000Default.aspx\u6e90\u4ee3\u7801\u5982\u4e0b\uff1a

<%@ Page language=\"c#\" Codebehind=\"default.aspx.cs\" AutoEventWireup=\"false\" Inherits=\"lsj.WebForm1\" %>
<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.0 Transitional\/\/EN\" >
<HTML>
<HEAD>
<meta name=\"GENERATOR\" Content=\"Microsoft Visual Studio 7.0\">
<meta name=\"CODE_LANGUAGE\" Content=\"C#\">
<meta name=\"vs_defaultClientScript\" content=\"JavaScript (ECMAScript)\">
<meta name=\"vs_targetSchema\" content=\"http:\/\/schemas.microsoft.com\/intellisense\/ie5<\/a>\">
<\/HEAD>
<body MS_POSITIONING=\"GridLayout\">
<FONT face=\"\u5b8b\u4f53\">
<form runat=\"server\" ID=\"Form1\">
<asp:Label id=\"Label1\" style=\"Z-INDEX: 101; LEFT: 82px; POSITION: absolute; TOP: 39px\" runat=\"server\" Width=\"55px\"<\/p>\n

Height=\"26px\">\u767b\u5f55\u540d<\/asp:Label>
<asp:Label id=\"Label2\" style=\"Z-INDEX: 102; LEFT: 80px; POSITION: absolute; TOP: 84px\" runat=\"server\" Width=\"63px\" Height=\"24px\">\u5bc6\u3000\u7801<\/asp:Label>
<asp:TextBox id=\"Userid\" style=\"Z-INDEX: 103; LEFT: 161px; POSITION: absolute; TOP: 39px\" runat=\"server\" Width=\"109px\" Height=\"25px\"><\/asp:TextBox>
<asp:TextBox id=\"Pwd\" style=\"Z-INDEX: 104; LEFT: 162px; POSITION: absolute; TOP: 81px\" runat=\"server\" Width=\"109px\" Height=\"22px\" TextMode=\"Password\"><\/asp:TextBox>
<asp:Button id=\"LogButton\" style=\"Z-INDEX: 105; LEFT: 79px; POSITION: absolute; TOP: 125px\" runat=\"server\" Width=\"59px\" Height=\"25px\" Text=\"\u767b\u3000\u5f55\"><\/asp:Button>
<asp:Label id=\"Msg\" style=\"Z-INDEX: 106; LEFT: 161px; POSITION: absolute; TOP: 130px\" runat=\"server\" Width=\"117px\" Height=\"26px\"><\/asp:Label>
<asp:RequiredFieldValidator id=\"RequiredFieldValidator1\" style=\"Z-INDEX: 107; LEFT: 290px; POSITION: absolute; TOP: 43px\" runat=\"server\" Width=\"162px\" Height=\"18px\" ErrorMessage=\"RequiredFieldValidator\" ControlToValidate=\"Userid\">\u8bf7\u8f93\u5165\u767b\u5f55\u540d\uff01<\/asp:RequiredFieldValidator>
<asp:RequiredFieldValidator id=\"RequiredFieldValidator2\" style=\"Z-INDEX: 108; LEFT: 292px; POSITION: absolute; TOP: 83px\" runat=\"server\" Width=\"175px\" Height=\"22px\" ErrorMessage=\"RequiredFieldValidator\" ControlToValidate=\"Pwd\">\u8bf7\u8f93\u5165\u767b\u5f55\u5bc6\u7801\uff01<\/asp:RequiredFieldValidator>
<\/form>
<\/FONT>
<\/body>
<\/HTML>
<\/code><\/p>\n

\u4e09\u3001\u7f16\u5199default.aspx.cs\u6587\u4ef6\u3002
\u3000\u3000\u53cc\u51fbLogButton\uff0c
\u3000\u3000\uff11\u3001\u52a0\u5165using System.Data.OleDb;
\u3000\u3000\uff12\u3001\u5148\u5728class\u4e2d\u58f0\u660e\uff1a
\u3000\u3000public string strConnection;
\u3000\u3000OleDbConnection myConn;
\u3000\u3000\uff13\u3001\u52a0\u5165\u6570\u636e\u5e93\u94fe\u63a5\uff1a
\u3000\u3000\u628a\u4e0b\u9762\u4ee3\u7801\u52a0\u5165\u201cPage_Init(object sender, EventArgs e)\u201d\u7684\u201cInitializeComponent();\u201d\u540e\u9762.
\u3000\u3000string strConnection=\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"+Server.MapPath(\".\")+\"..\\user.mdb;\";
\u3000\u3000myConn=new OleDbConnection(strConnection);
<\/code>
\u3000\u3000\uff14\u3001\u5728LogButton_Click(object sender, System.EventArgs e)\u4e8b\u4ef6\u4e2d\u52a0\u5165\u4e0b\u9762\u7684\u4ee3\u7801\uff1a
string userid,pwd;
userid=Userid.Text;
pwd=Pwd.Text;
string mySel=\"Select count(*) as iCount from user where UserID=\"\"+userid+\"\"\";<\/p>\n

OleDbCommand myCmd1=new OleDbCommand(mySel,myConn);
myCmd1.Connection.Open();
OleDbDataReader Dr1;
Dr1=myCmd1.ExecuteReader();
Dr1.Read();
string Count=Dr1[\"iCount\"].ToString();
Dr1.Close();
myCmd1.Connection.Close();
string DrPwd,DrRoles;
if(Count!=\"0\")
{
\u3000mySel=\"Select * from user where UserID=\"\"+userid+\"\"\";
\u3000OleDbCommand myCmd=new OleDbCommand(mySel,myConn);
\u3000myCmd.Connection.Open();
\u3000OleDbDataReader Dr;
\u3000Dr=myCmd.ExecuteReader();
\u3000Dr.Read();
\u3000DrPwd=Dr[\"Password\"].ToString();
\u3000Dr.Close();
\u3000if(DrPwd==pwd)
\u3000{
\u3000\u3000Session[\"logid\"]=userid;
\u3000\u3000Response.Redirect(\"main.aspx\");
\u3000}
\u3000else
\u3000\u3000Msg.Text=\"\u767b\u5f55\u5bc6\u7801\u9519.\";
}
else
\u3000\u3000Msg.Text=\"\u6ca1\u6709\u8fd9\u4e2a\u7528\u6237.\";
<\/code><\/p>\n

\u3000\u3000\u597d\u4e86\uff0c\u5168\u90e8\u5de5\u4f5c\u5df2\u7ecf\u5b8c\u6210\uff0cdefault.aspx.cs\u6e90\u4ee3\u7801\u5982\u4e0b\uff1a

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;<\/p>\n

namespace lsj
{
\u3000\/\/\/ <summary>
\u3000\/\/\/ Summary description for WebForm1.
\u3000\/\/\/ <\/summary>
\u3000public class WebForm1 : System.Web.UI.Page
\u3000{
\u3000\u3000protected System.Web.UI.WebControls.Label Label1;
\u3000\u3000protected System.Web.UI.WebControls.Label Label2;
\u3000\u3000protected System.Web.UI.WebControls.TextBox Userid;
\u3000\u3000protected System.Web.UI.WebControls.Button LogButton;
\u3000\u3000protected System.Web.UI.WebControls.TextBox Pwd;
\u3000\u3000protected System.Web.UI.WebControls.Label Msg;
\u3000\u3000protected System.Web.UI.HtmlControls.HtmlForm Form1;\u3000\u3000
\u3000\u3000protected System.Web.UI.WebControls.RequiredFieldValidator rfvUserid;
\u3000\u3000protected System.Web.UI.WebControls.RequiredFieldValidator rfvPwd;
\u3000\u3000public string strConnection;
\u3000\u3000OleDbConnection myConn;<\/p>\n

\u3000\u3000public WebForm1()
\u3000\u3000{
\u3000\u3000\u3000Page.Init += new System.EventHandler(Page_Init);
\u3000\u3000}<\/p>\n

\u3000\u3000private void Page_Load(object sender, System.EventArgs e)
\u3000\u3000{
\u3000\u3000}<\/p>\n

\u3000\u3000private void Page_Init(object sender, EventArgs e)
\u3000\u3000{
InitializeComponent();
string strConnection=\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"+Server.MapPath(\".\")+\"..\\user.mdb;\";
\/\/user.mdb\u653e\u5728\u4e0easpx\u6587\u4ef6\u540c\u4e00\u76ee\u5f55\u4e0b
myConn=new OleDbConnection(strConnection);
\u3000\u3000}<\/p>\n

\u3000\u3000private void InitializeComponent()
\u3000\u3000{
this.LogButton.Click += new System.EventHandler(this.LogButton_Click);
this.Load += new System.EventHandler(this.Page_Load);
\u3000\u3000}<\/p>\n

\u3000\u3000private void LogButton_Click(object sender, System.EventArgs e)
\u3000\u3000{
string userid,pwd;
userid=Userid.Text;
pwd=Pwd.Text;
string mySel=\"Select count(*) as iCount from user where UserID=\"\"+userid+\"\"\";<\/p>\n

OleDbCommand myCmd1=new OleDbCommand(mySel,myConn);
myCmd1.Connection.Open();
OleDbDataReader Dr1;
Dr1=myCmd1.ExecuteReader();
Dr1.Read();
string Count=Dr1[\"iCount\"].ToString();
Dr1.Close();
myCmd1.Connection.Close();
string DrPwd,DrRoles;
if(Count!=\"0\")
{
\u3000mySel=\"Select * from user where UserID=\"\"+userid+\"\"\";
\u3000OleDbCommand myCmd=new OleDbCommand(mySel,myConn);
\u3000myCmd.Connection.Open();
\u3000OleDbDataReader Dr;
\u3000Dr=myCmd.ExecuteReader();
\u3000Dr.Read();
\u3000DrPwd=Dr[\"Password\"].ToString();
\u3000Dr.Close();
\u3000if(DrPwd==pwd)
\u3000{
\u3000\u3000Session[\"logid\"]=userid;\/\/\u65b0\u5efa\u4e00\u4e2aSession
\u3000\u3000Response.Redirect(\"main.aspx\");
\u3000}
\u3000\u3000else
  Msg.Text=\"\u767b\u5f55\u5bc6\u7801\u9519.\";
}
else
\u3000\u3000Msg.Text=\"\u6ca1\u6709\u8fd9\u4e2a\u7528\u6237.\";
\u3000\u3000}
\u3000}
}
<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e00\u3001\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u3000\u3000\u65b0\u5efa\u4e00\u4e2aaccess\u6570\u636euser.mdb\u3002\u3000\u3000...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-NET"],"_links":{"self":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=59"}],"version-history":[{"count":0,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/59\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}