Getting data as returned from SQL Server

[Smokey Grindel]

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 Grindel]

without using a data reader directly I should say

 

[Miha Markic]

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

 

[Smokey Grindel]

Filling into a data table

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/

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 Vaughn]

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]

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]

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)
____________________________________________________________________________________________