Can't Get The Query To Turn Into A List
May 12, 2009
my query is this: I want all of the characters that are of a membership level in a given area that is of admin or above.
This is what I have so far:
Dim L As List(Of Character) = (From C In MasterCharacterList.Characters.Values _
Where Me.Item(C.CharID).DreamLevel.ContainsValue( _
(From L In _Levels Where L.Value.Admin Or L.Value.BotMaster Select L.Value.MemberLevel).ToList.ForEach) Select C)
Me, in this case, is the members collection.
So far, I can't get the query to turn into a list (hence no .tolist at the end.) I know there's something wrong here, but I'm not sure what.
View 6 Replies
ADVERTISEMENT
Sep 30, 2009
How can I turn the following query into a LINQ statement? [code]
View 1 Replies
Sep 22, 2009
I know that LINQ queries are deferred and only executed when the query is enumerated, but I'm having trouble figuring out exactly when that happens.Certainly in a For Each loop, the query would be enumerated.What's the rule of thumb to follow? I don't want to accidentally enumerate over my query twice if it's a huge result.
For example, does System.Linq.Enumerable.First enumerate over the whole query? I ask for performance reasons. I want to pass a LINQ result set to an ASP.NET MVC view, and I also want to pass the First element separately. Enumerating over the results twice would be painful.It would be great to turn on some kind of flag that alerts me each time a LINQ query is enumerated. That way I could catch scenarios when I accidentally enumerate twice.
View 3 Replies
Sep 29, 2011
I'm extremely unfamiliar with both .NET and VB.NET and can't quite figure out how to do this. Say I have code like this:
<div class="breadcrumb">
<asp:SiteMapPath ID="SiteMapPath1" runat="server"></asp:SiteMapPath>
</div>
It outputs a bunch of <span>s with > as separators, something like this:
[Code]...
View 2 Replies
Feb 11, 2012
My current code: Server: Imports System.IO Imports System.Text Imports System.Threading
[Code]...
View 9 Replies
Feb 17, 2012
Right now I can add background music in my program by using this code
My.Computer.Audio.Play(My.Resources.Music_3, AudioPlayMode.Background)
I can also turn it off and change the music by using this code
My.Computer.Audio.Stop()
My.Computer.Audio.Play(My.Resources.Another_Music, AudioPlayMode.BackgroundLoop)
Is it possible to pause the music then if I resume the music it will just continue the flow? I mean if I pause the background music in 33 seconds and the music has 50 seconds and I resume it will just continue playing in 33,34,35 etc.. seconds?
View 2 Replies
Sep 1, 2009
I was wondering if their was a way to for me to turn off events and then turn them back on in my program or just queue them up until i am ready for them to be excuted. Kinda like how a OS turns on and off interupts. Is this one of those general programming no-nos?
View 1 Replies
Sep 2, 2011
Dim query = From o In myContainer.MyObjects Select o.MyStringProperty Distinct
Dim myProperties As List(Of String) = query.ToList????? 'no way!!!'
"query" type is IEnumerable(Of String)
I tried to use the query directly as a DataSource of a (infragistic) combobox, but it throws me NullReferenceException, so I decided to convert it to a listof strings, to be a more "classical" datasource.
Dim values As List(Of String) = query.AsQueryable().ToList()
does not work either: Value of type 'System.Collections.Generic.List(Of System.Linq.IQueryable(Of String))' cannot be converted to 'System.Collections.Generic.List(Of String)'.
View 3 Replies
Jan 7, 2012
I have a few running totals and a name associated with these totals and was wondering if an array would be quicker to use instead of storing it in a database.Basically what happens is I need to search a name and if it exists I add the necessary amounts to the totals and if it doesn't exists I add a new record.
View 4 Replies
Oct 7, 2011
The scenario is this, I have several variables that are set as a list(of objects). The values for these lists are populated during code via a SQL query. I want to be able to take these values and then use them within another SQL query. Each time the program runs the values will be different and there will be more or less within the list.
View 6 Replies
Sep 12, 2011
'Read RESX file and returns a List(Of ResXDataNode)[code]...
Provide two separate copies of the node? Or will the List and Linq query still be referencing the same data?
View 2 Replies
Dec 9, 2009
I am working on making a Windows based application within Visual Basic 2008 Express that could potentially be used for a music school as a project. This application is connected and bound to a Microsoft Access database. Within this application I have a form for adding a new appointment reservation. This form has a combo box that the user can select the lesson type (eg. "I want a piano lesson"). Upon being changed, a list box would be populated with the names of all instructors that have that selection as either their primary or secondary talent.So, my database is bound, the query is written (correctly...i hope), and I don't know how to 1) select the table column that I want displayed in the list box and 2) actually display the query results within the list box. Is this making sense? Probably not, bu
Private Sub cmbLessonType_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbLessonType.TextChanged
'populate the lboInstructor box
[code]....
View 5 Replies
Mar 11, 2011
I have a question about error handling. I have a Try...Catch Error Handling block and with in the Try section I query a database to get a list of files that need to be opened by AutoCAD (using an AutoCAD script file) and a PDF generated of that DWG file. My problem is that sometimes a user has that particular drawing open that it detects to open up and PDF. I use the following code to determine if it is open or not.
[Code]...
Edit by Moderator: use code tags when posting code. Click on this post's quote button to see how.
View 10 Replies
May 8, 2009
I was speeding up my app by using compiled queries for queries which were getting hit over and over.I tried to implement it like this:
Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False
[code].....
View 1 Replies
Mar 9, 2010
I was speeding up my app by using compiled queries for queries which were getting hit over and over.
I tried to implement it like this:
Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False
[Code].....
View 1 Replies
Apr 23, 2008
How to Filter a Database Query Using a List..
View 2 Replies
Sep 14, 2010
Im just trying to figure out how to write an LDAP query to list all of the PCs in a specific OU.
View 3 Replies
Jun 28, 2011
I have this code:
[Code]...
View 3 Replies
Apr 13, 2012
I am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers
Code:
Imports System
Imports System.Data
[code].....
View 3 Replies
Aug 15, 2011
I have a List<string> that contains paths, such as:
[Code]...
Given a given root, such as Root, I would like to "query" this list to return only the first level values, such as:
[Code]...
View 2 Replies
May 3, 2012
I have a query that 'selects' object of a type:
Dim l as IList(Of Foo) = (From dataRow As DataRow In table.Select()
Where CStr(dataRow("Column1")) = "A"
Select New Foo(CStr(dataRow("Column1")), _
CStr(dataRow("Column2")))).ToList()
What's happening is that if i set a break-point to the constructor of Foo and step, the constructor is hit and the parameters are loaded with the arguments. However, l has empty Foo objects (the members in every object are Nothing). What could be happening here?
View 1 Replies
Dec 22, 2011
I have Customers table in a database. I'd like to create List of CustomerNames using entity framework 4.1. How can I do that in Visual Basic?
Dim customerNames = (From c In _context.Customers
Select New With {c.CustomerName}).ToList()
brings a list of anonymous objects.
View 1 Replies
Jul 6, 2011
Is it wrong? Please suggest me correct way.
Public Function ReadXML() As List(Of String)
Dim list As New List(Of String)
Dim xmlDoc As XDocument = XDocument.Load("C:\MappingFile.xml")
[code].....
View 1 Replies
Jan 24, 2012
It's simple question. I am confused since I am new to vb.net and windows form. I would like to display combining of one column (lastname+firstname) in the list box control from the query. My code display something.
[Code]...
View 8 Replies
Feb 3, 2012
I am using a path comparison to find any children tags which works well when there is only 1 tag selected. This is my code for when multiples tags are selected but it is not working. Can you point me in the right direction?
Single Tag Selection (working)
Dim tagpath = uxTags.SelectedItem.Text
lnqCases = From i In lnqCases Where i.HelpDeskTagItems.Any(Function(x)
[code]...
View 1 Replies
Mar 8, 2010
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.
View 1 Replies
Dec 27, 2011
I try to show my table data type in datagridview vb.net.[code]I try login using username "system". When I run this code, I got error message "ORA-00900: invalid SQL statement".
View 2 Replies
Aug 1, 2011
I try to show my table data type in datagridview vb.net. Here is the sample code :
oradb = "Data Source=(DESCRIPTION=" _
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" & txtServer1.Text & ")(PORT=" & port1.Value & ")))" _
[code]....
View 2 Replies
Sep 21, 2009
i have an application integrating the an API (autotask web services). I get the data by using a XML query opposed to a SQL query. I'm trying to figure out how to fill a dropdown list with the returned data. Here is my
Dim AccountID As Integer = 29783925
' Query returns Account details for account with the ID AccountID
Dim strQuery As String = "<queryxml><entity>Account</entity>" & _
[Code]....
View 10 Replies
Oct 24, 2010
If I use a LINQ query over some type of collection, is there any way to know the initial index of an element of the result?
Purpose: I make a query to set as source of a DataGridView, and on a (button)cellclick event I want to a call a method that needs to reference the collection at the correct index.
View 13 Replies
