addrcard.aspx.cs

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

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;

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

        if (Session["UserID"] == null)
            Response.Redirect("index.aspx");


        if (!this.Page.IsPostBack)
        {
            bindlist();

        }
    }
    private void bindlist()
    {
        string cmd = "  SELECT UserInfo.UserID, UserInfo.Email, UserInfo.Tele, UserInfo.MobilePh, UserInfo.PicName, UserInfo.QQ, UserInfo.StudentID, StudentInfo.Name, UserInfo.Address, UserInfo.Remark, UserInfo.Province, UserInfo.City FROM UserInfo INNER JOIN StudentInfo ON UserInfo.StudentID = StudentInfo.StudentID WHERE (UserInfo.UserID IN (SELECT UserID FROM UserToClass WHERE ( ClassName = '" + Session["classname"] .ToString().Trim()+ "')))"; //设置SQL命令

        this.SqlDataSource1.SelectCommand = cmd;
        this.SqlDataSource1.DataBind();   //将SqlDataSource重新绑定
        this.DataList1.DataBind();             //对GridView进行绑定


    }
   
}