Sort dataGridView columns in C Windows Form

Question

I have a datagridview that i bind from an sql table  in that dv i have those attributes  Id  Name and Price  When i set the SortMode of the Name Columns to Automatic and i click on the header of this column i can sort this dv based on the first letter of the Name  this way i can order products based on their first letters   Acumulator  Boat  CocaCola  Engine etc     Is there a way this thing to happen without clicking the header of the column Name  I am looking some code that will do this job when the form will load

User · Answer

dataGridView1 Sort dataGridView1 Columns 0  ListSortDirection Ascending

User · Answer

There s a method on the DataGridView called  Sort    this dataGridView1 Sort this dataGridView1 Columns  Name    ListSortDirection Ascending     This will programmatically sort your datagridview

User · Answer

Use Datatable Default Sort property and then bind it to the datagridview

User · Answer

You can control the data returned from SQL database by ordering the data returned   orderby  Name    If you execute the SQL query from your application  order the data returned  For example  make a function that calls the procedure or executes the SQL and give it a parameter that gets the orderby criteria  Because if you ordered the data returned from database it will consume time but order it since it s executed as you say that you want it to be ordered not from the UI you want it to be ordered in the run time so order it when executing the SQL query

User · Answer

The best way to do this is to sort the list before binding data source   cars   cars OrderBy o   gt  o year  ThenBy o   gt  o color  ToList    adgCars DataSource   cars    Sorry for my bad english

User · Answer

This one is simplier     dataview dataview1   this dataview1  dataset tables 0  defaultview  this dataview1 sort     ColumnName  ASC   ColumnName  DESC   this datagridview datasource   dataview1

[c#] Sort dataGridView columns in C# ? (Windows Form)

Examples related to c#

Examples related to winforms

Examples related to datagridview

Examples related to sorting

Examples related to grid