Show data According to Row heading and column heading [Resolved]

Posted by Shivu under C# on 12/26/2011 | Points: 10 | Views : 829 | Status : [Member] | Replies : 3
I want bind data as below


Shop A| Shop B| Shop C | Shop D |....
---------------
Product A 2 1 0 1
Product B 0 1 2 0
Product C 5 0 0 0

Where as I'm getting as

Shop A | Product A| 2
Shop A | Product B| 0
Shop B | Product C | 0
From database

Thank you




Responses

Posted by: Sksingh on: 12/26/2011 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi,

You can get your expected result by using PIVOT concept.
refer http://msdn.microsoft.com/en-us/library/ms177410(v=sql.90).aspx

Regards,
Sunil

Shivu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shivu on: 12/26/2011 [Member] Starter | Points: 25

Up
0
Down
Still I want some example how to add data dynamically, Because in Shop list I have 30 shops , and 156 products. More over data will be changing dynamically

Shivu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksingh on: 12/26/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

In case of dynamic data do not work on object, work directly with DB so whenever any records get insert or updat, PIVOT data will return from DB that will be updated data.

Regards,
Sunil

Shivu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response