sorting based on multiple columns in grid
we have one table which has column by name category_name in that some are parent and some are child categories.here only i have another column called parent_category where the entries describe the parent category(here category_id) of a particular category.
now my task is to sort all the categories which come under a particular parent seperately.(i think this is simlar to orderby and groupby clauses in sql which i want to do dynamically in grid(preferably in java script).
thanks in advance.