VS 2010 LINQ Sub-elements And Joining
Mar 30, 2012I'm really struggling with this. I have two XML files. The first one has items, and then sub elements for properties:
[Code]...
ADVERTISEMENT
.NET LINQ Group Joining?
Dec 2, 2010I have a list of object with 3 properties (quantity, service, name)I want to have all names and services in my list (kinda cross join) and the grouped quantity of the row corresponding. Not clear i guess
Quantity Service Name
3 Srv2 Bob
4 Srv2 Paul
2 Srv1 Paul
1 Srv2 Nick
I want as output All the services and all the names and corresponding quantities (0 if none)
Srv1 Paul 2
Srv1 Bob 0
Srv1 Nick 0
[code]....
Here is what I got so far, but I dont even get the expected resultsAnd I am acutally certain there is a pretty easy way of achieving what i want...
Dim services = (From a In interventions Select New With {.Service = a.Service}).Distinct()
Dim months = (From b In interventions Select New With {.Month = b.DateHeureIntervention.Month}).Distinct()
'Dim query = (From s In services _
[code]....
Joining LINQ Query Results For Each Item Together?
Feb 3, 2011In my application, I have a search query textbox (txtSearch) that works well with one-word queries with the following LINQ:[code]So how would I make the above query more generic (ie: able to handle any number of words in a query)?I should note that the object being queried is a List of strings pulled from an Access database. As it stands, this application only queries the database once and I'd like to keep it that way if possible.
View 3 RepliesPass A Parameter From The Select List Into A Function For Joining A Linq Query?
May 25, 2010I have a query that can be summarised in SQL as follows;
Select
S.StockCode
From
StockToCheck As S
[Code]....
Where the S var is a list of strings. This gives the error 'S' is not declared and points to the S in the function call / join (GetPOSStock). So it does not seem possible to do this in Linq, can anyone confirm?
Datatables Left Join Linq - Joining 2 Datatables And Have The Joined Datatable As Result
Jun 1, 2012I'm having a hard time joining 2 datatables and have the joined datatable as result. First datatable (labels) holds data including a printerid. Second datatable (printers) holds printer references (id > unc). I would like to have as endresult (joined) a datatable with all data from the first datatable with the field (unc) of the second datatable. [Code]
View 3 RepliesLINQ: "Group Join" Functionality Joining Three Tables
Jul 21, 2010I'm working on becoming familiar with LINQ, and getting my head around the syntax and usage.
[Code]...
C# - Getting A Set Of Elements Using Linq?
Mar 26, 2010I 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" ?
VS 2010 Split And Joining Strings?
Mar 25, 2011i have a program where im trying to split a string from 1 text box and output the values in to 2 different text boxes .
my string username: password which reside in txt1.text
i want to split the string at ":" and have username appear in txt2.text and password appear in txt3.text i have this code but doesn't work for what i want to do.
Quote:
Dim text Array() As String = txt1.text.Split(":"c)
'ALPHA SORT THE ARRAY
Array.Sort(text Array)
[code]....
Also trying to find a way to rejoin the text back to the original string afterward in the username: password format
Accessing XML Elements With LINQ Using .net (not C#)?
Nov 29, 2011how 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]....
Linq Get Elements For The First N Groups?
Mar 16, 2012I 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]....
LINQ To XML - Sequence Contains No Elements
May 25, 2011I 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.
Add Child Elements To Existing Xml - Linq?
Aug 17, 2009I'm having trouble adding child elements to the below
<securities>
<security id="040104JC6">
[code]....
VS 2008 LINQ When Some Elements 'could' Be Missing?
Jan 27, 2010some 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.
[2008] LINQ - Xml Elements Into A Datagridview?
Oct 20, 2009I'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].....
Creating Objects From Child Elements Using LINQ To XML
Feb 1, 2011Is 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]...
XML Feed - How To Get Collection Of Elements (Assets) Via LINQ
Mar 9, 2011I 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] .....
Linq To Xml Query Returning A List Of All Child Elements?
Mar 8, 2010I 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.
Replace Xml Content In Conditionally Selected Elements Using Linq (VB 2008)?
Mar 22, 2009I'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]...
VS 2010 Upgrade From 2008 To 2010 - Now LINQ - IntelliSense Is Not Working For LINQ Stuff
Apr 20, 2010I 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.
Html - Dynamically Created Elements From Codebehind Need To Be Inserted Between Specific Elements
Sep 17, 2010I 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 RepliesVS 2010 - Checking Whether Two Calculations Have Same Elements
Oct 6, 2011I seem to occasionally find myself trying to compare two List(of T) to see whether or not they contain the same elements. A quick check of the documentation shows the SequenceEquals method, but that appears to check whether the two lists have the same length, and have the same elements in the same order. I don't care about the order. I want to know whether two collections have the same elements. Doing this is not terribly difficult, and seems common enough, so I was expecting that there would be some function that handles it.
View 11 RepliesVS 2010 - How To Remove Nothing Elements From Array
Oct 20, 2011How to remove the Nothing elements from an array using a For or For Each loop? I have to display the array to a datagrid, but the Nothing elements of the shows up as zeros. This is the code I have so far for my button click event:
Dim flag As Boolean = False
Dim found As Integer
For m As Integer = 0 To carArray.Length - 1
If carArray(m).carid = txtDelete.Text Then
carArray(m) = Nothing
flag = True
found = m
End If
Next
VS 2010 HTML Elements List?
Jan 17, 2012I'm making a bot to auto-reply to my PMs on a website, and I'd like to get all of the HTML elements with a class name 'InboxRow'. I can get the HTML element one at time, but the problem is that these will be dynamic, so the id and amt. of them will always change, so I want to put them in an array, where I can call each one up and perform the rest of my code for it. I just can't seem to be able to figure out how to find all the HTML elements with the class name and put them in an array, and I can't seem to find any tutorials online
View 4 RepliesVS 2010 Iterate Through Elements In Structures?
Dec 10, 2011I have a public structure in the same form I'm working with, like this...:
Public Structure Person
Public name As String
Public age As Integer
[Code]....
At the start of the code I've declared some 'Person' instances...:
Public TeamMember1 As Person
Public TeamMember2 As Person
Public TeamMember3 As Person
[Code]....
I don't know what to put at ??????. If we were talking about control objects I would write Me.Controls("TeamMember" & n) and that would work. But with a public structure I don't know how to refer to it.
Is it even possible? And if not, how would you do what I'm trying to accomplish?
I only want to run that 'If' statement with every team member which I have, and right now the only way I know to do it is to create 10 (!) of those 'If", and only change the team member number at the end. And that's horrible...
VS 2010 Monitor HTML Elements Changes?
May 22, 2012How can I monitor html element changes,
like this one:
<span id="Loading">60</span>
when the value becomes something not 60..
VS 2010 Can't Just Add Them Up Because Array In Question Could Have Thousands Of Elements
Apr 30, 2011I have an array of bytes, and I want to convert it into an array of bytes less than n. How could I do that? I can't just add them up because the array in question could have thousands of elements.
View 15 RepliesVS 2010 - Change A Single Element Of One Of The Elements Of The Array
Jun 8, 2012I haven't managed to find it and it is driving me nuts! If I have a structure such as
[Code]...
If I want to change a single element of one of the elements of the array, for example the DayHi field of the 0th element, then the code ATRList(0).DayHi = 4 causes the error: Error3Expression is a value and therefore cannot be the target of an assignment. Now I could get round this by reading all the items out of the 0th element into newATR, changing the field I'm interested in and then doing a "ATRList(n) = newATR" but there must be an easier way?
VS 2010 - Dataset Readxml - Read Only Certain Elements (columns)
Oct 5, 2011Dataset's ReadXML() method would read an XML document. But how would we skip certain columns? [Code] So, if I use ReadXML(), it would read the whole document and the dataTable would have "id" column, "name" column and "price" column. But I want to have only "id" and "name" column. How can I skip certain columns from reading it?
View 3 Replies.net - Joining Two Bezier Curves?
Jan 24, 2012i have two bezier curves placed at a distance apart in space.curve 1 has control points A0, A1,A2, A3. A0 and A3 lie on curve and are its end points Curve 2 has control points C0,C1, C2, C3 . C0 and C3 lie on curve.and are its end points
i want to join the two curves A and C with an intermediate bezier curve B. the intermediate Curve B has control points A3 and C0 which lie on the curve and are its end points. the intermediate control points B1 and B2 are unknown to me. also the joining should be smooth enough. please help as to how to proceed. have read alot about beziers but dont know how to do this.
Difference Between + And & For Joining Strings In .Net?
Apr 9, 2009difference between + and & for joining strings in .Net?
View 6 Replies