how to convert data to obsevable collection linq

Question

4.00/5 (1 vote)

See more:

database is like this

item_id		int
list_name	string
category_name	string
item_name	string
qty		int
price		double
total_amt	double

i am trying to get item list according to category..(group by & sum)

C#

 private ObservableCollection<shoppingitem> _purchased;
        public ObservableCollection<shoppingitem> Purchased
        {
            get
            {
                return _purchased;
            }
            set
            {
                _purchased = value;
                notifypropertychanged("Purchased");
            }
        }
public void  budgetcategorywise()
        {


           
            var q = from shoppingItem p in db.Item1
                    group p by p.category_name into g
                    select new { category = g.Key, total = g.Sum(p => p.total_amt) };

	    Purchased=new ObservableCollection<shoppingitem>(q);
	}

it is giving error of type casting.
now the problem is how i should bind this result to listbox.
it requires conversion..?

i need to convert the result in observablecollection to bind with listbox..

Posted 31-May-12 19:28pm

jinalshah9999

Updated 31-May-12 19:34pm

Mehdi Gholam

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)

Unareshraju · Answer 1 · 2012-05-31T20:40:00

this is syntax to convert type casting...this may helps to u.

XML

public static class ObservableExtensions
    {
        public static ObservableCollection<T> ToObservableCollection<T>(this List<T> items)
        {
            ObservableCollection<T> collection = new ObservableCollection<T>();

            foreach (var item in items)
            {
                collection.Add(item);
            }

            return collection;
        }
    }

Unareshraju · Answer 2 · 2012-05-31T20:56:00

pls try like this

XML

private ObservableCollection<shoppingitem> _purchased;
        public ObservableCollection<shoppingitem> Purchased
        {
            get
            {
                return _purchased;
            }
            set
            {
                _purchased = value;
                notifypropertychanged("Purchased");
            }
        }
public static class  budgetcategorywise()
        {
            var q = from shoppingItem p in db.Item1
                    group p by p.category_name into g
                    select new { category = g.Key, total = g.Sum(p => p.total_amt) };
        
           ObservableCollection<q> collection =new ObservableCollection<q>();
{
foreach( var shoppingItem in shoppingItems)
{
collection.Add(shoppingItem);
}
}
return collection;
      }

how to convert data to obsevable collection linq

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0