main.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 index2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //           GHOST-2213991D9
        if (Session["UserID"]==null)

            Response.Redirect("index.aspx");
        
       // Session["StudentID"] = "04157008";
        this.NameText.Attributes.Add("onkeydown", "if(event.keyCode==13){   event.keyCode=9;   document.getElementById('SerchBtn').click();}");  
     

    }
    protected void SerchBtn_Click(object sender, EventArgs e)
    {
        Session["Serchname"] = this.NameText.Text;
        Response.Redirect("serch.aspx");

    }
    public ArrayList GetClass(object source)
    {


        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        conn.Open(); //打开数据库连接
        
        DataSet ds = new DataSet();
        SqlDataAdapter command = new SqlDataAdapter("", conn);


        command.SelectCommand.CommandText = "select ClassName from UserToClass where UserID='" + source.ToString() + "'";
        command.Fill(ds, "table1");
        conn.Close();

        ArrayList ClassList = new ArrayList();
        ClassList.Add("班级成员");
        for (int i = 0; i < ds.Tables["table1"].Rows.Count; i++)
        {

            ClassList.Add(ds.Tables["table1"].Rows[i][0].ToString());
             

        }





       
        return ClassList;

    }
    protected void regbtn_Click(object sender, EventArgs e)
    {
        Response.Redirect("Regclass.aspx");
    }
}