ASP vs. COM
When using a VB COM object to connect to a database which is better to output
the HTML results. To do objASPResponse.write and a loop from the VB Object,
or to build a string with a loop and return the string to the ASP page, or
to return maybe an array(from rs.getRows) to the ASP page and do the loop
in the ASP page?
I usually just do everything is ASP, not in COM Objects. So can someone help
me through this. I usually do something like this to get data from a database:
objConnTemp.CommandTimeout = 120
objConnTemp.ConnectionString = strDSN
set objRSTemp = objConnTemp.Execute("sp_search")
if not objRSTemp.eof then
arryRS = objRSTemp.GetRows
'loop through it here.
I usually don't use "ADODB.Command" or "ADODB.Recordset", but as I have been
looking at a lot of VB Sample Code, I see that most of them use both "ADODB.Command"
and "ADODB.Recordset". Should I now change my usual practices and do this
too? And if not then how in my VB code will I dim arryRS and objRSTemp.
Private objRSTemp as ?????
Private arryRS as As Variant ?????
Thanks to anyone that can help me out here. Also, any sample code is appreciated.
By Emad Ramadan in forum ASP.NET
Last Post: 09-30-2008, 08:12 AM
By Iain Munro in forum ASP.NET
Last Post: 02-22-2002, 08:44 AM
By sahar in forum ASP.NET
Last Post: 12-10-2000, 07:18 PM
By Keith Franklin, MCSD in forum Talk to the Editors
Last Post: 09-27-2000, 12:48 PM
By Aidan in forum ASP.NET
Last Post: 04-21-2000, 07:52 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL