>I am using Index for sorting the grid. But now i want to sort fieldwise with Ascending Descing options. Index on doesnot support fieldwise Ascending/Descending options. So is there any other way to sort the grid?

Specify Asc or Desc when setting the order, look at all the SET ORDER clausees.