how to print data from gridview using help of combo box

See more:

ASP.NET

VS2010

SQL-Server-2008R2

Hi
I have 1 table name inventory. the fields I have are serial number,category,description, image, cost price, selling price.

Now in search bar, the user selects from drop down box, search by category.

the categories entered are earrings,bracelets,necklaces etc.

if user want all the earrings data entered so far to get it printed in crystal report or directly from grid view, how to do so?

i created crystal report, i did even group by category. but in that case 1st group earrings getting printed, then bracelets etc.

i dont want to be printed like that.

if user selects one single category earrings, that earrings details or data should be printed.

Can anyone help me?

I have already searched many links.

if any one can provide me the way to do so.

Thanks
Sudeshna