Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3782
Home > Forums > C# >

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

Posted by Shivu under C# on 12/26/2011 | Points: 10 | Views : 1896 | Status : [Member] | Replies : 3
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
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



Reply | Reply with Attachment
Alert Moderator 

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

Latest Posts