how to inforce sorting on datagrid before populating

  • Thread starter Thread starter Adel
  • Start date Start date
A

Adel

Hello guys
Does any one know about how to inforce sorting on a
specific coloumn in a datagrid before populating it ?
Thanks in advance
 
Use an ORDER BY clause in your SQL query so that your
query results will be ordered the way you want before you
populate the datagrid.
 
Try something like this (for the DataTable or DataView) to control the sort
by code. I do this after the datasource has been bound.


dataTable1.DefaultView.Sort =
dataTable1.DefaultView.Table.Columns[0].ColumnName;
dataView1..Sort = dataView1.Table.Columns[0].ColumnName + " DESC";


HTH,
Eric Cadwell
http://www.origincontrols.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interface vs memebers 4
Making a process faster 7
how to format datagrid coloumns header text 1
Update SQL Table Data using DataGrid 1
setting the combo box value in windows form 1
Is there a program or plug-in that does this? 4
adding values to a Datagrid 4
Header name in datagrid 1

Back
Top