datalist嵌套gridview 数据绑定

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 Index : System.Web.UI.Page
{
    DBBase dbbase = new DBBase();
    databindOP opr = new databindOP();  //引用操作类
    DataTable dt = new DataTable();
    string SqlText = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
             //判断用户是否登录的情况，隐藏控件
            if (Session["userName"] == null)
            {
               Response.Redirect("Login.aspx");
            }
            else
            {
                //根据权限不同  绑定datalist
                if (Convert.ToInt32(Session["power"]) == 3)
                {
                    SqlText = "select Users.ClassID,UserName,Class from Users,Class where Users.ClassID=Class.ClassID order by Users.ClassID ASC";
                    this.opr.datalistbind(SqlText, dlistSubjiect);
                }
                else
                {
                    SqlText = "select Users.ClassID,UserName,Class from Users,Class where Users.ClassID=Class.ClassID order by Users.ClassID ASC";
                    this.opr.datalistbind(SqlText, dlistSubjiect);
                }

            }

       }

 

  protected void dlistSubjiect_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        //根据权限不同  绑定gridview
       if (e.Item.ItemType == ListItemType.Item||e.Item.ItemType == ListItemType.AlternatingItem)
        {
           GridView gvSubject = (GridView)(e.Item.FindControl("gvSubject"));
           DataRowView rowv = (DataRowView)e.Item.DataItem;
           int ClassID = Convert.ToInt32(rowv["ClassID"]);
           if (Convert.ToInt32(Session["power"]) == 1||Session["power"]==null)
            {
                gvSubject.Columns[8].Visible = false;//隐藏控件
                SqlText = "select top 5 S_id ,ClassID,S_subject,UserName,repsCount,ReaderCount,up,CreateTime from Send where ClassID='" + ClassID.ToString() + "'";
                gvSubject.DataSource = dbbase.ExecuteSQLGetDataTable(SqlText);
                gvSubject.DataBind();
            }
            else if (Convert.ToInt32(Session["power"]) >= 2)
           {
                SqlText = "select top 5 S_id ,ClassID,S_subject,UserName,repsCount,ReaderCount,up,CreateTime from Send where ClassID='" + ClassID.ToString() + "'";
                this.opr.gridviewbind(SqlText, gvSubject, "S_id");
            }
        }
    }

}

转载于:https://www.cnblogs.com/JimmyCai/archive/2009/04/23/Jimmy.html