• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = Select *

ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = Select *

ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = "Select * from Authors" GetData vArray Now Contains

Rate ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = Select *

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

	Const sDSN = Application("ConncetionString")
	Dim vArray
	Dim cnADO 
	Dim rsADO
	Dim sSQL

	Set cnADO = Server.CreateObject("ADODB.Connection")
	Set rsADO = Server.CreateObject("ADODB.Recordset")
	
Sub GetData
    cnADO.Open sDSN
    rsADO.Open sSql ,cnADO
	vArray = rsADO.GetRows 
	rsADO.Close
	cnADO.Close	
	set rsADO = Nothing
	set cnADO = Nothing
end sub

%>