Click here to Skip to main content
15,072,933 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

I have DB in Sql. I want to show this results in gridview ( or similar something)
Datagirdview shown us like excel pivot table. ( example is below)
Every result is will be coming in sql DB.( We dont know Rowcount or column count or row and Column Name. İt is changing according to DB. When i write to DB something, Row name can be change.) I hope ı explain. Help me please

Enking Domates 5
Enking Domates 5
Enking Domates 3
Enking Patates 5
Enking Patates 7
Enking Patates 7
King Domates 2
King Domates 9
King Patates 5
King Patates 7

Datagridview shown us like below.
--------Domates Patates
EnKing 13 19
King 11 12

1 solution

Hey Enkinger,

read my article[^] about dynamic pivots in sql

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900