Getting data as returned from SQL Server

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!

Smokey
Fri Feb 08 09:05:37 CST 2008

without using a data reader directly I should say

"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!
>

Miha
Fri Feb 08 09:35:44 CST 2008

Are you filling a DataTable?
If I remember properly, RowChanged event will do the trick.
But what exactly are you doing?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"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!
>

Smokey
Fri Feb 08 10:18:58 CST 2008

Filling into a data table

"Miha Markic" <miha at rthand com> wrote in message
news:%23zgpghmaIHA.1532@TK2MSFTNGP04.phx.gbl...
> Are you filling a DataTable?
> If I remember properly, RowChanged event will do the trick.
> But what exactly are you doing?
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "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!
>>
>

William
Fri Feb 08 12:49:51 CST 2008

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!
>

Smokey
Tue Feb 12 09:20:25 CST 2008

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!
>>
>

William
Tue Feb 12 12:17:33 CST 2008

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!
>>>
>>
>
>