LINQ To XML. Enumeration Yielded No Results?

Oct 17, 2009

I'm having trouble populating an object from an XML file. I've copied an example I've found almost exactly, with variable names changed, but I keep getting the "Enumeration yielded no results" exception.

Here is my code:

[code]...

Essentially, the XML query is supposed to return the title and the description for every Property which has an element called Language Code, which is equal to "en-us". I have a feeling that my problem lies in my XML code, but I've been stuck here for a long time now.

View 5 Replies


ADVERTISEMENT

Obtaining Name/value Pair Of Enumeration With LINQ [VB 2010]?

Jul 23, 2009

I'm trying to obtain name/value pair of enumeration typed into text box with LINQ. It's OK with name, but when LINQ reaches values, it throws error: "Conversion from string "Black" to type 'Integer' is not valid". I have read that if I want to obtain a value, then I gotta use conversion function.

Here's code (button's Click event):

Private Sub GetEnums(ByVal sender As Object, ByVal e As RoutedEventArgs)
lstEnums.Items.Clear()
Dim typeName = Type.GetType(txtEnum.Text)
Dim enums = From en In typeName.GetEnumNames

[code].....

View 6 Replies

.net - Working With The ObjectQuery Single Enumeration Challenge In Linq-To-Entities Entity SQL?

Dec 30, 2011

I'm working on modifying this example:

Using advWorksContext As New AdventureWorksEntities
' Call the constructor that takes a command string and ObjectContext.
Dim productQuery1 As New ObjectQuery(Of Product)("Product", advWorksContext)

[code]....

An ObjectQuery can be enumberated only once. (Subsequent attempts at enumeration throw an exception.) The enumberation takes place in the for each statement. The problem is that if the query is empty attempting a For Each will throw an exception. But if I check for a count:If productQuery1.Count > 0 Then . . .

That eats up my one chance at enumeration. I could nest the For Each in a try/catch block and throw away the empty query exceptions, but that's ugly.

View 2 Replies

IDE :: IntelliSense Doesn't Display Certain Enumeration Values In A .NET Project If Enumeration Is Declared Within A C# Assembly

May 28, 2010

I have just received an interesting feedback from a VB.NET customer using our product - for some reason intellisense hidden a certain enumeration value.After a small testing I have found that this is likely a bug in IntelliSense: [URL]..To be honest, I did not expect this problem with such a basic stuff like this. Have you seen this in the past? For me, it doesn't work in all VS versions...

Anyway, feel free to track this issue if you are coding in VB.NET.

View 1 Replies

Linq To Xml - No Results Sometimes?

Jul 13, 2011

Ok i have a query i use to parse an xml file to get an id number of a movie that allows me to get more detailed information about that movie from a database.Now the problem is the id is returned correctly with xml files stored on my hard drive (c:\desktop\movies)but when i try and parse an xml file on an external drive it dont get a hit on the <id>1123</id> node.

query
Function movieID(ByVal directory)
'Get the movie name

[code].....

View 2 Replies

How To Loop Through LINQ Results

May 17, 2010

I've got some code to try and loop through LINQ results, but it doesn't seem to be working.

HERE'S THE CODE

Public Sub ProcessRequest(ByVal context As System.Web.HttpContext) Implements System.Web.IHttpHandler.ProcessRequest
''# the page contenttype is plain text'

[Code]....

View 1 Replies

Put Two Linq Query Results Together?

Sep 11, 2009

I have used linq quite abit but was just wondering how to append the results of two IEnumerable(of X) together into one IEnumerable(of X)

View 4 Replies

Asp.net - LINQ-to-SQL Query Returning No Results?

Mar 5, 2011

I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:

Gender.Current Occupancy < Max Occupancy Available Flag is Checked I know this should return results but it keeps returning an empty set.Code is below

[code]...

UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.

View 3 Replies

C# - Transfer LINQ To SQL Results To An External Dll?

Oct 8, 2009

Before LINQ I would have my main application return the results of a SQL query into a dataSet. I would then transfer the dataset as a parameter to the external dll. Now I am bringing through a LINQ to SQL query that is returned as an IQueryable(Of vClientTable) object. I want to be able to transfer that set of vClientTable results to my external dll in order for the dll to work with the data included in the results.

I am probably doing it all wrong as well as trying to do it all wrong, but would like some advice on what would be the best method to use.

DB Query
Public Shared Function getClientData(ByVal clientID As Int32) As IQueryable(Of vClientTable)
Try
Dim r = From p In dbLINQ.vClientTable _

[Code]....

Obviously in the external dll it has no idea what an IQueryable(vClientData) object is and even if I create a dbml file and datacontext in my external project for the dll that includes the same class to the DB table/view it still says that the objects are different types.

View 4 Replies

Linq To Xml - Unexpected Search Results

Mar 10, 2011

Just when I was thinking that I had Linq To Xml sussed I'm faced with yet another error! I think if I was to understand the linq search process in general better I might have more success, so any good links regarding that are also welcome. To my problem however; using the code below:

[Code]...

View 1 Replies

LINQ To XML Query Returning No Results?

Jul 20, 2011

I'm doing some XLINQ in VB for work. I basically need to pull some values from a small chunk of XML as listed here:

<?xml version="1.0" encoding="utf-8"?>
<Fields>
<typeQtyRadioButtonList>1</typeQtyRadioButtonList>
<cmbQtyCheck>Reject</cmbQtyCheck>

[code]....

... Leaving out the implementation of the For Each loop....So I have stuck a break point on the for each and the collection has no elements in it.

View 1 Replies

Possible To Change &amp; To & In The Results From A LINQ Query?

Mar 3, 2009

I have the following code:

Dim db As New linqclassesDataContext
Dim categories = (From c In db.faq_cats)
NewFaqDropDownCategory.DataSource = categories

[code]....

View 3 Replies

Return LINQ Results From Function?

Jun 10, 2012

I'm trying to return a single object from an array of objects with linq.[code]...

View 2 Replies

VS 2008 LINQ Not Returning Results?

Mar 3, 2010

So, I'm not really sure if I have this setup properly or not. This is my first attempt at utilizing LINQ and I am trying to return data directly from an XML file.Here is my XML structure:

<folder_list>
<folder lbl="_localhost" abs="C:\_localhostapache2triadhtdocs" unc="C:\_localhostapache2triadhtdocs" tag="default" />
<folder lbl="Programming" abs="D:\_prog" unc="D:\_prog" tag="default" />
<folder lbl="Anime" abs="D:Anime" unc="D:Anime" tag="default" />

[Code]...

View 9 Replies

Joining LINQ Query Results For Each Item Together?

Feb 3, 2011

In 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 Replies

Asp.net - Linq Where Clause Not Producing Expected Results

Nov 8, 2011

I have the following xml:

<Root>
<Result img="1.png" name="a">
<Programs>

[Code].....

What is wrong with linq query. Why does a 1 work but a 2 does not? I would also like xml structure preserved after filtering.

View 1 Replies

Copy LINQ Results To Data Set / Table

Jun 24, 2011

I'm working on a form that has a few data grid views that are populated from LINQ queries, no problem there it works as it should however that sorting does not work. After doing some reading its because LINQ results do not support sorting.As I have the LINQ results already is there a way of copying the results into a dataset or datatable then binding the data grid view to that so sorting will work?

View 4 Replies

Html - Embed LINQ Results Into CDATA?

Jan 3, 2011

Can i merge the values returned from a LINQ query (in the next example c.day) with CDATA like...

Dim Result = <items>
<%= From c In db.News Select _
<item>
<day><![CDATA[<font size="30" color="#7CBEBD"><%= c.day %></font>]]></day>
</item> %>
</items>

View 1 Replies

Linq Return Results Contaiined In A List?

Mar 23, 2011

How can i select using linq from a datatable where the the only results I want back (ID's) are contained in a list of integers?

View 7 Replies

.net - Detect Empty Results In A Linq-To-Entities Query?

May 29, 2009

The only way I know of is awkward:

'check for empty return
Dim count As Integer = (From s In myEntity.employee Where employeeID = myEmployeeIDVariable).Count
'If there is a record, then process

[code]....

View 2 Replies

Asp.net - Single Quote In LINQ Results Causing Error

Jul 14, 2011

I have the following LINQ query:

Dim find_id = From p In dbContext.Residents _
Where p.person_name = occupant _
Select p

I then pull the first returned ID like so:

Dim building_id As String = find_building_id.FirstOrDefault.id

This works fine, except with the person has a ' in their last name, like M'arta. In this case I get a NullReferenceException.

Okay, the problem appears to be that when I am capturing the name initially from a GridView it is inserting into the value a #39 instead of ' and then LINQ is keeping things correct, so I end up with a non-match since it is attempting to match:

M#38arta = M'arta

View 1 Replies

Compare LINQ-to-Entity To Date Results In Error?

Mar 14, 2011

I have a simple If..Then like so:

If rhcexists.First.SignatureDate > Date.Today.AddMonths(-6) Then
End If
rhcexists is a simple query to the Entity Model:

[code].....

View 1 Replies

Invoke A Stored Procedure With LINQ Results In Error?

Apr 2, 2010

My application produces this error System.Data.SqlClient.SqlException: Login failed for user..This started after I added a stored proc in my dbml file. It works fine in my local enviroment, but throws that error when deploy to staging sever. the user it displays is foreign to me?

View 1 Replies

Iterate Through LINQ Query - Results From Multiple Tables

Dec 7, 2010

I have a VB .Net linq query that I want to return values from two tables. I currently have this:
Dim query = (From c In db.Client _
Join u In db.Users _
On u.UserID Equals c.UserID _
Where (c.ClientID = 1)
Select c, u).ToList
query (System.Collections.Generic.List(Of )) returns several rows as expected each item containing a c and a u.
How do I iterate through the queries collection?

View 1 Replies

LINQ To Entities .Any() Results In Null Reference Exception?

Nov 16, 2011

I have a simple query as below:

Dim sizings = From a In db.Sizings
Where a.Customer.ID = customer.ID
Select a
If sizings.Any Then
.....

The sizings.Any line is throwing a null reference exception. I thought I was meant to use .Any to determine if there were any rows returned?isnothing(sizings) returns false.

Edit - Resolution:Don't use null objects in the LINQ Query!

View 2 Replies

Sort Linq Results Ascending Using Subselect And Then Descending?

Nov 11, 2011

I am trying to work out a LINQ query to pull items from a List, the List contains a child-nested List - which I need to query for an item, then use the resulting item in my final sort of all records returned the query.[code]...

View 1 Replies

Update One Entity Based On Results Of Another LINQ-to-Entities Query

Apr 9, 2011

I have the following LINQ-to-Entities query:[code]This will give me all the resident assignments for the current year/term. Then I have this LINQ-to-Entities query:[code]This will give me all the rooms. I want to iterate through the assignments and based on what room is assigned update the occupancy in reset_occupancy. I'm not 100% sure how to accomplish this. Here is my pseudo code of what I want to accomplish:[code]

View 1 Replies

Update One Entity Based On Results Of Another LINQ-to-Entities Query?

Dec 15, 2009

I have the following LINQ-to-Entities query:

' Get all the residency assignments that match the term/year.
Dim assignments = From p In dbContext.Residents _
Where p.semester = term _

[code].....

View 1 Replies

Show The Final Results Instead Of The Results Real-time

Sep 28, 2010

I have a form that allows users to select file and then it reads the contents, parses the data and then executes a sql insert statement to add it to a database. What I am having issues with is showing real-time results. Currently, I have the import operation take place on the import form within the OnLoad event. The problem with this is it only shows the final results instead of the results real-time. Is there anyway to do this without creating a seperate thread and delegates?

View 1 Replies

Enumeration Already Finished?

Dec 17, 2009

Is there a way to check to see if the enumeration is already finished?

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved