login.aspx.cs

库存管理系统V1.0源码 版本说明: 1.开发工具vs2005,数据库sql2005 2.数据库的连接字符串在web.config文件中

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Login : System.Web.UI.Page
{
    private readonly string ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session["Admin"] = this.TextBox1.Text.Trim();
        }
			
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      //创建连接字符串
			string sqlstr;
            sqlstr = "select Pwd from tb_User where UserName=@adminname";
			SqlConnection scon=new SqlConnection(ConnectionString);
			SqlCommand scm= new SqlCommand(sqlstr,scon);
			scm.Parameters.Add("@adminname",SqlDbType.VarChar,20);
			scm.Parameters["@adminname"].Value=this.TextBox1.Text.Trim();
			scon.Open();
			SqlDataReader reader=scm.ExecuteReader();
			if (reader.Read())
			{
				
				string strPwd=reader[0].ToString();

				reader.Close();
				if(strPwd!=TextBox2.Text.Trim())
				{
					this.LabelMsg.Text="密码错误！";
				}
				else
				{
                    Response.Redirect("ManageList.aspx");
				}
				
			}
			else
			{
				this.LabelMsg.Text="对不起,您没有权限!";
				scon.Close();
			}

		}

    protected void Button2_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
        this.TextBox2.Text = "";
    }
}