bind group by result to listbox in wp7

Question

4.00/5 (1 vote)

See more:

my table is look like this
1)Item_table:

id
list_name
category_name
item_name
price
qty
amount

i want to display it like this

category_name (count)

item1 qty price
item2 qty price

category_name (count)

item1 qty price
item2 qty price

till now i had tried listbox design:

HTML

<ListBox x:Name="listbox_all_items" Width="440">
                        <ListBox.ItemTemplate>
                            <DataTemplate>
                        <TextBlock Text="{Binding category_name}"></TextBlock>
                        <TextBlock Text="{Binding item_name}" FontSize="28"></TextBlock>
                        <TextBlock Text="{Binding qty}" FontSize="24"></TextBlock>

                                </Grid>
                            </DataTemplate>
                        </ListBox.ItemTemplate>
                    </ListBox>

C#

public void itemlist()
    {

    var query = from shoppingItem w in db.Item1
                    group w by new { w.category_name } into g
                    select new { category = g.Key.category_name, g };
    }

but how should I convert query variable to list so that i can bind it listbox.

Posted 7-Jun-12 4:53am

jinalshah9999

Updated 7-Jun-12 9:07am

Sandeep Mewara

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Clifford Nelson · Answer 1 · 2012-06-19T19:56:00

I am a little confused by the quesiton, but I there is a very easy way to convert a LINQ query result to a list and that is to use the ToList() method.

The technolgy looks a lot like WPF or Silverlight. That means that you will have to set the ItemsSource for the ListBox to an IEnumerable of the class that contains the collection of objects with the properties category_name, item_name, and qty. This means that I am a little confused about the group by query. You don't need because you need tha category name. What I think you need is:

C#

var query = from shoppingItem in db.Items
                    select new { shoppingItem.category_name, 
                                 shoppingItem.item_name,
                                 shoppingItem.qty};

Pardon errors due to me not knowing everything about your problem.

susmithamaddula · Answer 2 · 2012-11-27T01:27:00

Solution 2

You can get IEnumerable as a result of query expression.

You can directly assign this to itemsource of listbox.

For your requirement LongListSelector suits. Try Toolkit Longlistselector.

Posted 27-Nov-12 1:27am

susmithamaddula