I have the following XML from Amazon's Marketplace API. I need to sum all the values of Item/ItemPrice/Component[type='Principal']/Amount for all Items to compute an order total. Is this possible to do using LINQ to XML in VB.NET?
<?xml version="1.0"?>
<AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="amzn-envelope.xsd">
<Header>
<DocumentVersion>1.01</DocumentVersion>
[code]....
Is the following possible in one XPath expression (see sample below) Select all (span tags of class msg) AND all ((img tags that have a non-empty alt attribute) AND (are NOT located inside a span tag of class msg))
[Code]...
I am new in LINQ world.I need an urgent help in reading the xml elements using LINQ with specific where condition.I need to find the max air_temp for a county i.e where county name = "Boone" and hour id = "06/03/2009 09:00CDT".[code]
View 3 RepliesIf a node belongs to a namespace, it's children by default belong to the same namespace. So there's no need to provide an xmlns attribute on each child, which is good. However. If I create two nodes like this:
[Code]...
Trying to figure out XPath and I have successfully create an XPathExpression that lets me grab the events, but any nested sub groups seem to be unavailable to the query, I can get all the children on the Events group, but the LocationName field I can not access.[code]...
View 1 RepliesGiven the xml below why does the first selectsinglenode call not work but the second one does? Are the single quotes specifying a string type or something?
Dim dbglvlnode As Xml.XmlNode = doc.SelectSingleNode(String.Format("Config/Scanner[DeviceID = '{0}']/DebugLevel", XMLstuff.DeviceID))
Dim dbglvlnode As Xml.XmlNode = doc.SelectSingleNode(String.Format("Config/Scanner[DeviceID = {0}]/DebugLevel", XMLstuff.DeviceID))
<?xml version="1.0" standalone="yes"?>
[Code] ......
The xml document is like so: ... I would like to use XPath to Navigate but I am not sure where to get started. Can anyone point me to some examples of traversing the nodes? I have the first part figured out but not sure how to iterate through all l1,l2,l3,l1 nodes...
[Code]...
I'm all new to this treeview business. I have a fixed treeview, very simple and basic. Only two levels, parent and child nodes. I just need two things out of this treeview.
1) If parent is checked, check all child nodes.
2) If just one child node is unchecked, uncheck parent node.
That's it! I've been looking for this for 30 mins and I cant find it. Maybe because my vb.net is old, it doesnt seem to be the same as others =/ I'm using vb.net 2003.
I have a problem with my treeview. I have two child nodes with different parents which contains a literal (*x). In this case (*1) (view image)
[Code]...
I am trying to identify duplicate serial numbers from the following xml using XPath 1.0 and then evaluating it in .Net using an XPathNavigator.
<?xml version="1.0" encoding="utf-16"?>
<Inventory xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Items>
[code]....
I tried to do this by evaluating this
//Items/Item/SerialNumber
expression in a custom XSLT Context Function (implementing IXsltContextFunction like this MSDN example) in .Net but the Invoke function gets called one result at a time so I have no visibility of the other results to find duplicates.
1) Is there a way of doing this using a single XPath 1.0 expression?
2) Is there a way of passing in an array of elements into a single Invoke call of the custom XSLT Context Function class? I'm working in VB.Net but am happy with any C# examples anyone can share.
OK, so I have the code to add a Child Node to a selected node in ta TreeView. The thing is, even if I select a child node to "add" to, it adds the new node to the parent of the selected child node.
I know why it does that: TreeView1.Nodes(TreeView1.SelectedNode.Index).Nodes.Add() adds to the first node. So how do I progamatically add to the child node I have selected, not it's parent node. I can't figure out the logic on how to accomplish this.
NOTE: There can be an infinite amount of child nodes.
UPDATE: I just found out that if I have a child node selected, TreeView1.SelectedNode.Index returns -1 since there is nothing selected in that first level. I'd have to use TreeView1.Nodes(0).SelectedNode.Index to get the proper index for the ChildNode. *sigh*
How to check child nodes tag.
MessageBox.Show(TreeView1.SelectedNodeChild.Tag)
Is it possible to have more than one level of child nodes in a treeview? fore example can i have:
node1
-node2
--node3
---node4
right now it only lets me have
node1
-node2
node3
-node4
and also if it is possible how would i enable it?
I want to make a treeview from a Listbox.The Listbox contains N number of items.Suppose the List contains:Node1Node2Node3Node4Node5I want this to appear as shown below:
[Code]...
I have the following code which checks for the value of the 'cc_supplier_status' column for each of the rows in my table. If the state is 0, I need a child node to be added to a node named 'Inactive Suppliers' in my tree view (tvw_Supplier) with it's text being the value of the 'cc_ supplier_ name' value for the same row.If the state is 1, a child node is to be added to a node named 'Active Suppliers'.If the state is 2, a child node is to be added to a node named 'Pending Suppliers'.The code I have now just filters out the status value for each row, and performs a select case on it. I need to know how I'd add a new child node to the parent nodes mentioned above.[code]
View 2 Repliesi have a treeview control which i have popuplated with parent and child nodes.What i want to do now is to be able to delete the child nodes if i wish and then the parent nodes.But rigth now i am able to delete the parent node on via the index of the node but with the child nodes it has keys which is the same as its parents node so i can not delete the child node as i will.I am using this code to delete the parent node
[Code]...
I have an xml document similar to the what's below.I'm wondering how I can read the document and all of its child nodes.I want to only read the parent node called MYTYPES and disregard MYGRAPH. The code I am using reads the document but only prints out the parent node (Type1 and Type 2, in this example).How do i get all the child nodes, and their children. For example, i would like to print out:
Type 1: Clarion, 10. Pittsburgh, 20
Type 2: Trention, 10. Harrisburgh, 20
Try[code]....
I have the following code for a treeview, It only shows a +sign against some folders, mostly system folders but not others, a mod to this code to show all childs, irrespective of how many levels the child folders exist?
Dim basenode As System.Windows.Forms.TreeNode
If IO.Directory.Exists(path) Then
If path.Length <= 3 Then
[code]....
I have a bunch of XML's that need to be put into an SQL database. One XML represents all orders for a certain department of a store. The problem (for me) is that in one XML there can be (and are) multiple orders (called distributions in my case.) The XML looks as follows (truncated):
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<order><process_id>322867</process_id>
<key1>RET</key1>
<key2>40_134985</key2>
[code]....
So in this example I have two 'distributions'. Now I can get all data out of the XML fine, which I do like this:
get xml data
awsFeed = XDocument.Load(fileName)
Dim orders = From order In awsFeed...<order> _
[code]....
However, in this case my SQL input would have to result in 2 entries, because there are 2 orders. Both entries would have the same data, except for different entries. I know how to post to SQL, that's not the problem. My real problem is, how do I 'loop' it through the XML. I think i'm looking for something like:For each 'distribution' in orders -> put into array.Or something like that. After that I could query the array and put it in the database.
I have a treeview, a button and a textbox. When you click button1 a folderbrowserdialog opens and after choosing the folder the path to the folder and anything in it is show in the textbox and with this
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sDirs() As String
[Code]....
adapted from Major treeview/list view head ache I managed to make the treeview display the folder and the sub folders... but it isn't very hierarchial. Check attached pictures. Image1 shows how it is and image2 shows how I want it to be. Can anyone tell me how to get it to look like image 2?...Image2 was made in Windows Explorer. Image1 is a screenshot of the runing program that I am trying to make. I have been googling around but no luck so far. Practically I think what I shoul be asking is how to create child nodes of subfolders. The program is going to copy whatever the user checks in the treeview into another folder chosen by the user. I am using Visual Basic 2008 Express.
I have an XML file and I have a function to which this XML is passed as string. I have loaded this string in Xmldocument and I need to insert few children nodes under one node. This function returns the modified XML string. I want that whenever this function is called, new child nodes are added, currently, It adds child nodes once.Do I need to overwrite the XML file ? If so, How can I replace the node with new node ( with new child nodes added) so that It has child nodes added before the function is called again ?
My code looks something like this:
Dim doc As New XmlDocument
doc.LoadXml(applicationXml)
Dim parentNode As XmlNode = doc.GetElementsByTagName("prList").Item(0)
[code]....
I have an xml file with following structure:
<table name="tblcats">
<row>
<Id>3680</Id>
<Industry>Associations</Industry>
[code]....
I want to create a treeview using this XML file. I have written following code
' Load a TreeView control from an XML file.
Private Sub LoadTreeViewFromXmlFile(ByVal file_name As String, ByVal trv As TreeView)
' Load the XML document.
[code]....
where as I want table as parent element like this
->table
->Associations
->Fortune 100
so that If i click table node, all tree collapses or expands.
Most of my treelist code is working ok, however I would like to produce two arrays of string, one which contains all the parent nodes in a Treeview, and the other with all the child nodes. I'm obviously doing something stupid as I have "Object reference not set to an instance of an object." I'm not declaring something.
This is my attempt:
Private Sub listbuilder(ByVal nodelist As TreeView)
Dim parentlist() As String
Dim childlist() As String
Dim j, n As Integer
[Code] .....
I have a treeview that gets populated from a MySQL database
i want to find out how to go thru each item on the tree and delete any duplicates
i want to use a tree view to select different from in an application but i can get the appropriate event to work with all i get is the entire tree view event but what i want is to be able to click on a child node inside a parent so that upon clicking the child node something will happen.
View 1 RepliesI'm new to this Visual Basic stuff. I have TreeView under the name of TreeView1 and it has two Parent nodes, one is Library and the other is Store. Under Library and Store I have childnodes and thats were I'm stuck. For example under Store there is Downloads and Apptrackr.
What I want is when a user clicks on Apptrackr it runs this piece of code
WebBrowser1.Visible = true
DownloadsBrowser.Visible = false
And when the user clicks on Downloads it then does the opposite
WebBrowser1.Visible = false
DownloadsBrowser.Visible = true
I need to find all the child nodes of a particular node in Infragistics tree view(WebNavigator). it is possible to get the parent() using the available property. But I need the childs. How can i access the childs of that particular node. I am using asp.net 2.0 with VB.Net. T
View 1 RepliesI am trying to create a treeview that looks something like the following:[code]I am using vb.net in Visual Studio 2008.
View 1 RepliesI'm trying to get my program to append a child to one of my parent nodes in an XML file. I have looked online for quite some time trying to determine the best way possible, and have come up with the following
[Code]...
I have to get all the Entity Source,Entity Target,Property Source and Property Target values in list respectively.[code]...
View 1 Replies