Getting data as returned from SQL Server

  • Thread starter Thread starter Smokey Grindel
  • Start date Start date
S

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!
 
Are you filling a DataTable?
If I remember properly, RowChanged event will do the trick.
But what exactly are you doing?
 
Filling into a data table

Miha Markic said:
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 said:
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!
Click to expand...
Click to expand...
 
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)
____________________________________________________________________________________________
 
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..
 
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)
____________________________________________________________________________________________
 
Back
Top