المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Cross Tab Data



C# Programming
07-25-2009, 11:22 AM
Hi experts
I am using SQL Server 2005
I have Table Having Str. like
__________________________
Heading | Tax
__________________________
A | Taxx
A | Taxz
A | TAXN
B | 10
B | 20
B |30
C |5
C |5
C |4
_____________________________
i Want Result
like
--------------------------------
A B C
----------------------------------
TaxX 10 5
TaxZ 20 5
TaxN 30 4
--------------------------------

this Result in Datagrid view in WinForms
How i get it in Datagrid view
my column A,B,C ,D ..... so on Dynmaic
Dinesh