求一个WinForm登录的代码，05做的，即时结贴

Question

    <form id="form1" runat="server">
        <asp:Login ID="Login1" runat="server" OnAuthenticate="Login1_Authenticate" LoginButtonText="登录" TitleText="">
        </asp:Login>
    </form>
  protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
        {
            //获取用户输入
            
            string loginName = Login1.UserName;
            string loginPassword = Login1.Password;
            DataBase db = new DataBase();
            // 连接数据库
            string sql;
           // OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["conString"]);
            //conn.Open();
            sql = "Select * From tblUsers Where strLoginName='" + loginName + "' And strLoginPassword='" + loginPassword + "'";
            OleDbCommand cmd = new OleDbCommand(sql,BasePage.conn);
            OleDbDataReader read = cmd.ExecuteReader();
            
            if (read.Read())
            {   e.Authenticated =true;
                Session["userid"] =read.GetInt32(0) ;
                Session["UserName"] = loginName;
                Response.Redirect("select.aspx");
            }
         
         
        }

Answer 1

差不多的吧        private void loginbtn_Click(object sender, EventArgs e) 
        { 
            //获取用户输入 
             
             string loginName = usernametextbox.text.Replace("'", "").Replace("or", "").Trim(); 
            string loginPassword = passwordtextbox.text.Replace("'", "").Replace("or", "").Trim(); 
            DataBase db = new DataBase(); 
            // 连接数据库 
             string sql; 
           // OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["conString"]); 
            //conn.Open(); 
            sql = "Select * From tblUsers Where strLoginName='" + loginName + "' And strLoginPassword='" + loginPassword + "'"; 
            OleDbCommand cmd = new OleDbCommand(sql,BasePage.conn); 
            OleDbDataReader read = cmd.ExecuteReader(); 
             
            if (read.HasRows) 
            {
               mainfrm main=new mainfrm();
               this.Hide();
               main.show();
            } 
          
          
        }

Answer 2

if (txtUser.Text == "" || txtPwd.Text == "")
            {
                MessageBox.Show("请输入用户名和密码！", "提示窗口",
                    MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            SqlConnection conn = new SqlConnection(ConnectionString.getConn());
            SqlCommand cmd = new SqlCommand();
            SqlParameter parUser = new SqlParameter("@User", txtUser.Text);
            SqlParameter parPwd = new SqlParameter("@Pwd", txtPwd.Text);
            cmd.Parameters.Add(parUser);
            cmd.Parameters.Add(parPwd);
            cmd.Connection = conn;
            cmd.CommandText = "select count(*) from 管理员表 where 账号=@User and 密码=@Pwd";
            conn.Open();
            int count = int.Parse(cmd.ExecuteScalar().ToString());
            if (count > 0)
            {
                frmControl f = new frmControl();
                this.Hide();//将登录窗口隐藏
                f.ShowDialog();//弹出新窗体
                this.Close();//将本窗体释放
            }
            else
            {
                MessageBox.Show("用户名密码不正确，请重新输入！", "提示窗口",
                    MessageBoxButtons.OK, MessageBoxIcon.Information);
                txtPwd.Text = "";
            }
            conn.Close();