Posts made by ErikKoz

ErikKoz

Im looking to display xml values via a datagrid. And so far Ive had luck with everything, except nested values.

<?xml version="1.0" encoding="UTF-8"?>
<Collection>
<Content>
<ID>16938</ID>
<Type>Content</Type>
<Title>Smartform2</Title>
<QuickLink>/it.aspx?id=16938</QuickLink>
<Teaser>
<p>SmartForm1Smartform2Smartform3Smartform4</p>
</Teaser>
<Html>
<root>
<Field1>
<Field2>
<Test1>SmartForm1</Test1>
<Test2>Smartform2</Test2>
</Field2>
<Field2>
<Test1>Smartform3</Test1>
<Test2>Smartform4</Test2>
</Field2>
</Field1>
</root>
</Html>
<StartDate>1/1/0001 12:00:00 AM</StartDate>
<DateModified>5/28/2009 3:02:59 PM</DateModified>
<DateCreated>5/28/2009 3:02:49 PM</DateCreated>
<EndDate>12/31/9999 11:59:59 PM</EndDate>
<LastEditorFname>Erik</LastEditorFname>
<LastEditorLname>Kozlowski</LastEditorLname>
<Hyperlink>
<a href="/it.aspx?id=16938">Smartform2</a>
</Hyperlink>
<DisplayStartDate/>
<FolderID>2594</FolderID>
<ContentStatus>A</ContentStatus>
<Language>1033</Language>
<DisplayDateModified>5/28/2009</DisplayDateModified>
<DisplayDateCreated>5/28/2009</DisplayDateCreated>
<DisplayEndDate/>
<EndDateAction>Archive_Expire</EndDateAction>
<Comment/>
<Image>/WorkArea/images/application/spacer.gif</Image>
<ImageThumbnail>/WorkArea/images/application/thumb_spacer.png</ImageThumbnail>
<FilePath>/it.aspx?id=16938</FilePath>
</Content>
<Content>
<ID>16936</ID>
<Type>Content</Type>
<Title>Test smartform 1</Title>
<QuickLink>/it.aspx?id=16936</QuickLink>
<Teaser>
<p>Smart1Smart2Smart3Smart4</p>
</Teaser>
<Html>
<root>
<Field1>
<Field2>
<Test1>Smart1</Test1>
<Test2>Smart2</Test2>
</Field2>
<Field2>
<Test1>Smart3</Test1>
<Test2>Smart4</Test2>
</Field2>
</Field1>
</root>
&

ErikKoz

This is probably more of a beginner issue, but Im trying to populate a treeview based off the Northwind Database. The Top level is a list of countries, second level is a list of customers from that country, and 3rd level is supposed to be orderids from that country but it isnt populating. I know its stopping at my 'FillOrderIDs' but I cant seem to figure out why. I appreciate any advice,

Private Sub FillCountries()
    Dim tcountry As String
    Dim tnode As TreeNode
    Dim tCountryTable As NorthwindDataSet.CountriesDataTable
    tCountryTable = Me.CountriesTableAdapter.GetCountriesData
    For Each trow As NorthwindDataSet.CountriesRow In tCountryTable

        tcountry = trow.Country
        tnode = New TreeNode
        tnode.Name = "Country"
        tnode.Text = tcountry
        Me.TreeView1.TopNode.Nodes.Add(tnode)
        FillCompanyNames(tcountry, tnode)
    Next
End Sub

Private Sub FillCompanyNames(ByVal country As String, ByVal parentnode As TreeNode)
    Dim tCompany As String
    Dim tnode As TreeNode
    Dim CustTable As NorthwindDataSet.CompanyNamesDataTable
    CustTable = Me.CompanyNamesTableAdapter.GetCustomersByCountry(country)

    For Each trow As NorthwindDataSet.CompanyNamesRow In CustTable
        tCompany = trow.CompanyName
        tnode = New TreeNode
        tnode.Name = "CompanyName"
        tnode.Text = trow.CompanyName
        tnode.Tag = trow.CompanyName
        parentnode.Nodes.Add(tnode)
        FillOrderIDs(tCompany, tnode)
    Next

End Sub

Private Sub FillOrderIDs(ByVal orderid As String, ByVal parentnode As TreeNode)
    Dim tnode As TreeNode
    Dim OrdTable As NorthwindDataSet.OrderIdsDataTable
    OrdTable = Me.OrderIdsTableAdapter.GetOrderIds(CompanyName)

    For Each trow As NorthwindDataSet.OrderIdsRow In OrdTable
        tnode = New TreeNode
        tnode.Name = "OrderID"
        tnode.Text = trow.OrderID
        tnode.Tag = trow.OrderID
        parentnode.Nodes.Add(tnode)
    Next
End Sub

Private Sub btnDisplay\_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
    TreeView1.Nodes.Add("Countries")
    FillCountries()
End Sub