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");
}
}
}
}
--------------------------------------------------------------------------
今天,明天就在此刻!此刻奋斗,今天耕耘,明天收获,明天辉煌!此刻放弃, 今天无为,明天饥饿,明天黯淡!
JimmyCai