I've become undone when trying to convert xml linq query result to a datagridview (see code below), needing some pointers,.
Dim doc As XDocument
doc = XDocument.Load("C: empxmltest.xml")
Dim query = From c In doc.<quotefile>.<quote> _
[code].....
some of the xelements within the query were calling for tags that didn't exist in the original xml, heres a simple example of what i mean.
element = _
<xml>
<object>
<string>someString</string>
[code]....
So how do i change the querry so that it wont produce a null error if the tags asked for are not present.
I'm working on a .NET application (VB 2008) that gets all of its data from a web-based Django application.I'm using Linq-to-XML and Linq-to-objects in the app.One API call is giving me XML data in the following format that I am loading into an XDocument.
[Code]...
I have the following piece of XML:
<xml>
<ObsCont xCampo="field1">
<xTexto>example1</xTexto>
[Code]....
How do I (using linq) get for example what is inside the xTexto tag that has as parent the ObsCont with the xCampo attribute "field2" ?
how to search XML trees with LINQ using VB.net. I've found some very helpful posts for C#, but none for VB.net?How would I use LINQ to XML to get the value from example XML Getting a set of elements using linq How to get elements value with Linq To XML I want to get the inputlocation for the process where name = "MyProcess1" Based on the example links above, I have been trying code like this:
Dim inputLocation As String = xdocument.Descendants("Configurations").Descendants("process").First(Function(c) c.Element("name").Value = "MyProcess1").Element("inputLocation").Value
But the code is not returning any values. here is the xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Configurations>
<process>
[code]....
I would like to get the first N groups elements with Linq of a ObservableCollection, an example trying to get the first 2 groups:
Data example:
GROUP1 item1
GROUP1 item2
GROUP1 item3
GROUP2 item1
[code]....
I have this XML
<?xml version="1.0" encoding="utf-8"?>
<root>
<xsd:schema id="root" xmlns="" xmlns:xsd="[URL]" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xsd:import namespace="[URL]" />
<xsd:element name="root" msdata:IsDataSet="true">
[Code] .....
And I also have this method, where I take two files and take some values from them, and then I merge all the values into an object in the second query:
Public Shared Function RetrieveTranslation(ByVal filefrom As String, ByVal fileto As String) As List(Of clsTranslation)
Dim valuefrom = (From l In XElement.Load(fileto).Elements("data") Select l.Element("value").Value).FirstOrDefault
[Code] .....
So, the problem is that when I run the code, there is an "Sequence contains no elements" error in the first query(valuefrom). I debugged and it says that there is nothing in the query, but I don't understand why? I'm curious to know if it is well done to do something like I did, create an object from two queries, putting the first value in the second query.
I'm having trouble adding child elements to the below
<securities>
<security id="040104JC6">
[code]....
I'm really struggling with this. I have two XML files. The first one has items, and then sub elements for properties:
[Code]...
Is there any way to use a LINQ to XML to query an XML document like the one below to create new (anonymous or strongly typed) objects from the child elements of a descendant? Here is my XML document:
[Code]...
I have the following XML which I load via XDocument.Load(uri) or XElement.Load(uri). I am having trouble getting a collection of <asset> elements via LINQ.
Here is a snippet of the XML I'm trying to query:
<assetCollection xmlns="tag:aisle7.net,2009:/api/1.0">
<title>All Assets</title>
<description>Collection containing all assets in the system</description>
<resourcePath>/us/assets/~all</resourcePath>
[Code] .....
I have got an xml document which looks something like this.
<Root>
<Info>
</Info>
<Info>
[Code]...
How can i write a linqToXML query so that it returns me an IEnumerable containing each child element, in this case all five child elements of , so that i could iterate over them. The order of child elements is not definite, neither is number of times the may appear.
vb
Dim CheckedRows = From dgv As DataGridViewRow In Me.DataGridView4.Rows _
Where dgv.Cells(0).Value = True _
Select New With {.a = dgv.Cells(1).Value, .b = dgv.Cells(2).Value}
my code above works fine but how to get the index of the row on which the checkbox is checked
I'm using a DataGridView to post the results of LINQ-from-SQL query. I was hoping that the data would be editable in the DataGridView, but it isn't. I made sure that DataGridView.readonly = false. I'm using VB.
VB 2008
DB = New CXToolDataContext()
Dim Systems = (From TBLSYSTEMS In DB.tblSystems, TBLSYSTYPES In DB.tblSystemTypes _
Where TBLSYSTEMS.ProjectName = projectnumber And TBLSYSTEMS.SystemType =
[Code]...
I created a method and pass the element type, id, and any inner text that instantiates a new html element. The last statement: Me.Controls.Add(element) adds it to the end of the page, but I would like it to be inserted in a specific position (between 2 divs within a form). What I am describing is very similar to this post on SO here, although it was for javascript.
View 1 RepliesThere are 6 buttons have the same name in page i wantto click 3th button this code works:
WebBrowser1.Document.All.GetElementsByName("bid").Item(2).InvokeMember("click")
but this doesnt work :
WebBrowser1.Document.All.GetElementsByName("bid").Item(TextBox1.text).InvokeMember("click")
it gives error while debugging
How can I do it without using WebBrowser and get it to an array of HtmlElement?
View 7 RepliesI have an xml document and I want to read the elements from it.Here is what I have:
<my:assetTracking xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-10-21T21:12:27" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003">
<my:employee>
<my:employeeName></my:employeeName>
[Code]...
I have some combo boxes on a form and I want to add some elements into them . Practically I have to add "1" , "2" ..... "100" .
I can use this code :
ComboBoxMY.Items.Add("1")
ComboBoxMY.Items.Add("2")
...
ComboBoxMY.Items.Add("100")
but this will take too many lines . Of course I can accept that , but I just wonder if I could write them with less code .
Dim Document = XDocument.Load(FileName)
Dim findElement = Document.Elements("GradeProfile")
[code]....
I have the following code in my application which gets the attributes "name" and "id" of all the html elements on a web page.
[Code]....
What I would like to do is place the returned results into a 2 column listview control with the name attribute in the first column and the id attribute in the second column. After searching the internet the only good example I could find is on the msdn pages but this only shows how to add a known set of items so I could not figure out how to convert this to work with variables.
I'm trying to create a treeview in a VB 2008 project that shows all the elements and attributes of an XML Schema.The MSDN documentation for XML schemas seems to imply that by loading the schema into an XMLSchemaSet and compiling it I should get access to all the elements and attributes with their values but this doesn't seem to work in practice.
Using a for loop such as:For Each elem As XmlSchemaElement In compiledSchema.Elements.Values
I can use elem.Name to get the element name (and attribute name with a similar nested loop) for a simple type but this doesn't work for a complex type.Whenever (and however) I try to get values for complex types I hit a brick wall.
[Code]...
i am trying to read a csv file and then query it using linq and thereafter bind the query result to a datagridview. similiar code works fine when querying a database but not when using the csv file. the file import works fine but the result on the datagridview is the lenght of the strings of each year, nav and return. how do i get the real values and not the information of the lenght of the values.
[Code]...
I have a string of bytes which I am reading from a microcontroller via a serial port which is as follows : 02 10 18 14 CB 73 43 D3 14 00 0D 00 09 00 1B 00 04 B8 3C 00 00 24 00 30 AB
I would like to write some code to place each the bytes into an array with each element of the array consisting of one byte each.
I just upgraded a project from VB 2008 to VB 2010. Before, the project did not use LINQ. I have started implementing it. So, I have updated the target framework from 2.0 to 3.5, and added a reference to System.Core, and imported the namespace System.LINQ to the entire project and also imported System.Data.LINQ into the form I'm working with (because it was not available in the list for Imported Namespaces in the references tab).
It's not throwing any errors now, but my IntelliSense is not working for LINQ stuff.
For example... I write this:
[CODE]....................
Then, if I type S. on the next line, the IntelliSense doesn't grab what it should for S (Only get Equals, GetHashCode, GetType, ReferenceEquals, and ToString, instead of the options I should get like Count, First, FirstOrDefault, etc...). If I Type S.First. then its the same thing, no IntelliSense that lists the available fields for S, just the standard options (Equals, GetHashCode, GetType, ReferenceEquals, and ToString). I should be seeing my column names in my table when I type S.FirstOrDefault.
So any ideas what is going on? When I type the code, for example, MessageBox.Show(S.FirstOrDefault.FirstName), it works perfectly. But it doesn't change the casing of the text (so it would read s.firstordefault.firstname) and no intellisense while doing it. But no errors. BTW - Everything works perfectly when creating a NEW VS 2010 application, it's just my projects upgraded from Visual Basic 2008 that have this issue.
I want to know how to delete record (row) in transaction.this is details :
label for show productID
textbox for insert product name
datagridview for show data
insert button
delete button
edit button
[Code]...
I want to make an application that takes values & innerhtml from some elements on a webpage i made. For that i added a webbrowser to the project, and pointed it to navigate to my localhost server where i have some pages. However when i use the document.getelementbyid i don't get nothing on my richtextbox, and i don't know why, i use this function lot in javascript & i think its quite similar, so i don't know why it doesn't work , here is the code i use.
[Code]...
I would like to group the elements in the Solution Explorer (Forms , Modules etc) .Is this possible in the VB .NET Editor ?
View 5 RepliesI have a function which does some processing. Lets name that function DoWork. This function takes some inputs as structure and a string. Now I want to start two threads which would read some elements in an array and then call DoWork with some data and value of that element. DoWork would do processing and thats it. I want two threads to run side by sid.
So I tried to write code but kinda failed. I wrote a function which starts a thread and calls DoWork. Now DoWork accepts structure and string etc. But when we do say abcthread = new threadig.thread(addressof <sub name>). here we cant pass any-value except object. That was first problem.
Anyway, main problem is after the thread has finished processing DoWork, how do I find that out and tell that thread to take another element from array and start again. This has to be managed for both the threads. I need to find out which thread has finished first and tell it to start again with another value. I have usually used one thread but not two in this way.
I have a VB.NET search routine, part of which is provided, below, that checks all Text cells in a DataGridView for a given string (inclusive), using a basic set of nested loops to perform the search:
' Search for the first occurrence of the given string
For Each row As DataGridViewRow In dgvMembers.Rows
' Skip the new row
[Code].....
is there a way to replicate this behavior using LINQ? Basically I would like the query to select (or return) the first DataGridViewCell whose text contains the search string. I've done some tinkering with sub-queries and the like, but I'm still having trouble wrapping my brain around the concepts (too many years of writing T-SQL, I guess).