Show result during SQL statement

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Show result during SQL statement

ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

December 7th, 2006, 06:51 AM

rtr1900

Authorized User

Join Date: Nov 2005

Posts: 72

Thanks: 3

Thanked 0 Times in 0 Posts

Show result during SQL statement

Hi,

Is it possible to do an SQL search and show it directly on screen and not to wait until it went thru the LOOP.

I have

DO WHILE NOT rs.EOF
[ here it writes some data with response.write]
rs.Movenext
LOOP

Now I noticed that if the DB is large, it shows everything when it comes out of the loop. Can this be done at the isntant?
So that I donÂ´t have to wait so long?

Regards,

Johny

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to show result of MS Analysis service to WEB?	rosejeep	C#	0	November 8th, 2006 09:27 PM
Database unable to show result. (ASP.NET C#)	richie86	ASP.NET 1.0 and 1.1 Basics	3	November 10th, 2005 01:59 PM
Very beginner - Result didn't show in the browser	not24	ASP.NET 1.0 and 1.1 Basics	7	February 22nd, 2005 12:08 PM
Show result from query	akibaMaila	VB.NET 2002/2003 Basics	2	January 18th, 2005 12:43 PM
problem in show result (vb.net)	q8z	Beginning VB 6	0	October 27th, 2004 03:01 PM