I Am Having One Problem To Show The Data From Database Let Me Explain Clearly
My Table Data Is As Below
| Name | Product | Section | Qty |
| Harish | Product1 | 125% | 2 |
| Ganesh | Product2 | 125% | 3 |
| Harish | Product2 | 100% | 2 |
| Ganesh | Product1 | 100% | 2 |
| Harish | Product1 | 75% | 4 |
| Ganesh | Product2 | 75% | 3 |
In My Database The Data Is Stored As Above, Now I Need To Show It As Below Irrespective Of Controls.
| Product1 | Product2 | |||
| Name | 125% 100% 75% | 125% 100% 75% | ||
| Harish | 2 --- 4 | --- 2 --- | ||
| Ganesh | --- 2 --- | 3 --- 3 | ||
This Is How I Should Show The Data Irrespective Of Any Control Please Suggest Me The Concept How To Do it iF Possible Means Please Give Me a Example, I Can Show Data In Any Control Whichever you People Suggest Me But Client's Requirement Is As Above So Can Anybody Help Me To Do So ?
Rahul BansalPosted Feb 5, 2015, 6:06 AM
http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query