• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Help with loopingf through GridView and retreiving IDs from xml file or creating new IDs if data does not exist

Hi,

I am using the code below to loop through a listbox to  retreive existing ID(Part A) or create new IDs (Part B).

How do I modify it for a GridView (Windows App, VS 2010)


For x As Integer = 0 To C1NSN.Items.Count - 1

'PartA:
                If CheckForNSNFix.Contains(C1NSN.Items(x).ToString) Then
                    For Each xnLink As Xml.XmlNode In xdNSN.SelectNodes("/Root/NSNTable[NSN='" & C1NSN.Items(x).ToString & "']")
                        NSN_ID = xnLink.SelectSingleNode("NSN_ID").InnerText
                        If NSN_ID <> "" Then
                            CD = NSN_ID
                            If u > 0 Then
                                num1 = num1 & "" & CD & ","
                            Else
                                num1 = CD & ","
                            End If
                            u = u + 1
                        End If
                    Next
                End If
            Next



'Part B:
            'Assign ID to data not already in XML file
            For x As Integer = 0 To C1NSN.Items.Count - 1
                If Not CheckForNSNFix.Contains(C1NSN.Items(x).ToString) Then
                    Dim xNew As XElement = New XElement(xtable)
                    xNew.Add(New XElement(xid, num))
                    xNew.Add(New XElement(curXYZ, C1NSN.Items(x)))
                    MyFix.Root.Add(xNew)
                    MyFix.Save((Application.StartupPath + "\App_Data\" & curXYZ & ".xml"))
                    If uu > 0 Then
                        num2 += num & ","
                    Else
                        num2 = num & ","
                    End If
                    uu = uu + 1
                    num = num + 1
                End If

            Next
            searchIdNSN = num1 & num2
0
vcharles
Asked:
vcharles
  • 2
1 Solution
 
Meir RivkinFull stack Software EngineerCommented:
Assuming C1NSN is your gridview, simply replace C1NSN.Items with C1NSN.Rows
0
 
Meir RivkinFull stack Software EngineerCommented:
Btw, i assumed that your id is in 1st column, otherwise u need to specify the column as well:
So instead of C1NSN.Items(x).ToString)
Use this:
C1NSN.Items(x)(column-index).ToString()

Or by column name:
C1NSN.Items(x)("Column-name").ToString()
0
 
vcharlesAuthor Commented:
Thank You!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now