login.aspx.cs

校友录的总体功能分为三个子功能模块:管理功能模块,用户注册功能模块,用户个性化服务

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Log_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

        string cmd = "select * from UserInfo where UserID='" + UserID.Text.ToString() + "' and PWD = '" + Pwd.Text.ToString() + "' "; //设置SQL命令
        conn.Open();
        SqlCommand myCommand = new SqlCommand(cmd, conn);
        SqlDataReader jie = myCommand.ExecuteReader();
        if (jie.Read())
        {
            //保存用户  
            Session["StudetnID"] = jie["StudetnID"];
          
            Session["UserID"] = jie["UserID"];
            Session["Email"] = jie["Email"];
            Response.Redirect("main.aspx");

        }
        else
        {
            Session["UserID"] = null;
            MsgText.Visible = true;
            MsgText.Text = "用户名或密码出错！！";

          
        }


        conn.Close();
    }
}