In my grid I have 4 columns. Name, Phone, Address and Sales Person. While getting information from SQL, I am getting first 3 columns in one query and fourth column in second query. Order of grid should be by default alphabetically from column "Name". But it is showing in order of Sales Person. If I dont run the second query to get sales person information, my order is according to Name (i.e. first Column).
Is there anyway that I can set the default order for Column "Name" and also at the same time when someone click on any other column, order of grid should change according to that (which is working now as well).
In brief, when grid loads for first time it should be in alphabetical order of column Name and not column Sales person at the same time it should still allow user to change order by clicking on any of the columns headertext.