to view Sql Result in Datagridview like pivot table how excel shown us.

See more:

C#

SQL-Server

SQL-Server-2008

, +

Hi,

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