Solved

WPF DataGrid, sorting does not work

Posted on 2011-03-10
12
1,341 Views
Last Modified: 2012-05-11
Hi all,

I have the following data grid which I populate based on the data in tblData.

<DataGrid Name="gridTasks" ItemsSource="{Binding tblTasks}" CanUserSortColumns="True"/>

When I click the column headers, the grid doesn't sort. I originally had a grid with manually defined columns etc. and figured that's where the problem might be, but even after scaling back to this very basic form, I still can't sort.

I'm using ADO.NET as my data source. Data displays properly but sorting doesn't work. Really appreciate your help!

Regards,
Greenway
0
Comment
Question by:greenwaymgmt
  • 7
  • 5
12 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 35110333
It is pretty easy to sort, with the property setting, so it might be a problem with:

1) The version of WPF that you are using

2) The DataGrid binding source
0
 

Author Comment

by:greenwaymgmt
ID: 35132213
Okay, I'll start with checking if I have the latest version of WPF...
0
 

Author Comment

by:greenwaymgmt
ID: 35160235
Updated to the newest version of Visual Studio, still not working. How can I go about checking what the problem is with the binding source, please?
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:greenwaymgmt
ID: 35160729
Here's basically how I go about things:

public db as DataEntities
datagrid.itemssource = db.table

still, sorting doesn't work. Any ideas?
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 35161560
I don't see how this is working, since you are binding to "tblTasks", but I don't see any reference to that.  That looks like you are working with Entity Framework generated classes, but that is just a guess.
0
 

Author Comment

by:greenwaymgmt
ID: 35165372
Hey, sorry yes I am working with Entity Framework generated classes. The datacontext of my entire page is one entry in a master table that has several tasks attached to it in tblTasks. In the first post to this question I explained my original problem, that binding through XAML did not work with sorting. I then investigated further and realized I couldn't even bind the Entity Framework generated classes directly and have sorting work. db.table = db.tblTasks in the above comment.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 35169554
I am confused, is sorting working or not working?
0
 

Author Comment

by:greenwaymgmt
ID: 35175824
sorting is not working
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 35175963
Can you create a BindingList(Of T) from the entity set?

Example:

Dim employeeList As New BindingList(Of Employee)(Me.DataContext.Employees.ToList)

Open in new window

0
 

Author Comment

by:greenwaymgmt
ID: 35183104
I tried that, but then I can't make simple queries such as:

employeeList.Where(Function(f) f.Status= "Active")

In addition, instead of accurately displaying the data. The grids now appear all black, with no visible data.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 35185671
I finally got around to trying some different experiments, and I believe that I have what you need:

1) Return the ObjectSet(Of Entity), and the sort doesn't work

2) Return a List(Of Entity), and the sort appears to work.

Example:

Imports System.Collections.Generic
Imports System.Linq
Imports System.Text
Imports System.Data.Objects

	Friend Class DataLayer

		Private _entities As AdventureWorksEntities

		Public Sub New()
			_entities = New AdventureWorksEntities()
		End Sub

		Public ReadOnly Property Products() As List(Of Product)
			Get
				Return _entities.Products.ToList()
			End Get
		End Property

	End Class

Open in new window

0
 

Author Comment

by:greenwaymgmt
ID: 35190537
That worked! Thanks a lot for your help!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question