sort DataGridView and error DataGridView control must be bound to an IBindingList object to be sorted

Question

0.00/5 (No votes)

See more:

hi i want to sort dataGridView when user click on header column i do it :

C#

dgvList.DataSource = (_db.UserProfiles
                   .OrderBy(r => r.Family)).ToList();

C#

private void dgvList_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
       {
           foreach (DataGridViewColumn column in dgvList.Columns)
           {
               column.SortMode = DataGridViewColumnSortMode.Programmatic;
           }

       }

       private void dgvList_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
       {
           try
           {


               DataGridViewColumn newColumn = dgvList.Columns[e.ColumnIndex];
               DataGridViewColumn oldColumn = dgvList.SortedColumn;
               ListSortDirection direction;

               // If oldColumn is null, then the DataGridView is not sorted.
               if (oldColumn != null)
               {
                   // Sort the same column again, reversing the SortOrder.
                   if (oldColumn == newColumn &&
                       dgvList.SortOrder == System.Windows.Forms.SortOrder.Ascending)
                   {
                       direction = ListSortDirection.Descending;
                   }
                   else
                   {
                       // Sort a new column and remove the old SortGlyph.
                       direction = ListSortDirection.Ascending;
                       oldColumn.HeaderCell.SortGlyphDirection = System.Windows.Forms.SortOrder.None;
                   }
               }
               else
               {
                   direction = ListSortDirection.Ascending;
               }

               // Sort the selected column.
               dgvList.Sort(newColumn, direction);
               newColumn.HeaderCell.SortGlyphDirection =
                   direction == ListSortDirection.Ascending ?
                  System.Windows.Forms.SortOrder.Ascending : System.Windows.Forms.SortOrder.Descending;

           }
           catch (Exception ex)
           {

               MessageBox.Show(ex.Message, "خطا!", MessageBoxButtons.OK, MessageBoxIcon.Error);
           }
       }

when i click on header columns give me error:

DataGridView control must be bound to an IBindingList object to be sorted

now what can i do?

Posted 8-Jun-14 23:24pm

NorouziFar

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Alexander Sharykin · Accepted Answer · 2014-06-09T01:54:00

According to MSDN InvalidOperationException is thrown when
The object specified by the DataSource property does not implement the IBindingList interface.

C#

// example 1 (from the question)
dgvList.DataSource = _db.UserProfiles.OrderBy(r => r.Family).ToList();

-or-
The object specified by the DataSource property has a IBindingList.SupportsSorting property value of False.

C#

// example 2
var list =_db.UserProfiles.OrderBy(r => r.Family).ToList();
var bs = new BindingSource();
bs.DataSource = list;
dgvList.DataSource = bs;

you can look at a possible solution on StackOverflow
http://stackoverflow.com/questions/4702014/sorting-datagridview-datasource-on-listt-where-t-is-anonymous[^]

sort DataGridView and error DataGridView control must be bound to an IBindingList object to be sorted

1 solution

Solution 1

Add your solution here

Preview 0

sort DataGridView and error DataGridView control must be bound to an IBindingList object to be sorted

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us