Click here to Skip to main content
15,896,329 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralIIS 7 VISTA problam Pin
galigal153-Feb-08 19:46
galigal153-Feb-08 19:46 
GeneralMasterPage and Javascript Pin
trilokharry3-Feb-08 18:52
trilokharry3-Feb-08 18:52 
GeneralRe: MasterPage and Javascript Pin
N a v a n e e t h3-Feb-08 19:34
N a v a n e e t h3-Feb-08 19:34 
AnswerRe: MasterPage and Javascript Pin
Raam3-Feb-08 21:58
Raam3-Feb-08 21:58 
GeneralNamespace for xquery Pin
VanithaVasu3-Feb-08 18:35
VanithaVasu3-Feb-08 18:35 
QuestionHow to print ReportViewer1 Pin
faisallal3-Feb-08 17:50
faisallal3-Feb-08 17:50 
GeneralHelp in generate Excel Data Pin
HatakeKaKaShi3-Feb-08 16:39
HatakeKaKaShi3-Feb-08 16:39 
GeneralRe: Help in generate Excel Data Pin
Venkatesh Mookkan3-Feb-08 17:19
Venkatesh Mookkan3-Feb-08 17:19 
HatakeKaKaShi wrote:
I need to generate a large number of records from SQL server 2000 to and excel spreadsheet.


Are you using the Excel COM object (will be slower) or HTML to Excel method to generate the Excel file?

HatakeKaKaShi wrote:
However the durations of time id too long. For about 900 records there's about 50 min.


It depends on the business logic used to generate the excel.

SQL Server 2005 has the ability to export to excel directly using OPENROWSET (INSERT INTO OPENROWSET) methodology. Check whether SQL Server 2000 also has that command.


[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

GeneralRe: Help in generate Excel Data Pin
HatakeKaKaShi3-Feb-08 20:32
HatakeKaKaShi3-Feb-08 20:32 
GeneralUn loading page Pin
Lijo Rajan3-Feb-08 16:36
Lijo Rajan3-Feb-08 16:36 
GeneralRe: Un loading page Pin
Guffa3-Feb-08 16:48
Guffa3-Feb-08 16:48 
GeneralRe: Un loading page Pin
John-ph3-Feb-08 21:12
John-ph3-Feb-08 21:12 
GeneralNEED HELP Pin
Mahendar3-Feb-08 6:09
Mahendar3-Feb-08 6:09 
GeneralRe: NEED HELP Pin
Paul Conrad3-Feb-08 7:00
professionalPaul Conrad3-Feb-08 7:00 
GeneralRe: NEED HELP Pin
Guffa3-Feb-08 16:15
Guffa3-Feb-08 16:15 
GeneralRe: NEED HELP Pin
dilipv3-Feb-08 19:47
dilipv3-Feb-08 19:47 
Questionshowing cathegorizied pictures..? Pin
Mir_As3-Feb-08 5:20
Mir_As3-Feb-08 5:20 
AnswerRe: showing cathegorizied pictures..? Pin
Expert Coming3-Feb-08 17:51
Expert Coming3-Feb-08 17:51 
Questionasp:CreateUserWizard background image Pin
snir_ya3-Feb-08 3:51
snir_ya3-Feb-08 3:51 
GeneralRe: asp:CreateUserWizard background image Pin
Sam Xavier3-Feb-08 17:29
Sam Xavier3-Feb-08 17:29 
GeneralMySQL Encoding Problem with ASP.NET Pin
Waleed Eissa3-Feb-08 3:06
Waleed Eissa3-Feb-08 3:06 
Generalrequiredfieldvalidator doesn't work properly within updatepanel Pin
Kariem Soudy2-Feb-08 21:54
Kariem Soudy2-Feb-08 21:54 
Generalasp.net Pin
sindhujadoss2-Feb-08 19:22
sindhujadoss2-Feb-08 19:22 
GeneralRe: asp.net Pin
pmarfleet2-Feb-08 22:31
pmarfleet2-Feb-08 22:31 
AnswerRe: asp.net Pin
John-ph2-Feb-08 23:17
John-ph2-Feb-08 23:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.