how do I Display linq query result in a listview from a combobox

Question

0.00/5 (No votes)

See more:

The closest answer I got was this Question.

https://social.msdn.microsoft.com/Forums/en-US/00336aa4-0895-4c4d-b1e5-380bbdffd961/display-linq-query-result-in-listview?forum=wpf[^]

so far either only Linq queries are getting displayed or nothing. I have tried a lot of different coding but can't seem to figure this out.

XML

public struct PIDData
        {
            public long PIdentity { get; set; }
            public string PName { get; set; }
            public string PPrice { get; set; }
            public string PSerial { get; set; }
            public string PDescription { get; set; }
            public string PType { get; set; }
            public string PPosition { get; set; }
            public Binary PImage { get; set; }
        }


       //Binding combobox
             using (DataClassesDataContext DC = new DataClassesDataContext())
           {
               cbItem.Items.Clear();
               foreach (tblProduct R in DC.tblProducts)
               cbItem.Items.Add(R);
               cbItem.DisplayMemberPath = "ProductName";
           }

        //Combobox Selection changed
           List<string> items = new List<string> { cbItem.SelectedItem.ToString() };

            IEnumerable<string> query = items.Where(item => item.ToString() != null);
            lvDataBinding.Items.Add(items);


            txt1.Text = items.ToString();

//Xaml
  <ListView Margin="338,20,1,16" Name="lvDataBinding">
            <ListView.View>
                <GridView>
                    <GridViewColumn DisplayMemberBinding="{Binding PName}">
                        <GridViewColumnHeader Tag="Product Name" Width="100">Product Name</GridViewColumnHeader>
                    </GridViewColumn>
                </GridView>
            </ListView.View>
        </ListView>
        <ComboBox x:Name="cbItem" HorizontalAlignment="Left" Margin="13,315,0,0" VerticalAlignment="Top" Width="321" SelectionChanged="cbItem_SelectionChanged"/>

Posted 15-Apr-15 22:45pm

RenaldoGG

Updated 15-Apr-15 23:01pm

v2

Add a Solution

Comments

Michael_Davies 16-Apr-15 4:58am

Show the code that is not working, otherwise just guessing.

RenaldoGG 16-Apr-15 5:03am

sorry I am not sure where the problem is, if it is my binding of data.

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)

CareTaker222 · Accepted Answer · 2015-04-16T02:35:00

This will help you out my friend:

XML

private void cmbSelectProduct_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
    PIDData PID = (PIDData)cmbSelectProduct.SelectedItem;
    List<string> items = new List<string> { PID.Name };

    items.Where(item => item.ToString() != null).ToList().ForEach(i =>
    {
        lvAddProducts.Items.Add(i);
    });
}

Andy Lanng · Accepted Answer · 2015-04-15T23:20:00

Here is the issue:

Quote:
lvDataBinding.Items.Add(items)

The Items.Add method will create a new single item and will display the GetString().

You need to use Items.AddRange for groups of items, but not all collections support this.

A quick shortcut is to cast your query as a list and cann ForEach():

C#

...
//Combobox Selection changed
           List<string> items = new List<string> { cbItem.SelectedItem.ToString() };
 
            items.Where(item => item.ToString() != null).ToList().ForEach(i=>
            {
              lvDataBinding.Items.Add(i);
            }
 
            //What is this supposed to do?  collection.ToString() will, by default, return GetType().ToString().  That'll look like "System.Collections.List<string>" or similar
            txt1.Text = items.ToString();

            //You will need to get the string of a single item, or join a range of items strings.  There are many ways to do this
            string.Join(", ",items); //is one way of comma separating the values
...

how do I Display linq query result in a listview from a combobox

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0