When DataGridView is attached to a binding source that is linked to an EF4 Entity, how do you sort it?

c# datagridview entity-framework sorting winforms

Question

I have a DataGridView that is linked to a BindingSource.

My BindingSource is linked to an IQueryable list of entities:

    public void BindTo(IQueryable elements)
    {
        BindingSource source = new BindingSource();
        source.DataSource = elements;

        bindingNavigator1.BindingSource = source;
        dataGridView1.DataSource = source;

    }

I am wanting my users to be able to click on the grid headers to sort the data - struggling to get this to work. Is it possible? If so, how do I do it?

1
19
5/2/2013 2:14:23 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I recently struggled with this same issue; it seems that the IQueryable interface doesn't provide enough information for the DataViewGrid to know how to sort the data automatically; so you have to either repackage your collection from the Entity source using something it can use or do what I did and handle the sorting functionality manually:

      private void myDataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
  {
     DataGridViewColumn column = myDataGridView.Columns[e.ColumnIndex];

     _isSortAscending = (_sortColumn == null || _isSortAscending == false);

     string direction = _isSortAscending ? "ASC" : "DESC";

     myBindingSource.DataSource = _context.MyEntities.OrderBy(
        string.Format("it.{0} {1}", column.DataPropertyName, direction)).ToList();

     if (_sortColumn != null) _sortColumn.HeaderCell.SortGlyphDirection = SortOrder.None;
     column.HeaderCell.SortGlyphDirection = _isSortAscending ? SortOrder.Ascending : SortOrder.Descending;
     _sortColumn = column;
  }

I hope that helps.

12
12/16/2010 5:38:21 PM

Popular Answer

This code snippet works very well, and fast enough for most purposes...

int iColNumber = 3; //e.g., sorting on the 3rd column of the DGV

MyBindingSource.DataSource = MyBindingList.OrderByDescending(o => o.GetType().GetProperty(MyDataGridView.Columns[iColNumber].Name).GetValue(o));
islandTrader

Related Questions

Using C# to connect Entity Framework objects to a Datagridview

The problem with the line:...select new { c.UserName, c.Password, c.Description } ...Is that it is creating an ...anonymous type..., and anonymous types are immutable - that is read only. This is why your changes do not get reflected in either the new type or in the original EF object....Now, as for ways of not showing all the columns of the object...
c# data-binding datagridview entity-framework winforms
asked by David Hall

How to bind entities from Entity Framework to DataGrid?

Instead of DataContext, set ...ItemsSource... to the result set....gridMessages.ItemsSource = result; ...Note... Since you're new to WPF, you might want to note that MVVM is better than the approach here, for separating UI from business logic. To use an MVVM approach, you'd set your Window's ...DataContext... to some View Model class:...private vo...
ado.net data-binding entity-framework wpf
asked by McGarnagle

datagridview binding to entity not updating database

I am populating a grid from a entity object and it is displaying the data fine. When I make changes and save it back, nothing is updating....Here is my code:...In my load event:... var query = from c in _entities.PaymentTypes where c.CorporationId == _currentcorp.CorporationId select new DataBindingProje...
c# datagridview entity-framework winforms
asked by ErocM

Best approach to bind a datagridview to database entity/ies

So, in order to explain my thoughts better I'll write an answer (as it doesn't restrict me with the character count) but I want to make it clear that I only add my thoughts about how your initial code could be made better and not how it must be done. Having said that let's get into the topic. I'll start with ...Step 2) Create an object that repres...
.net c# entity-framework winforms
asked by Leron_says_get_back_Monica

How to bind WinForms' DataGridView to EF navigation property (collection) in master-detail scenario?

I have found the solution to the problem....The thing is that ...DataGridView... can't bind to ...ICollection<Receipt>... so the solution was to change the navigation property to ...BindingList<Receipt>.... Then the designer showed the property correctly.
bindingsource data-binding datagridview entity-framework-6 winforms
asked by Kornelije Petak

Entity Framework DataGridView binding source

You should be able to do something like this:...public class DataBindingProjection { public string StudentName { get; set; } public date DateOfBirth { get; set; } public string Height { get; set; } public string Weight { get; set; } ... etc. public string StandardName { get; set; } ...In your Load() or OnClick():...var quer...
c# datagridview entity-framework-6
asked by Steve Greene

Getting error "The parameter was not bound in the specified LINQ to Entities query expression."

The exception message indicates that the ...dateSelector... parameter has not been rebound correctly. Since there is third party package involved, I can't tell what is causing it. ...But I guess this is related to your ...previous question.... I was going to suggest you another simple manual expression building based working solution not involving ...
c# entity-framework entity-framework-6 linq linq-to-entities
asked by Ivan Stoev

Bind list of objects to cell in datagridview

If I format the data before I bind it I will have to create another object like a view of simple properties, so it's another layer of objects for all my complex entities that I will show. I can't just use a simple linq expression on them as it uses anonynous objects (any other way?) which then means those columns are read only....Now for handling e...
c# datagridview entity-framework-6 formatting winforms
asked by indigo

How Can I Bind Data To DataGridView With EntityFramework In WPF

i have used Store Stored Procedure in my database (SQL Server)...select namebuffet,namefamilymember,idmember,Sum(finalpricefactorbuffet)-Sum((delivery*30)/100) as Price from Buffet_factorbuffet Inner join Buffet_buffet on idbuffet=buffetidfactor Inner join Member_member on idmember=memberid inner join Buffet_banktransaction on factorid=idfact...
c# data-binding entity-framework-6 wpf wpf-controls
asked by Leonardo

Bind Data to Specific Columns of Datagridview - Entity Framework

I don't know if I should take all the data or just the one I need :) I am doing it for the first time. I want to bind this data to Specific columns...See select...var SQLquery = (from artikel in db.DHH_Lagerverwaltung_Artikel join hersteller in db.DHH_Lagerverwaltung_Hersteller on artikel.ID_Hersteller equals hersteller.ID_Hersteller join kategorie...
c# entity-framework entity-framework-6
asked by Thomas

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow