买不带鼻托的花镜:求一登陆界面程序,(C#+SQL)

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/05 09:12:15
求一登陆界面程序,(C#+SQL)及连接进入下一界面程序代码

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 _5dRss.Const;
using _5d.Library.Data;
using hjh.Encrypts;

public partial class admin_login : System.Web.UI.Page
{
private string connStr = SysConfig.ConnectionString;

protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] != null)
{
Response.Redirect("default.aspx");

}
}
/// <summary>
/// 登陆按钮操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e">句柄?</param>
protected void btnLogin_Click(object sender, EventArgs e)
{
string UserName = tbUserName.Text.Trim();
string Password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(tbPassword.Text.Trim(), "SHA1");

int IsChecked = (int)OleDbHelper.ExecuteScalar(connStr, CommandType.Text, "select count(mem_ID) from xna_Member where(mem_UserName='" + UserName + "' and mem_Password='" + Password + "')");

if (IsChecked == 1)
{
Session["UserName"] = hjhEncrypt.Encrypt(UserName, "5drss");
Session["Status"] = hjhEncrypt.Encrypt(OleDbHelper.ExecuteScalar(connStr, CommandType.Text, "select mem_status from xna_Member where mem_UserName='" + UserName + "'").ToString(), "5drss");

Response.Redirect("default.aspx");

}

if (IsChecked == 0)
{
Showmsg.Text = "<script defer>alert('登陆失败,用户名或密码错误');</script>";
tbPassword.Focus();
}
}
}

上面是我自己写的,给你参考下