Solved

Export Data to excel sheet and format the data

Posted on 2009-04-08
1
282 Views
Last Modified: 2012-05-06
Hi,

How can I export data to excel sheet and then style the excel sheet.

        If Page.IsPostBack Then

            dsUsers = df.ExeDBCmdParamReturnDS("rpt_Detail_General_Ledger_User", _
            df.MakeParam("@Acct", TxtAccount.Text, SqlDbType.Char, 10), _
            df.MakeParam("@SubAcct", TxtSub.Text, SqlDbType.Char, 24), _
            df.MakeParam("@PerEnt", TxtDate.Text, SqlDbType.Char, 6), _
            df.MakeParam("@SortBy", DLSort.Text, SqlDbType.Char, 24))

'here I have to export the data from the stored procedure to the excel sheet.


        End If
0
Comment
Question by:lulu50
1 Comment
 
LVL 16

Accepted Solution

by:
sunithnair earned 500 total points
ID: 24098866
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question