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
So instead of C1NSN.Items(x).ToString)
Use this:
C1NSN.Items(x)(column-inde
Or by column name:
C1NSN.Items(x)("Column-nam