We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Exporting A DTS to Excel as snapshot

Thread ID:

Created:

Updated:

Platform:

Replies:

27101 Apr 6,2005 01:35 PM UTC Apr 9,2005 08:50 AM UTC Windows Forms 4
loading
Tags: XlsIO
Mohammad Abdullah
Asked On April 6, 2005 01:35 PM UTC

Hi, If I have a (DTS) sql server 2000 package that bring a dataset , I want to import this (DTS) package to Excel file , the Excel file take it is design from another template file , can you provide me by an example about this operation. Note: Provide your example by (C# . Net). Thanks

Mohammad Abdullah
Replied On April 6, 2005 01:36 PM UTC

I want the code without any looping operations , if there is a loop with data that has around (10000) records this will cause a response time problem.

Administrator [Syncfusion]
Replied On April 6, 2005 08:52 PM UTC

Hi Muhammad Why do you don''t perform the export directly in the DTS, because you have there the possibility to export the data to Excel. Regards Thomas >I want the code without any looping operations , if there is a loop with data that has around (10000) records this will cause a response time problem.

Administrator [Syncfusion]
Replied On April 7, 2005 06:33 PM UTC

Hi Muhammad, We have an ImportDataTable method that would do that, but it would internally loop thro the 10000 rows. IWorksheet.ImportDataTable() //The imported datatable data will start from [1,1] in the spreadsheet. mySheet.ImportDataTable(GetTable(),true,1,1); Thanks, Stephen. >Hi Muhammad > >Why do you don''t perform the export directly in the DTS, because you have there the possibility to export the data to Excel. > >Regards >Thomas > >>I want the code without any looping operations , if there is a loop with data that has around (10000) records this will cause a response time problem.

Mohammad Abdullah
Replied On April 9, 2005 08:50 AM UTC

Thank you so much stephen , no one gives me this good answer before , I asked this question around 10 times before no body gives me a good and enough answer like you. Thanks again

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;