grouping

WPF CollectionViewSource Grouping

I'm using a Collection View Source to group my data. In my data, I have Property1 and Property2 that I'm needing to group on. The only stipulation is that I don't want sub-groups of another group. So, when I group by these two properties, I don't want to have it so that Property2 because a subgroup of Property1's group. The reason why...

SQL: Expand 1 Column into 3 on Summarize Table

I'm writing a program that displays products and the stores at which they can be located. So far, I've been able to write an SQL query that displays data as follows: Product Availability Milk Store1 Candy Store1 Eggs Store1 Milk Store2 Eggs Store2 Candy Store3 Eggs Store3 Is there any SQL qu...

Silverlight binding in a DataGridRowGroupHeader doesn't update when DataSource changes

I have a Binding in a inline style for the DataGridRowGroupHeader like this. <sdk:DataGrid.RowGroupHeaderStyles> <Style TargetType="sdk:DataGridRowGroupHeader"> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="sdk:DataGridRowGroupHeader"> <TextBlock Margin...

WPF ListView Grouping specification for one row

I'm studying the sample from MSDN(http://msdn.microsoft.com/en-us/library/ms771309%28VS.90%29.aspx) which makes all the records expanded in groups. Is that possible that if there is only one record in a group, then the row can not be expanded and also the toggle button and the whole expander head are not visible. ...

Very complex Group By / Unique / Limit by SQL-command

Hi there, I actually don't even know how to call this :P, but... I have one table, let's call it "uploads" id owner date ----------------------------- 0 foo 20100101120000 1 bar 20100101120300 2 foo 20100101120400 3 bar 20100101120600 .. .. .. 6 foo 20100101120800 Now, when ...

WPF Grouping a DataGrid nested in databound tabs

I need to apply grouping to rows in a DataGrid that is nested in a TabControl. Both the DataGrid and the TabControl are databound. The outermost control is bound to a ViewModel that exposes a collection of pages that is bound to the TabControl. Each page exposes a collection of lines that is bound to the Grid. I am tried to follow patt...

Split a collection into parts based on condition with LINQ?

I want to achieve something similar to this. But I don't know in what manner I can use that solution. My entity has these properties CustomerName Date SortOrder I've whole list of this Entity. What I want to do is, group all those items in List<> which have consecutive SortOrder and same Date and same CustomerName Example input v...