C # Winforms DataGridView with sorting / filtering like Ms Excel

Question

Hey. I need a quick solution for filtering / sorting using a Winforms DataGridView control, as in Excel.

I looked through existing posts in this area, but not one of them fits my needs.

I manually populate my DataGridView - data binding

Answer 1

DataGridView columns already support sorting.

I would populate the DataTable with your data and bind the DataGridView to myDataTable.DefaultView.

You can filter the rows displayed by setting myDataTable.DefaultView.RowFilter.

/ DataGridView myDataTable.DefaultView.RowFilter /.

Answer 2

Excel , : http://msdn.microsoft.com/en-us/library/aa480727.aspx

Answer 3

? , . DataGridView , . , AutoFilter Excel.

Answer 4

Microsoft has created an example project for VB and C # where they show how to create an "autofiltration" plugin. I personally don’t like it, since it allows you to filter exactly so that the product and the client work, open an account where the price> some cost is not realized

Sorting is done using:

foreach (DataGridViewColumn column in MyDataView.Columns)
{
      column.SortMode = DataGridViewColumnSortMode.Automatic;
}

You do this when the grid has columns, if you automatically create columns ... after binding.