Creating pivot table

[Abhinav Singh]

Hi,
Earlier i use to make reports in excel but now i got a task of displaying it on a web page and in a pivot table format.I use SQL 2008 as backend and visual studio to create the web page .I need the code in asp.net.



Thank you
Abhinav

[Frinavale]

Abhinav,

Welcome to Bytes!

The experts here will be more than happy to give you a hand with your problem but you have to demonstrate an attempt at implementing the solution so that they can help you find a solution.

I'm not sure what you are stuck on in particular so I recommend that you open Visual Studio and go through the tools available for you to use in ASP.NET that will help you to accomplish what you need to do.

One tool that I think you will be very interested in using is the GridView control. It displays data to the user in a Grid format and provides functionality that allows users to sort the data, select records, edit/delete records etc.

Another control that you might be interested in is the Repeater.

It's pretty hard to help you when your question is so vague and large.

So, look through the tools you have available and try to use them to implement your solution.

If you have problems understanding how to use a tool, consult the MSDN Library for help first...and if you're still stuck ask here for help.

-Frinny

[Abhinav Singh]

Thank you frinny,

I am implementing the data from SQL and want to project that on a webpage in a pivot table format .But as it is there is no tool in Visual studio for pivot table .

[Frinavale]

You are correct, there is no tool that will create a pivot table for you.

You will have to use tools like the GridView or the Repeater, combined with logic to create your pivot tables.

-Finny