You can use GetString() method of ADODB.Recordset object if you want to dumpthe complete table in an active server page. GetString() method returns thecomplete recordset as a string. You can specify the number of rows in therecordset to return. All rows will be returned if this parameter is notspecified, or if it is greater than the number of rows in the recordset. Youcan also specify the delimiters to use between various columns and the rows.You can use this method to build an HTML table in an asp page. To build anHTML table using this method you need to specify the combination of “
Here is the sample VBScript code from an active server page which can beused to build an HTML table.
<% Dim oConnection ' Connection Object Dim oRecordset ' Recordset Object ' Create connection and recordset object Set oConnection = Server.CreateObject("ADODB.Connection") Set oRecordset = Server.CreateObject("ADODB.Recordset") ' Open the connection object oConnection.Open "DSN=Sample","sa","" ' Open the recordset object oRecordset.Open "MyTable", oConnection,,,adCmdTable ' Write the complete table using GetString() method Response.Write "" Response.Write oRecordset.GetString(,," ", " ") Response.Write "
"%>
devx-admin
Share the Post:


Consumer Trading Resurgence Boosts Fintech Startups
Grace Phillips
December 8, 2023


Solar Mars Bot: Clean Energy on Wheels
Lila Anderson
December 8, 2023


New Apple Developer Program Offers Free Xcode Cloud Hours
Jordan Williams
December 8, 2023


Data Breaches Rise Despite Encryption Measures
Noah Nguyen
December 8, 2023


OurSky Raises Funds for Telescope Network Expansion
Grace Phillips
December 8, 2023


House Committee Probes OCC Fintech Chief’s Background
Johannah Lopez
December 8, 2023


Consumer Trading Resurgence Boosts Fintech Startups
Grace Phillips
December 8, 2023
5:48 PM


Solar Mars Bot: Clean Energy on Wheels
Lila Anderson
December 8, 2023
4:44 PM


New Apple Developer Program Offers Free Xcode Cloud Hours
Jordan Williams
December 8, 2023
3:40 PM


Data Breaches Rise Despite Encryption Measures
Noah Nguyen
December 8, 2023
2:37 PM


OurSky Raises Funds for Telescope Network Expansion
Grace Phillips
December 8, 2023
12:31 PM


House Committee Probes OCC Fintech Chief’s Background
Johannah Lopez
December 8, 2023
9:17 AM


Framework Introduces Mainboard Repurposing Initiative
Lila Anderson
December 8, 2023
8:27 AM


Top 15 Laptops in 2023: Industry Analysis
Jordan Williams
December 8, 2023
7:24 AM


Pontera Secures $60M for Global Expansion
Noah Nguyen
December 8, 2023
6:20 AM


Apple’s Journal App Boosts Mental Well-Being
Lila Anderson
December 7, 2023
4:51 PM


Affordable Helium Mobile Plan Offers Unlimited Data
Jordan Williams
December 7, 2023
3:46 PM


Chinese Users Debate 5G Switch Removal
Noah Nguyen
December 7, 2023
2:42 PM


AI Chatbots Deceive Each Other, Expose Risks
Johannah Lopez
December 7, 2023
11:19 AM


AI Integration Boosts Efficiency in Diverse Industries
Johannah Lopez
December 7, 2023
10:39 AM


Israeli Startup Investments Hit Decade Low
Grace Phillips
December 7, 2023
9:34 AM


Final Chance: Best Buy’s Cyber Monday Savings
Lila Anderson
December 7, 2023
8:31 AM


Bureaucratic Hurdles Slow EV Charger Deployment
Jordan Williams
December 7, 2023
7:28 AM


Nio Considers Spinning Off Battery Unit for Profitability
Noah Nguyen
December 7, 2023
6:24 AM


Groundbreaking Drone Tech Disrupts Enemy Communications
Grace Phillips
December 6, 2023
4:17 PM


Balancing Online Security with Enhanced User Experience
Lila Anderson
December 6, 2023
3:31 PM


Fossil Fuel Emissions Hit Record High in 2023
Johannah Lopez
December 6, 2023
12:42 PM


Zeekr Considers US IPO Amid Eco-Friendly Transport Boom
Jordan Williams
December 6, 2023
12:09 PM


Why Is Your Device Saying Your Wi-Fi Security Is Weak?
DevX Editor
December 6, 2023
11:59 AM


Civilian Centers Train Ukrainian Drone Pilots
Noah Nguyen
December 6, 2023
11:01 AM


COP28 Conference Ignites SAI Geoengineering Debate
Johannah Lopez
December 6, 2023
10:00 AM