
i want to generate the dynamic table from A-table to B-table,by using normal C#,ADO.net is it possible?if it is, how we can write logic for this.
This article explains how to do what you are asking:
http://www.codeproject.com/Articles/44274/Transpose-a-DataTable-using-C
And this SO question is also answered quite nicely: