i want to display the data in a grid view in a category wise

I assume this is for a Windows Forms desktop application; if not, then you should have created this thread in the forum relevevant to your application.
 
There are many ways to do this. One way is to bind your DataGridView and a combobox to your data, and when a new selection is made in the combobox, set the data sources's filter to the new value.

hi

just select all the data and make category wise ASC order in stored procedure and bind data to gridview.