Select Replicated Items In A List With Linq?
Feb 17, 2012I have a list of "ObjDay" which could have replicated items. How can I select them?
ObjDay is:
Public class ObjDay
_date
...
End Class
[Code].....
ADVERTISEMENT
Finding Items In One List That Aren't In A Second List Using Linq
Jan 25, 2011I 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 RepliesGetting List Of Items Not In Parent List Using LINQ
Mar 28, 2011I 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]......
Remove Items From Multidimensional List Using LINQ?
Jul 28, 2010Public Class GroupSelect
Public Property RowNo() As Integer
Get
[Code]....
.net - LINQ Sample: Select Typed Objects From A List
Jul 7, 2011I have
Dim objectsList as List(Of Object) = GetAllObjects()
' Filter from Objects just Persons '
Dim peopleList as List(Of Person) = ???
What is the most efficient and effective LINQ expression to do it?
EDIT
1 Dim selectedObjects As List(Of Object) = GetAllObjects()
2 Dim selectedPeople As IEnumerable(Of Person)= selectedObjects.OfType(Of Person)
3 Dim people As List(Of Person) = selectedPeople.ToList()
Error on 3:
Value of type
'System.Collections.Generic.List(Of
System.Collections.Generic.IEnumerable(Of Person))' cannot be
converted to
'System.Collections.Generic.List(Of Person)'.
Asp.net - List Of Select Data In Entity Framework (linq)?
May 4, 2012This is my function:
Public Function GetAllEmployee() As List(Of Employees)
Return DB.Employees.Select(Function(q) New With {q.EmployeeID, q.LastName,q.FirstName}).ToList()
End Function
I'm getting an error:
Value of type System.Collections.Generic.List(Of <anonymous type>) cannot be converted to System.Collections.Generic.List(Of NorthwindModel.Employees).
How To Select Specific Items From A List
Sep 28, 2010I am working with a list of points. It is declared as a global in my form.[code]the only issue is that instead of New Point(100,100) i need to be able to navigate to the previous 4 records in the list. pull out the 4 x vals the 4 y vals and boom there you go. In the old days id make a simple loop and get r done but im not sure the syntax to step through the list that way.
View 8 RepliesSelect Items Of An External Application List?
Jan 5, 2011By the EnumChildWindows API I can know the Hwnd of the ListBox control of an external application. By the Hwnd I can too to select "generically" the control by a PostMessage API, also if the application is not the foreground window.
Now the question is: is there way, in your opinion, to select a specific item of this external list box, also when the application is not the foreground window?
.net - LINQ Query For Filter By Selected Items In Checkbox List?
Jun 30, 2011Could not find this through Google or in SO questions.I have a checkbox listbox on my form. I want to filter my List by the list of selected Ids from that listbox that are checked, in SQL I would have done this like "Where TypeId In (1, 4, 5, 7)"... how do I do that in LINQ?
I feel like I am missing a really obvious answer, but cannot get it.
For argument sake... here is the what I have for sample data:
In Colors (List<of currentColors>)
ID, Name, TypeId
1, Red, 1
2, Blue, 1
3, Green, 2
4, Pink, 3
Selected Types 2 and 3 in CheckboxList: filteredColors
[Code]...
Insert Multiple Items Into List Or Array (no Linq And Not Quite CodeGolf)?
Sep 10, 2010No matter how I try, I can't seem to create a nice and clean algorithm for doing the following:
System.Array (or generic List) data of System.Object
System.Array (or generic List) xval of System.Object
System.Array (or generic List) idxs of System.Int32
[code].....
Pass 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?
LINQ To SQL Query - Select Customer From Dropdownlist And Then Gridview - Load All Items Of All Orders Of That Customer
Oct 4, 2011I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:
Dim allorders = From ord In db.Orders
Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)
[CODE]..............
I also tried to modify the query as follows:
Dim orderitems = From oi In db.OrderItems
Where oi.OrderNumber = (From From ord In db.Orders
[CODE]...........
But this does not work. I just started using LINQ.
VS 2008 - Linq Statement To Go Through A Dropdown Menu's Sub Items And Get What Items Are Checked
Apr 8, 2010I have the following linq statement to go through a dropdown menu's sub items and get what items are checked: vb Dim UnselectedItems = From xItem As ToolStripMenuItem In tsiSelectObjects.DropDownItems Where TypeOf xItem Is ToolStripMenuItem AndAlso CType(xItem, ToolStripMenuItem).Checked = False
I get this error tho: Unable to cast object of type 'System.Windows.Forms.ToolStripSeparator' to type 'System.Windows.Forms.ToolStripMenuItem'. As you can probably guess i have ToolStripMenuItems and separators in there
However the AndAlso should short circuit in the case where the item is not a ToolStripMenuItem and it doesn't seem to be doing so (as TypeOf xItem Is ToolStripMenuItem=false in this case)?
Combobox Select - 2 Items From Single Select
Mar 7, 2012I am a beginer in vb.net. For a school project, i have chosen inventory control as the subject. WIth help from videos, i have developed some basic forms with adding/updating.
The product table design is like this:
Name
Type
Size
[Code]...
Now, i am designing the purchase/sales screens. I am showing the items name, qty, price in a datagrid. From the products table, I am able to select the 'ProductName' by giving it a combobox . I want the ProductSellingPrice also to appear in the next column of the grid.
Convert A List Linq Expression To Defined List Class?
May 26, 2012y have this class
Private Class MyClass
Public Property propertyOne() as String
Public Property propertyTwo() as String
[code].....
.net - Create New Distinct List(of T) From Existing List(of T) Using LINQ?
Jun 1, 2011How 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)
.net - Searching A List Of Objects In An Object List Using Linq?
Dec 22, 2010I have 2 classes
Public Class Shipper
Public Property ShipperID As Long
Public Property CreateDate As DateTime
[Code].....
Create New Distinct List(of T) From Existing List(of T) Using LINQ?
Mar 12, 2010How 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]......
Linq - Create A List Of Integers From A List Of Objects?
Nov 23, 2011I'm trying to create a list of days(integer) from a list of dates(date).
I tryed to do this....
[Code]...
Loop Against A List And Fill Another List From Its Data Using Linq
Jul 29, 2010This is what I want to do as seen in C#(loop against a list and fill another list from its data using Linq)
[Code]...
Determine If Property Is Generic List<of T> Via Reflection And Loop List Items
Oct 1, 2009I'm looping all the properties in an object via reflection:
For Each p As PropertyInfo In values.[GetType]().GetProperties()
If p.CanRead Then
'Do stuff
End If
Next
how to determine whether the property in question is a generic List(Of T)? If it is I need to loop the list itself.
I've experimented with GetType and TypeOf but have not managed to get anything working.
To clarify, I want to keep this generic. I do not want to specify the type of T, I need to loop the list items and call the ToString method on each item. T could be one of a number of different types (application specific reference types). Is it possible to do this without specifying types?
(VB.NET 2005 with .Net 2.0)
Placing Selected/unselected Items In Checked List Box Into List Boxes?
Mar 16, 2011This program is supposed to allow the user to check items in a checked list box. If the item is checked, it goes into the Completed List Box on the right. The program then adds the unchecked items to the Pending list box on the left. I keep getting placement values (e.g. O,1,2) instead of the strings (e.g. "Key Returned") in the list box results (see photo attached)
Public Class frmCheckOut
Dim i As Integer
Dim cleaning As String = "Cleaning Inspection"
Dim damage As String = "Damage Repaired"
[code].....
Shuffling Items Inside A Movie List / Need To Delete Half List
May 16, 2011Another program I am working on for fun, I am basically shuffling a list inside a listbox, what I want to do is delete the rest but not sure how to go through with that. At the moment I have this: [code] Just contains the code, declarations outside weren't included.So anyway, once clicked, it will call on the function to basically shuffle in a for loop, I was wondering if I should (or how should) create another function and call it in the click button or have just a loop in the click button so it deletes half the list. What I am doing is I have 20 list of items, I want the program to shuffle the items and then deleting the lower 10, meaning, if I had 10 items and wanted 5 top, I'd want: 0, 1, 2, 3, 4 and deleting 5, 6, 7, 8, 9.
View 7 RepliesXML To LINQ - Get List Of All Products From XML Doc And Put Them Into A Generics List
Jun 30, 2009I'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 RepliesList.count While Adding Items To The List Increments Returns 0
Jul 20, 2011I am attempting to read the results from a SQL query into a List(Of) and I can see the List.count while adding items to the List increments, however in another part of my code when I am attempting to read the List the List.Count returns 0. My List is as follows:
[Code]...
Saving Replicated Data - Current Data Saved To Appear In Page Within All The Relevant Fields?
Jun 2, 2010What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
Dynamically Generate List Items To An Unordered List In ASP.NET?
Nov 27, 2009I have an error panel that is subbed in to a page if an error goes wrong to gracefully handle and display errors.Currently, I am just appending the error messages to a string and pushing that to a label. If you have multiple errors, this gets messy.I'd like to push each error to a list item in a bulleted, unordered list.How can I dynamically generate, from a vb codebehind file, new list items inside of an undordered list element?
View 2 RepliesVS 2008 Search Item A (from A List Of X Items) In List B?
May 5, 2010i want to search item A (from a list of X items) in list B but i want to get the item not found example Search ITEM A in LIST B if not found then return a print....if found continue with ITEM B..and so on.
View 5 RepliesVS 2010 Return Items In A List Before Returning The List?
May 23, 2012That was probably bad title, but I'll illustrate what I'm trying to do. I have a method in a class that I need to call several times. The method returns a List(Of String). I'm just grabbing some information from a database.
VB.NET
Public Function GetTestList() As List(Of String)
Dim int As Integer = 0
[code]....
Asp.net - LINQ To SQL - Select SUM With A WHERE?
Aug 17, 2009I'm having trouble getting a Linq to Sql query to work. Basically, I want the sum of a column in a table for only rows matching a certain condition. A simplified version is this:
Orders = order that contains products
OrderProducts = relational table containing products that are in an order
Products = table containing information about products
I can get the total sum of the qty of products like this:
Dim totalQty = requests.Sum(Function(p) p.OrderProducts.Sum(Function(q) CType(q.ProductQty, Nullable(Of Integer))))
(Requests is a IQueryable of Orders)But I also need to get the sum of qty where the actual product meets a certain condition. Something like...
Dim totalQty = requests.Sum(Function(p) p.OrderProducts.Sum(Function(q) CType(q.ProductQty, Nullable(Of Integer))))... WHERE p.OrderProducts.Product.ProductAttribute = true
How would I go about getting that query with the additional where clause to only get the sum of the qtys where the productAttribute = true ?