VS 2008 : Get Fullnames From List (of String) Using LINQ?
Oct 18, 2010
I have this vb code in my asp.net webservice.
<WebMethod()> _
Public Function GetUsers(ByVal prefixText As String, ByVal count As Integer) As String()
Dim UsersList As New List(Of String)
[code]....
However, This returns all the users from my user table. I want to get just the users where the fullname is like the prefixtext variable that is passed in to the function.Now I need to use LINQ(the only way I can think of). But how do I change my code.
View 9 Replies
ADVERTISEMENT
May 16, 2009
I was playing with ASP.NET MVC 1.0 a couple of days ago. I started out with a single table DB named 'Contacts', with very simple structure e.g. Title, FullName, SurName, Email, Phone, Address etc.I'm using LINQ as my Model.In my main view I wanted to display a list of alphabets that have matching FullNames starting with that alphabet plus the count of FullNames. Someting similar as shown below:
A - (2)
D - (4)
J - (1)
and so on.One particular thing about the display is that i don't want to display those alphabets that have no names starting with them.I tried a couple of queries but didn't succeed.
View 3 Replies
Dec 15, 2010
I got an object of List<List<string>>I need to bring this into a ist<string>I have no idea how to do this with LINQ.
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
Apr 27, 2012
I figure I should use 'Aggregate' but apparently I am getting it wrong First I get a list of my Entity objects Dim employers As List(Of myEntity) = (New XXXX()).getZZZ(userName, userType) Then I figured this would be a way to put all the names in a string Dim names as String = employers.Aggregate(Function(current, [next]) current.Name & " " & [next].Name)
[Code]....
View 2 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
Nov 23, 2011
Is there a way to check if a column contains all or any of an items in a list? Example "ABCDEFG" is my column value. "A" "C" "L" is my list stored in a list. I need to find rows that contains at least one item in my list. Then items that contains ALL the items in my list (a basic OR / AND search such as a SE would have)
View 1 Replies
Apr 30, 2010
I'm using the following code to sort a List(of Class) using LINQ. It works fine, but I'm wondering if there is a better way to do it. I'm basically taking one list, applying LINQ to it, then using the result to create a second list in the sorted order. Can I do this without creating a second list? Here is my sample
' KeyMatch is my Class Variable
' mMatchList is the Unsorted List
'
[code].....
View 3 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
Jul 29, 2011
I want the Function to accept List(Of String), Array & String and similarly return List(Of String), Array & String respectively. The Function simply adds a string (month) to the input collection. I just want to use it for string, array and list with needing to think of conversions.
[Code]...
View 2 Replies
May 20, 2012
Is there a way to convert a string into a linq query? Searching for those words brings up tons of stuff unrelated to what I'm trying to do..For instance, this works, of course...
Dim lstMyQuery = (From item in htMyTable.values where item(0) = "Apple" Select item)
But somehow I want to do this:
Dim strQuery = "From item in htMyTable.values where item(0) = " & CHR(34) & "Apples" & CHR(34) & " Select item"
Dim lstMyQuery = (Somehow run/convert strQuery as a query)
The reason is strQuery will be different each time depending on what the user has selected earlier in the program.R if lstMyQuery is already a collection, is there a way to add to it?
Dim lstMyQuery = (From item in htMyTable.values where item(0) = "Apples" Select item)
(this obviously doesn't work, but it's basically what I want to do...)
lstMyQuery.Add(From item in htMyTable.values where item(0) = "Oranges" Select item)
View 3 Replies
May 26, 2012
y have this class
Private Class MyClass
Public Property propertyOne() as String
Public Property propertyTwo() as String
[code].....
View 2 Replies
Jun 1, 2011
How can I get a new distinct list from an existing list using LINQ? This is what I have so far and it is not distinct but does give me a new list.
Dim tmpQryColumn = (From a In _allAudits
Select New CheckBoxListItem
With {.Id = a.AuditColumn, .Name = a.AuditColumn}
).Distinct()
_columnList = New List(Of CheckBoxListItem)(tmpQryColumn)
View 2 Replies
Dec 22, 2010
I have 2 classes
Public Class Shipper
Public Property ShipperID As Long
Public Property CreateDate As DateTime
[Code].....
View 1 Replies
Mar 12, 2010
How can I get a new distinct list from an existing list using LINQ? This is what I have so far and it is not distinct but does give me a new list.
Dim tmpQryColumn = (From a In _allAudits
Select New CheckBoxListItem
With {.Id = a.AuditColumn, .Name = a.AuditColumn}
[code]......
View 2 Replies
Jan 25, 2011
I have two generic lists, named ListA and ListB. Both ListA and ListB could potentially have duplicate items. What I would like to do is use LINQ to grab the items in ListB that are not in ListA, but I'm unsure how to do so.
View 8 Replies
Nov 23, 2011
I'm trying to create a list of days(integer) from a list of dates(date).
I tryed to do this....
[Code]...
View 4 Replies
Jul 29, 2010
This is what I want to do as seen in C#(loop against a list and fill another list from its data using Linq)
[Code]...
View 1 Replies
Mar 28, 2011
I am writing app in vb.net
I have two variables one with list of RoomRate and other with list of RoomTypes.
We have RoomRates and RoomTypes linked with RoomTypeInfo variable insite the RoomRate.
So how do i find the RoomTypes which donot have the RoomRates Defined.
My Sample Code:
class RoomType
property UIN as integer
property Title as string
end class
[Code]......
View 2 Replies
Jun 30, 2009
I'm basically brand new to LINQ. I've seen some examples that allow me to strong type objects using LINQ but I don't really understand them because they're in C#, which I guess lets you do different things with LINQ(I think?). [Code] I just want to get a list of all the products from the XML doc and put them into a Generics list.
View 3 Replies
Oct 18, 2010
What would be the fasted method of get a string list of all values within [] in a string of text? For example: [client_name], are you are doing today? My name is [my_name]. The list of strings would be:
[Code]...
View 6 Replies
Oct 8, 2011
I have added a module to the project. Inside the module I have the following
Public Function ListOFT() As List(Of String)
Return ListOFT
End Function
When I try to add something to ListOFT I get:
Quote:
Object reference not set to an instance of an object.
View 9 Replies
May 27, 2009
I have a DataGridView and i want to build a string list from that. i have tried many way wothout a good result.
I need to build this list of string and after that to make a single string to send it via e-mail
[Code]...
View 2 Replies
Jun 28, 2010
Okay so i have a very large list of string (500 000 strings) i want to check the number of duplicate strings and maybe even isolate the duplicate strings if i can.
i cant find a fast method to do so :S
i tried using a string array (slower than list) takes ~15mins
i tried using list with the code below takes ~10 mins
that wont cut it :S i need something faster.
[Code]...
View 10 Replies
May 15, 2010
I have a range of strings (Basically filenames) and I want to strip them down. Basically I load a list of files (path/clubs/) and it lists them into a list box as club1.adf club2.adf etc. I then select club1.adf for example from the list box, and hit a button. The button then loads path/club1 into my application. So basically I want to split the .adf from the club1. Something like the following, I imagine?
[Code]...
View 5 Replies
Aug 21, 2009
Basically what happens is each time it loops through it adds a number to the end of the string, and by the end I should end up with an array full of string in a format like "111 222 333 444 555 666" but I end up getting strings like this "111 111 222 222 333 333". The weird thing is, if I add a message box in every loop it works fine, but obviously I don't want a message box pooping up every time it loops through. What is causing this and how might I fix it
The code is:
For x As Integer = 0 To (NumCards.Value - 1)
NumRep = 0
[code].....
View 3 Replies
Nov 22, 2010
I'm trying to create a ntier desktop application using vb.net 2008.I'm trying this [code]...
View 6 Replies
Oct 17, 2010
I need to get a string from an items collection in a list box on one form to a list box on another form in VB 2008. Here is the code (I've tried a couple ways in the code to get the values over).
Public Class frmPrintBooks
Private Sub btnClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles btnClose.Click
[Code]....
View 3 Replies
May 11, 2011
I am trying to use linq to query a List(of T) object, but when i type in my linq statement it comes back with the following error: Error57Expression of type 'System.Collections.Generic.List(Of BreakoutData)' is not queryable. Make sure you are not missing an assembly reference and/or namespace import for the LINQ provider.D:\Code\OLGA35\BreakoutByBusinessUnit.aspx17025D:\Code\OLGA35\
I have looked at my web.config and I have the imports:
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral,
[CODE]...
I have put in several imports at the top of my page, but that hasn't helped
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" %>
<%@ Import Namespace="System.Collections.Generic" %>
<%@ Import Namespace="System.Core" %>
[CODE]...
I'm not sure what to do at this point.
Here is the code that is relevant:
Dim ListCollection As List(Of List(Of BreakoutData))
Dim GroupList As List(Of String)
Dim DataList As List(Of BreakoutData)
[CODE]...
Everything i've found on google just says to add in the System.Core, System.Data.Linq references, but as far as I can tell it all is setup correctly
View 1 Replies
May 25, 2009
I am trying to use linq to query a List(of T) object, but when i type in my linq statement it comes back with the following error:
Error57Expression of type 'System.Collections.Generic.List(Of BreakoutData)' is not queryable. Make sure you are not missing an assembly reference and/or namespace import for the LINQ provider.D:\Code\OLGA35\BreakoutByBusinessUnit.aspx17025D:\Code\OLGA35\
[code].....
View 6 Replies