login.aspx.cs

来自「管理系统源码 很好的用于参考很好对开发毕业设计很有帮助」· CS 代码 · 共 62 行

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {     

    }
    protected void btncancel_Click(object sender, ImageClickEventArgs e)
    {
        txtname.Text = string.Empty;
        txtpwd.Text = string.Empty;
    }
    protected void btnreg_Click(object sender, ImageClickEventArgs e)
    {
        //Response.Redirect("regester.aspx") ;
        Response.Write("<script>window.close();window.open('regester.aspx','','status=no,scrollbars=no,top=200,left=150,width=750,height=380')</script>");
    }
    protected void btnok_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection conn = new SqlConnection("server=(local);database=school;uid=sa;pwd=");

        string strLogin = "select * from [User] where UserName='" + txtname.Text.Trim() + "' and Password='" + txtpwd.Text.Trim() + "'";
        SqlDataAdapter adapter = new SqlDataAdapter(strLogin, conn);
        DataSet dsLogin = new DataSet();

        try
        {
            conn.Open();

            adapter.Fill(dsLogin, "login");

            if (dsLogin.Tables["login"].Rows.Count > 0)
            {
                Response.Redirect("index.htm");
            }
            else
            {
                Response.Write("<script>alert('用户名或密码不正确!')</script>");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + "')</script>");
        }
        finally
        {
            conn.Close();
        }     
    }
       
}