Showing/Hiding different headers in Single Datagrid

J

John

Hi! Guys
I think some of you can help me here.
Here is the situation......

I have a following columns from different tables and
get a Dataset to Bind with a data grid.

1)ItemId int
2)FeatureId smallint
3)ItemName nvarchar(255)
4)ItemCategory
5)ItemPrice

and so on(not relavent here)

FeatureID =2
==> Best Selling Items
FeatureID =1
==> Best Value Items
FeatureID =0
==> Items


The reason for using a DataGrid is I want to Sort this
Dataset with different fields like Category and Price.

My default Dataset is always sort by featureid in descending order
so that I can have all the Best selling first, then Best value
items and then any Normal items.

My problem is I want to use a SINGLE grid
('casuse easier to handle pagining,sorting and coding)
and want to Display in default mode like

-------------- GRID 1---------------------------------
Best Selling Items
-------------------------------------------------------
Item Name ItemCategory ItemPrice QtyOnHand
-------------------------------------------------------
ITEMA CATEGORY_A $1.00 20
ITEMB CATEGORY_B $1.00 20


Best Value Items
-------------------------------------------------------
Item Name ItemCategory ItemPrice QtyOnHand
-------------------------------------------------------
ITEMA CATEGORY_A $1.00 20
ITEMB CATEGORY_B $1.00 20

Items
-------------------------------------------------------
Item Name ItemCategory ItemPrice QtyOnHand
-------------------------------------------------------
ITEMA CATEGORY_A $1.00 20
ITEMB CATEGORY_B $1.00 20

-------------- END OF GRID 1----------------------------

1)How can I code different headers in the same grid
2)When I sort to another field(e.g Price) all these
different header formatting should no longer be shown
and display in simple format like this

-------------- GRID 1---------------------------------
Items
-------------------------------------------------------
Item Name ItemCategory ItemPrice QtyOnHand
-------------------------------------------------------
ITEMA CATEGORY_A $1.00 20
ITEMB CATEGORY_B $1.00 20
ITEMc CATEGORY_B $2.00 20
ITEMz CATEGORY_B $4.00 20

-------------- END OF GRID 1----------------------------

Don't care about any feature(Best Selling/Value) just
in proper sorted field

Waiting for your replys
Your help is greatly appriciated.

Thanks,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,990
Messages
2,570,211
Members
46,796
Latest member
SteveBreed

Latest Threads

Top