Solved

Export Data to excel sheet and format the data

Posted on 2009-04-08
1
280 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now