William Vaughn
2/12/2008 6:18:00 PM
I would pre-process the data on the server (stored procedure) and use SSIS
to export it to CSV.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Smokey Grindel" <nospam@nospam.com> wrote in message
news:uiWfLrYbIHA.3972@TK2MSFTNGP03.phx.gbl...
> It's processing the data and making a CSV file after altering the data...
> somehow the CSV has to get to the client in the end..
>
> "William Vaughn" <billvaNoSPAM@betav.com> wrote in message
> news:5EAA852C-B608-4E8D-8862-1110AFA007C5@microsoft.com...
>> My question is: why? Why bring 100,000 rows to the client? Invariably,
>> this is to somehow process the rows and return them or perform some
>> client-side operation--either of which can be better accomplished on the
>> server. If it's to construct a report, that too could be better done on
>> the server with ReportingServices.
>>
>>
>> --
>> __________________________________________________________________________
>> William R. Vaughn
>> President and Founder Beta V Corporation
>> Author, Mentor, Dad, Grandpa
>> Microsoft MVP
>> (425) 556-9205 (Pacific time)
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> ____________________________________________________________________________________________
>> "Smokey Grindel" <nospam@nospam.com> wrote in message
>> news:upaXKHmaIHA.5208@TK2MSFTNGP04.phx.gbl...
>>> is there anyway to get the data as it is returend from the sql server? I
>>> have a command object that returns 100,000 records which I want to see
>>> as they come back... kinda like how SQL Managment studio does when you
>>> execute a query it shows the data as it comes in... any way to do that
>>> in ADO.NET? I am using .NET 3.5 on VS 2008 thanks!
>>>
>>
>
>