Sorting Data of Data Grid Control

Khan Bangash

Hi all, I have developed in asp.net with vb.net. There is a Data Grid on that page. I bring Data from Different tables to this Data Grid. Now I want to sort the data of this Data Grid. Is it possible ? If yes then how ? Any Example ? Pls Help its very urgent. Thanks in Advance.

jcdevnet

Actually what you can do is sort the actual table, you can either provide a sort expression on the default view of the of the DataTable and bind your DataGrid to that view using the DataSource property of the DataGrid

Greets! Joel

sathesh pandian

you can use dataview to sort the records. assign the table.defaultview with the dataview. Then you can sort it with the column name. dim dtview as new dataview=table.defaultview dtview.sort(columnName)

All The Best Sathesh Pandian

Khan Bangash

Dear Actually I have a Data Grid and its different columns are set by different functions. For example first column is set by func1,2nd column is set by func2, similiry other columns are set by different functions. Now there is a column Customer Name, I want to sort this Data Grid with the help of this column. Is there any method with the help of which I can sort it. I want to sort this Data with the Data Which is in this Column, not with Data base table. How is that possible.

Deepak the Cool

If u can create the stored procedure into DB and use join query for all records thn use the order by clause for that. hope that'll help u.

Deepak Smile a Lots,Its Costs Nothing