栗色?蓝色?--TreeView的用法

The Neurotic Fishbowl

麦林发表于 2007/6/8 21:54:35

存储过程:CREATE proc YH_LeftBannerasselect [ID], MasterName from YH_Master where IfTopBanner = '0'GO create proc YH_GetChildByMaster(@masterid int )asselect ChildName from YH_Childwhere MasterID = @masteridGO 调用类: public DataSet GetLeftBanner() { Database data = new Database(); DataSet ds = null; try { data.RunProc("YH_LeftBanner", 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; } } 页面代码:public partial class TreeView : System.Web.UI.Page{ DataSet dsnode; SqlDataReader drnodesub; protected void Page_Load(object sender, EventArgs e) { getNode(); for (int i = 0; i < dsnode.Tables[0].Rows.Count; i++) { TreeNode node = new TreeNode(); node.Text = dsnode.Tables[0].Rows[i]["MasterName"].ToString(); int masterid = Convert.ToInt32(dsnode.Tables[0].Rows[i]["ID"]); Banner getnodesub = new Banner(); drnodesub = getnodesub.GetChildNameByMasterID(masterid); while (drnodesub.Read()) { TreeNode newnode = new TreeNode(); newnode.Text = drnodesub["ChildName"].ToString(); node.ChildNodes.Add(newnode); } TreeView1.Nodes.Add(node); } }}

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

发表评论：