.net - Linq Nested Grouping?

Jul 7, 2009

I've a large table of Items and I need to organize them by Category, then by Year and then by Month.Item has CategoryID and Dated properties.I got this far:

Dim Items = From Item In DB.Items _
Group By CategoryID = Item.CategoryID _
Into Categories = Group _
Order By CategoryID

But where I put the:

Group By Year = Year(Item.Dated)

and the

Group By Month = Month(Item.Dated)

The final result should be something like this:

For Each Category in Categories
For Each Year in Category.Years

[code].....

View 2 Replies


ADVERTISEMENT

.net - Grouping Using LINQ?

Feb 5, 2010

I'm having a heck of a time with transforming a simple SQL Query into a LINQ query(using vb btw)

Here is my SQL:
SELECT USRDEFND5
FROM int_gp_employee
GROUP BY USRDEFND5

[Code]...

I've tried a number of different variations of the LINQ. My current statement is:

From b In xmlFile...<row> Group b...<usrdefnd5> By b...<usrdefnd5> INTO group when I foreach through the resulting collection, EVERY line (17000) shows up.

View 2 Replies

Datatable Grouping Using Linq?

May 25, 2011

I'm completely dense here, but I'm trying to get some stats from a DataTable. One of the columns in the datatable is called "colour".I need to find out how many of each instance of "colour" are in the datatable.

I'm trying:
Dim q = From p In PGWorkingDataTable _
Group p By p("colour") Into Group _

[code].....

View 2 Replies

Counting Orders And Grouping Them, Linq To Sql?

Aug 15, 2011

I have a table called Ordersthe table has many rows but im only interested in two in particular.I want to query the table so it returns the average ordered count of each producti want to know what is the average count of the ordered products, but now in total but per productID instead.

View 1 Replies

Grouping A Generic List Via LINQ?

Jun 26, 2011

I need to take a collection and group it via Linq but all the examples I've seen fail in some manner or other with some syntax difference that I can't quite lick.

My collection:

Dim a As New List(Of ProcessAlert)
a.Add(New ProcessAlert("0000112367", "5551110000@txt.att.net", "Alert", 2))
a.Add(New ProcessAlert("0000112367", "5551110000@txt.att.net", "Document", 2))

[Code].....

View 1 Replies

Linq Grouping By Nullable Datetime And Using This As Criteria?

Nov 17, 2009

I am struggling with a nullable datetime column [DateInsp] in an ASP.NET app which uses SubSonic3, Linq, MS SQL Server 2005.I had this all working when the datetime column [DateInsp] did not allow nulls. A new requirement forced me to set the [DateInsp] column to allow nulls and now I am struggling getting this piece of functionality to work properly again.

Problem 1:I need to first render a dropdown list of the 7 most recent inspection dates for a given inspector (this is a grouped list of the 7 most recent dates for the inspector). Here is the TSQL that I need to convert to Linq syntax:

declare @InspectorID varchar(5)
set @InspectorID = 'GPA'
select top 7 convert(nvarchar(30), [DateInsp], 101) InspectedDate

[code]....

If I can't get this work properly using Linq, BUT I can/could build a stored proc to return the list of dates and throw that into a dropdown. Fair enough. I've been fighting with the Linq syntax?

Problem 2: I need to use the selected date in the dropdown mentioned above to pull the correct records for this inspector and the correct date. Again, this is a nullable datetime field and this is real sticking point for me.

Here was the original Linq syntax that accomplished the requirement before I had to change the datetime field to allow Nulls:

Dim query = (From i In db.IncomingInspections _
Where i.InspectorID = User.Identity.Name _
Group By Key = New With {i.DateInsp} Into Group _

[code]....

For some reason I can't use the .Value property; I get: The member 'Value' is not supported I get: "Incorrect syntax near '<'." if I try to add the date comparison to the where clause too.

View 2 Replies

LINQ To SQL Grouping Multiple Columns With A Distinct Row

Aug 9, 2010

I have the following table structure. I want to select distinct CustomerId and CustomerName, TotalCost.[code]

View 2 Replies

Return Max Record Count By Grouping In Linq?

Nov 9, 2011

I'm very new to linq and I'm trying to come up with a linq query against a dataset that will return a max count value based on grouping records.[code]...

View 1 Replies

Converting A Traditional SQL Aggregate Query Into A LINQ One - SUM Grouping ?

May 24, 2010

I'm having trouble getting my head around converting a traditional SQL aggregate query into a LINQ one. The basic data dump works like so:

Dim result =
(From i As Models.InvoiceDetail In Data.InvoiceDetails.GetAll
Join ih As Models.InvoiceHeader In Data.InvoiceHeaders.GetAll On i.InvoiceHeaderID Equals ih.ID

[CODE].....................

What I need to really be getting out is ih.Period (a value from 1 to 12) and a corresponding aggregate value for i.ExtendedValue. When I try to Group ih I get errors about i being out of scope/context.

View 1 Replies

Linq Grouping With Anonymous Types And Option Strict

Apr 24, 2012

I've got the below, where I'm grouping a collection by a propery, then wanting to access the properties of my group. Problem I have is with the anonymous typing. Because of option strict I have to give an explicit type but I can't work out what the type should be. The below doesn't compile because t.HeadAccountKey isn't a value (as t has a type of object). So either I need do some casting or my linq selector is wrong,

[Code]....

View 1 Replies

Special Nested Query In LINQ?

Nov 30, 2011

I'm writting a graph algorithm and I'm almost there...My algorithm stores several edge objects in a collection of edges, representing a path from initial vertex to final vertex.hus, there should be also several paths between those vertexes (several collections of edge type), stored in another collection (in my class, callded "collswap").Each edge is an object which have two vertexes: initial (v) and final (w), in this way:

dim manhattan as new vertex
dim brooklyn as new vertex
dim statenIsland as new vertex

[code].....

View 1 Replies

C# - Linq - Find Element In Nested Collections

Feb 19, 2011

I have a generic list - SupportedTypeGroups. Each SupportedTypeGroup has SupportedTypes property (generic list of SupportedType). How to construct a Linq query to locate SupportedType with required name?

View 3 Replies

Sql - Group By Having And Count As LINQ Query With Multiply Nested Tables?

Feb 28, 2012

I have the following SQL query to return all Customers who have no OrderLines with no Parts assigned - i.e. I only want the customers within which every order line of every order has no parts assigned - (in the actual problem I am dealing with a different domain but have translated to customers/orders to illustrate the problem)

SELECT c.Customer_PK
FROM Customers c
INNER JOIN Orders o[code].....

This works but generates less than optimal SQL - it is doing a subquery for Count on each row of the customers query rather than using Group By and Having. I tried making the LINQ Group By syntax work but it kept putting the filter as a WHERE not a HAVING clause.Edit in response to Answers below: I am accepting JamieSee's answer as it addresses the stated problem, even though it does not produce the GROUP BY HAVING query I originally had.I am a VB developer so I have had a crack translating your code to VB, this is the closest I got to but it does not quite produce the desired output:

Dim qry = From c In context.Customers
Group Join o In context.Orders On c.Customer_PK Equals o.Customer_FK
Into joinedOrders = Group[cod].....

The problem I had is that I have to push "jl" into the Group By "Key" so I can reference it from the Where clause, otherwise the compiler cannot see that variable or any of the other variables appearing before the Group By clause.With the filter as specified I get all customers where at least one order has lines with no parts rather than only customers with no parts in any order.

View 3 Replies

LINQ Query To Group Data Between Two List Collections, Populating A Nested Object

Oct 26, 2011

I have these objects:[code]Using LINQ I need to take a List(Of MakeInfo) and a List(Of ModelInfo) and aggregate the StockInfo from ModelInfo into the List(Of MakeInfo).So for each MakeInfo I will have a total count of all stock where MakeInfo.Name = ModelInfo.Make, and also a minimum price.I think it's going to be something like this, but I'm having trouble accessing the nested object and not sure if it's going to be possible with a single query.[code]

View 2 Replies

Nested Multi-line Lambda Function As Parameter For LINQ Select Is Causing An Error

Jun 29, 2010

I'm trying to use a nested multi-line lambda Function in VB.NET and am getting an error. Here's what my code looks like:

cartItems = cartItems.Select(Function(ci) New With {.CartItem = ci, .Discount = discountItems.FirstOrDefault(Function(di) di.SKU = ci.SKU)})
.Select(Function(k)
If k.Discount Is Not Nothing Then

[code]....

View 2 Replies

Use LINQ To Filter Collection Of Nested Classes To Yield Dictionary Of Unique Properties Of Those Classes?

Jan 23, 2012

I have two classes, one nested in the other. [code]Neither "Name" or "ID" are unique between operations and records.I wish to construct a dictionary using LINQ = Dictionary(Of String, Of List(Of Integer), whereby the keys are uniqe examples of Names in my collection and the values are the collective set of distinct IDs that are associated with those names.

View 2 Replies

Loop And Enumerate Properties Of Nested Classes In Nested Classes?

Sep 24, 2010

so far i got

code
For Each item As Reflection.FieldInfo In GetType(NameSpace.ClassWithNestedClasses).GetFields
rtfAppend(item.Name & ":" & Tab & item.GetValue(Me))
Next
For Each item As Reflection.PropertyInfo In GetType(NameSpace.ClassWithNestedClasses).GetProperties()

[code]...

which gets me the simple string vars and properties of my top class, but how can i apply this to loop through all sub classes and get there vars and props?

View 1 Replies

.net - Grouping Application Settings?

Aug 12, 2011

My VB.net application has a lot of application settings, is it possible to group them somehow(other than having a common name)?For example, my application has a lot of winforms each of which needs to save some information about itself. Is it possible to use something like:

Form1.width = My.Settings.Form1.Width
Form2.width = My.Settings.Form2.Width
etc.

View 1 Replies

Asp.net ListView Or Repeater Grouping By Three

May 8, 2012

I am using a nice shopping cart I found online. I would like to translate this code to use a repeater or listview and dynamically retrieve my data, but I cannot seem to find a way to group my data correctly.I know the ListView can group by a certain amount of items, but I have not found a way to do it with this scenario.The shopping cart works by having a ul list of items, followed by their details in the div below. This process starts again by getting three more ul items, followed by three more details. How could I do this using a ListView or repeater? I have not found a way to repeat both of these sets of data I need in a group of three.[code]

View 1 Replies

Forms :: Grouping Controls Using Tag Or Name?

Feb 24, 2010

I am trying to group various controls (of the same type, e.g., labels together, buttons together, etc.) on a form using a tag or a name of some sort so I can identify all those that belong to tag 'A' and those in tag 'B'. In the end I will have on a form a number of labels grouped as tag 'A' and some labels as tag 'B' so I can change their visible properties on/off.

View 4 Replies

Grouping Applications In The TaskBar?

Sep 2, 2009

If a user has a few of my applications open and he/she minimises them I would like to group these in the task bar like MS Word for example.

Product Name - Application 1
Product Name - Application 2
Product Name - Application 3
Product Name - Application 4

Because all of my applications begin with the product in the Title bar can this be achived.

View 1 Replies

Grouping Code For Outlining?

Oct 1, 2011

I have multiple sub's that i'd like to group together, however all of the groups need to be in the same class. They all work together, but it would help me organize the code and make it less confusing if I could group some of the different subs together for outlining purposes. Is there a way to do this? I tried to find answers online, but I couldn't find what I was looking for.

View 3 Replies

Grouping Data From Two Dataset?

Mar 28, 2010

i've got a problem with dataset:

I've got two dataset from two different server but they have the same columns.
so it's like that:
First DataSet :

[code].....

View 2 Replies

Grouping Variables Within Classes?

Sep 8, 2009

I have a class called Trigger. within this class, I can perform a variety of functions, the main of which is to monitor a specific condition. In this class I have a bunch of class variables that are used to setup the condition as well as for information purposes after the condition has executed. All the conditions are stored in a database and when I start the program, I create a New Trigger class for each condition and store the variables (name, desc, action to perform once the condition is met, etc.) I was thinking about changing the class to create a Structure called Configuration where I would store all the variables. But then I would have to save the Configuration within the class so it could be used later on if needed correct?

[Code]...

but in looking at this i realized that I am creating a new structure and then creating a new trigger class where I am saving the Configuration structure which essentially seems the same as just using class variables as I was before. I also looked at creating a Configuration Class and a Trigger Class. then from the main class I would create all the Configurations and have a shared Trigger class that monitored all of them instead of having a single Trigger class for each Configuration. Using this method i could create a hash table that kept track of each configuration that was being monitored and stop it if required.

Does either method sound more appropriate over the other. I am just trying to understand when/why to do things a certain way.

View 4 Replies

ListView Control Grouping?

Feb 17, 2010

I did attempt searching but it just gave me a "505 bad gateway error".So my issues is the grouping header isn't working lol.

ListView1 - name of the ListView control
3 columns added to lv
3 items added to lv

[code].....

View 8 Replies

Repeater Grouping By Months

Jan 18, 2012

My repeater is searching through dates in the SQL Server database and returning the first 3 letters of every month. Is there a way to show the repeater the way I want to? [code]

View 2 Replies

VS 2005 ReportViewer Grouping?

Jan 5, 2010

I am making a report using the reportviewer. I have grouped the data and the group works. But when I try to put some data in the group header, I get the following error:The Value expression for the textbox Dep_Name refers to the field Dep_Name. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

The data I am trying to display is from a different table then the one that I am using to group the data. Does this mean there is a problem with the relationship between the tables?

View 10 Replies

Any Object That Supports Column Grouping

May 25, 2010

Is there any object that supports column grouping in VB.Net. Because I've been trying datagridview with no success.

View 3 Replies

DB/Reporting :: Grouping Rows In Datatable?

Aug 10, 2009

I am trying to summarize a datatable based on a primary column and then add certain columns. For example this table

col-1 col-2 col-3
1 AA 2
2 BB

[Code].....

This simply doesn't do anything becuase it thinks the target table doesn't have a primary key.

View 1 Replies

Exclude One Value From A Grouping Sum, Based On A Value Of Another Field?

Apr 9, 2009

How do I exclude one value from a grouping sum, based on a value of another field?ie I open Report=> Report Properties=>Code and insert my Custom Code, but how would I change the below code to exclude a numeric value of another field for the below case?

Public Function ChangeWord(ByVal s As String) As String
Dim strBuilder As New System.Text.StringBuilder(s)
If s.Contains("Others") Then

[code]....

View 1 Replies







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