Problem in sorting Datagrid

[happyheartcs]

Hope u r all fine :) I have a problem concerning sorting in a datagrid. I have a bound column that gets its value from 2 database fields -FirstName & LastName- When I write in the sort expression of that column "FirstName" it sorts properly but when I write "FirstName,LastName" it doesn't sort.. So how can I sort using these 2 columns together?? Thanks a lot in advance

[_AK_]

You cant sort the data in the database with two columns. Alternatively what you can do is make the combination of the two columns and then in sort it there in temporary sorage such as dataset.

Best Regards, Apurva Kaushal

[VishalSharmaDev]

try to use dataview for sorting...

Thanks & Regards Vishal Sharma vishalsharma556@yahoo.co.in