Here is some code I used to fill in a treeview control. I determined child/parent relationships by a returned field from the database.
Here are some sample recordsets. The TreeNodes table is the same structure.
CategoryID
CategoryName
CategoryTO
ASD.AMAS
Category Title
ASD
ASD.AMAS.NS
Category Title 1.1
ASD.AMAS
ASD.AMAS.NS.AS
Category Title 1.1.1
ASD.AMAS.NS
ASD.AMAS.NS.AUC
Category Title 1.1.1
ASD.AMAS.NS
ASD.AMAS.TDA
Category Title 1.2
ASD.AMAS
ASD.AMAS.TDA.TA
Category Title 1.2.1
ASD.AMAS.TDA
ASD.AMAS.TDA.TD
Category Title 1.2.2
ASD.AMAS.TDA
ASD.APS
Category Title 2
ASD
ASD.APS.C
Category Title 2.1
ASD.APS
ASD.APS.DM
Category Title 2.2
ASD.APS
ASD.APS.DM.A10
Category Title 2.2.1
ASD.APS.DM
ASD.APS.DM.C2
Category Title 2.2.2
ASD.APS.DM
ASD.APS.DM.E2C
Category Title 2.2.3
ASD.APS.DM
The Code
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=MyDB"
set RS = Conn.execute("{call qryTreeNodesAll}")
if RS.EOF then
response.write "TreeView1.Nodes.Add ,,,""No Records"""
else
do while NOT RS.EOF
s = RS(2)
count = 0
pos = 1
lookfor = "."
Do While True
pos = InStr(pos, s, lookfor)
If pos > 0 Then
count = count + 1
pos = pos + 1
Else
Exit Do
End If
Loop
select case count
case 0
response.write "TreeView1.Nodes.Add ,,"""&RS(0)&""","""&RS(1)&"""" & vbCrLf
case else
response.write "TreeView1.Nodes.Add """&RS(2)&""",4,"""&RS(0)&""","""&RS(1)&"""" & vbCrLf
end select
RS.Movenext
loop
end if
This 15 Seconds' issue contains source code and step by step instructions for creating a chat session using Active Server pages, HTML and a standard web browser. Also demonstrated is writing and reading of a file with an Active Server page. [Read This Article][Top]
This issue describes how to make a list server using Active Server, SQL Server, and Stephen Genusa's ASPMail Component. Included are source and instructions for adding the user to the list from a Active Server page, removing the user from the list via a Active Server page, and sending mail to the whole list. [Read This Article][Top]
A rewrite of part one of a four-part series on Active Server objects. A simple example of creating a Active Server Component in Visual Studio 5.0 using the Active Template Library 2.0. The example component retrieves the user's cookie, if not available issues a new 128-bit cookie. Included in the issue is the source code and step by step instructions. This issue has been rewritten to illustrate the use of Visual Studio 5.0 and ATL 2.0 in writing Active Server Components. [Read This Article][Top]
In this issue 15 Seconds implements a catalog site that is build with Active Server pages and SQL Server. Along with the implementation there is source code and a discussion of the advantages and disadvantages of creating a catalog site that gets its content from a database. Included are pages for displaying products, creating a menu page, category page, and running a search across a database. [Read This Article][Top]
A complete discussion of the Last Modified header and the Expires header including the effect they have on Active Server page and various browsers. [Read This Article][Top]
