Sort dataGridView colums in C# ? (Windows Form)

Question

Hello there, 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.

Any help ?

Answer 1

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

Answer 2

You can control the data returned from SQL database by ordering the data returned:

orderby [Name]

if u execute the SQL query from ur application so order the data returned.For example make a function that call the procedure or execute the SQL and give it a parametr that get the orderby criteria.Because if u ordered the data returned from database it will consume time but order it since it's executed as u say that u want it to be ordered not from the UI u want it to be ordered in the run time so order it when executing the SQL query

Answer 3

There's a method on the DataGridView called "Sort":

this.dataGridView1.Sort(this.dataGridView1.Columns["Name"],ListSortDirection.Ascending);

This will programmatically sort your datagridview.

Answer 4

dataGridView1.Sort(dataGridView1.Columns[0],ListSortDirection.Ascending);