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; using Microsoft.Practices.EnterpriseLibrary.Data; using Microsoft.Practices.EnterpriseLibrary.Common; using System.Data.Common; public partial class LeftMenu : System.Web.UI.Page { Database db = DatabaseFactory.CreateDatabase("sqlconstr2"); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) GVDataBind(); } private void GVDataBind() { DbCommand dcmd = db.GetSqlStringCommand("select * from dbo.[Group] where UserID=0"); DataSet ds = db.ExecuteDataSet(dcmd); this.GridView1.DataSource=ds.Tables[0]; this.GridView1.DataBind(); } private void DLDataBind(DataList dl, int GID) { string sql = "SELECT [User].*,[GroupUser].GroupID FROM [GroupUser] INNER JOIN [User] ON [User].ID=[GroupUser].UserID WHERE GroupID=" + GID + ""; DbCommand dcmd = db.GetSqlStringCommand(sql); DataSet ds = db.ExecuteDataSet(dcmd); dl.DataSource = ds.Tables[0]; dl.DataBind(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { DataList dlUser = (DataList)e.Row.FindControl("DataList1"); if (dlUser != null) { ///绑定数据 DLDataBind(dlUser, Int32.Parse(this.GridView1.DataKeys[e.Row.RowIndex].Value.ToString())); } } } <%@ Page Language="C#" AutoEventWireup="true" CodeFile="LeftMenu.aspx.cs" Inherits="LeftMenu" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>无标题页</title> <mce:style type="text/css"><!-- a{ text-decoration:none; color:black; } --></mce:style><style type="text/css" mce_bogus="1"> a{ text-decoration:none; color:black; } </style> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" DataKeyNames="ID" Width="154px" ShowHeader="False"> <Columns> <asp:TemplateField > <ItemTemplate> <div style="height: 100%; cursor:hand; background:#CCC; border-style:none" id="divfa" οnclick="chang('<%#"divson"+Eval("ID")%>');" > <%#Eval("Name")%> </div> <div style="height:100%; display:none; background:#EBEBEB; width:100%;border-style:none" id='<%#"divson"+Eval("ID")%>'> <asp:DataList ID="DataList1" runat="server" Width="100%"> <ItemTemplate> <div id="div_s" style="border-bottom:#FFF 1px solid; width:100%; cursor:hand;"> <a href="#" mce_href="#"><%#Eval("Username")%></a></div> </ItemTemplate> </asp:DataList></div> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </div> <mce:script language="javascript" type="text/javascript"><!-- function chang(div) { var divson=document.getElementById(div); if(divson.innerHTML=="") { divson.style.display="none"; } else { if(divson.style.display=="none") { divson.style.display="block"; } else { divson.style.display="none"; } } } // --></mce:script> </form> </body> </html>