栗色?蓝色?--menu的实例用法

The Neurotic Fishbowl

麦林发表于 2007/6/8 21:45:11

存储过程:CREATE proc YH_TopBannerasselect [ID], MasterName from YH_Master where IfTopBanner = '1'GO create proc YH_GetChildByMaster(@masterid int )asselect ChildName from YH_Childwhere MasterID = @masteridGO 调用类:public class Banner{ public DataSet GetTopBanner() { Database data = new Database(); DataSet ds = null; try { data.RunProc("YH_TopBanner", out ds); return ds; } catch (Exception ex) { Error.Log(ex.ToString()); return null; } } public SqlDataReader GetChildNameByMasterID(int ID) { Database data = new Database(); SqlDataReader dataReader = null; try { SqlParameter[] prams = { data.MakeInParam("@masterid", SqlDbType.Int, 4, ID) }; data.RunProc("YH_GetChildByMaster", prams, out dataReader); return dataReader; } catch (Exception ex) { Error.Log(ex.ToString()); return null; } } 页面源代码:<%@ Control Language="C#" AutoEventWireup="true" CodeFile="topbanner.ascx.cs" Inherits="Inc_topbanner" %><asp:Menu ID="Menu1" runat="server" Orientation="Horizontal" EnableViewState="False"DisappearAfter="400" StaticSubMenuIndent=""> <StaticItemTemplate> <%# Eval("Text") %> </StaticItemTemplate> <DynamicItemTemplate> <%# Eval("Text") %> </DynamicItemTemplate></asp:Menu> 页面实现代码:public partial class Inc_topbanner : System.Web.UI.UserControl{ DataSet ds; SqlDataReader drSub; protected void Page_Load(object sender, EventArgs e) { this.GetMasterName(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { MenuItem item = new MenuItem(); item.Text = ds.Tables[0].Rows[i]["MasterName"].ToString(); int masterid = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]); Banner GetChildName = new Banner(); drSub = GetChildName.GetChildNameByMasterID(masterid); while (drSub.Read()) { MenuItem subitem = new MenuItem(); subitem.Text = drSub["ChildName"].ToString(); item.ChildItems.Add(subitem); } Menu1.Items.Add(item); } } public void GetMasterName() { Banner GetMasName = new Banner(); ds = GetMasName.GetTopBanner(); }}

阅读全文(2480) | 回复(0) | 编辑 | 精华

发表评论：