问题描述
asp.net中如何用Treeview绑定数据库中的数据如下例子怎么实现挖掘机//根节点卡特://节点(345330325320320DL320C320B200312307305.5)//包函的子节点小松:(3603002702202102001301206055)沃尔沃:(46036029024021014055)神刚:(36030024021020013060)每个挖掘机品牌下面对应这么多的型号,要动态的从数据库从读出来要每个挖掘机品牌对应不同的型号可以对这些挖掘机品牌和型号进行增,删,改操作这个功能怎么实现,请大家帮帮忙,,急!!谢谢
解决方案
解决方案二:
创建树(){创建节点(,0)}创建节点(,级别){创建节点;创建节点(,级别)//递规调用}
解决方案三:
/递规函数PublicSubsang_ProTree(ByValsTreeVAsTreeView,ByValsPKeyAsTreeNode,_ByValsKeyAsString,ByValsTextAsString,ByValsUserAsString,ByValstrAsString)'生成树结构'树,父节点,自己,文字,用户,查询结果集DimsChildNAsLongDimsRsqlAsStringDimtnAsNewTreeNodeIfsPKeyIsNothingThentn.Text=sTexttn.ImageUrl="imagestree_2.gif"Ifstr<>""Thentn.NavigateUrl=str'"tyquery.aspx?luN='"&sKey&"'"EndIftn.ID=sKeytn.Target="right"sTreeV.Nodes.Add(tn)Elsetn.Text=sTexttn.ImageUrl="imagestree_3.gif"Ifstr<>""Thentn.NavigateUrl=str'"tyquery.aspx?luN='"&sKey&"'"EndIftn.ID=sKeytn.Target="right"sPKey.Nodes.Add(tn)EndIf'再准备处理孩子IfInStr(sKey,"lu")<>0ThensRsql="select*from"&Owner&"LK_TREE_TABwherePAR_K='"&sKey&_"'AndUSER_Nlike'%"&sUser&"%'andITEM_N='物资管理'orderbyto_number(substr(owe_k,3))"'orderbyITEM_NASC"ElsesRsql="select*from"&Owner&"LK_TREE_TABwherePAR_KISNullAndUSER_Nlike'%"&sUser&"%'andITEM_N='物资管理'orderbyto_number(substr(owe_k,3))"'orderbyITEM_NASC"EndIfDimoledbcnAsNewOleDb.OleDbConnection(Global.con)DimoledbcmdAsNewOleDb.OleDbCommand(sRsql)DimoledbdrAsOleDb.OleDbDataReaderoledbcmd.Connection=oledbcnIfoledbcmd.Connection.State=ConnectionState.ClosedThenoledbcmd.Connection.Open()EndIfoledbdr=oledbcmd.ExecuteReader(CommandBehavior.Default)Whileoledbdr.Read()'处理孩子IfNotIsDBNull(oledbdr("FILE_P"))ThenCallsang_ProTree(sTreeV,tn,oledbdr("OWE_K"),oledbdr("QUE_N"),sUser,oledbdr("FILE_P"))ElseCallsang_ProTree(sTreeV,tn,oledbdr("OWE_K"),oledbdr("QUE_N"),sUser,"")EndIfEndWhileoledbdr.Close()oledbcn.Close()EndSub别人的一个函数