cannot bind datagrid to list

Question

0.00/5 (No votes)

See more:

I am trying to show the contents of list in datagrid when an event is raised. See the code below

List<string> mlw = new System.Collections.Generic.List<int>();<br />
mlw.Add("qwe1");<br />
mlw.Add("qwe2");<br />
mlw.Add("qwe3");<br />
mlw.Add("qwe4");<br />
mlw.Add("qwe5");<br />
dataGrid1.ItemsSource = mlw;</int></string>

What I see the result I can see the space for 5 rows with "4" written in each of it

Posted 3-Jul-11 22:35pm

Muhammad Waqas Iqbal

Add a Solution

1 solution

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)

Wayne Gaylard · Accepted Answer · 2011-07-03T23:06:00

Solution 1

The way WPF binding works, it tries to bind to a property of the object in the list. If one is not specified, then it will use the first property it finds (for strings this is the Length property). To get around this, I use LinQ and an anonymous type, something like this

C#

List<string> mlw = new List<string>(){"qwe1","qwe2","qwe3","qwe4","qwe5"};
           var values = from str in mlw select new { value = str };
           dataGrid1.DataContext = values.ToList();

and this will show the actual string value

This is the xaml declaration

XML

<DataGrid Name="dataGrid1" Grid.Row="4" ItemsSource="{Binding}" AutoGenerateColumns="True"/>

Hope this helps

Posted 3-Jul-11 23:06pm

Wayne Gaylard

Comments

Wayne Gaylard 4-Jul-11 6:09am

Hi, the code I posted is already in c#. Here http://msdn.microsoft.com/en-us/library/ms750612.aspx is the link for MSDN WPF binding page. Good Luck!.

Muhammad Waqas Iqbal 4-Jul-11 6:20am

thanks for ur solution,
what to do if I want to bind to datagrid to sqldatareader? Do I need to extract all the sql data and put it in some var like in the above example?

Wayne Gaylard 4-Jul-11 6:31am

In the case of data readers, I would suggest that you create a collection first, fill the collection from the data reader, close the data reader, then bind to the collection. Hope that helps

Muhammad Waqas Iqbal 4-Jul-11 6:51am

Thanks again,
Hope I am not bothering you. Can you name any collection to store 15 column result from sqldatareader? If possible, send me the written code as you did in the above case. Also can dataset be used in such a case?
Regards,
Waqas

Wayne Gaylard 4-Jul-11 7:02am

You need to create a Class that has properties that correspond to your database fields. Then you can use a datareader to convert the db fields to your class type, adding each one to a collection as you go. I am afraid I am too busy to write the code. I am sure you are up to it. Good Luck!

Muhammad Waqas Iqbal 4-Jul-11 7:42am

So nice of you,
Good luck to you in your work
Bye,