When connection is established ADO Recordset Object is to able to read database data, the data must first be loaded into a recordset.
A D V E R T I S E M E N T
The ADO Recordset object is used to hold a set of data from a database table.

Create an ADO Table Recordset

After making the connection to data of database through ADO Database Connection,it is possible to create an ADO Recordset.

For Example: we have a database named "vyom", we can get access to the "Employee" table inside the database with the following lines:

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "e:/vyomworld/vyom.mdb"
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Employee", conn

%>

Create an ADO SQL Recordset

To create the recordset, use the following line:

<%

Set rs=Server.CreateObject("ADODB.Recordset")

%>

We can also get access to the data in the "Emloyee" table using SQL:

Extract Data from the Recordset:

When recordset is opened, we can extract or access the data from recordset. For Example: we have a database named "vyom", we can get access to the "Employee" table inside the database with the following lines:

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/vyomworld/vyom.mdb"
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Employee", conn
for each x in rs.fields
response.write(x.name)
response.write(" = ")
response.write(x.value)
next

%>

Be the first one to comment on this page.

ADO Tutorial eBooks
No eBooks on ADO could be found as of now.

ADO Tutorial FAQs

More Links » »

ADO Tutorial Interview Questions

What are the five imp fields to be maintained in account determination

What is the basic qualification for SAP Implementation ?

Why u can call(r using) ssf_function_module_name in smartforms?

What we normally check for in the Database Testing?

What is the difference between ATP check and availability check how these reflect in sales order(which check system considers) what are the IMG settings for the same.

What is availability check, how to configure it?

Why u can call(r using) ssf_function_module_name in smartforms?

We get a report screen: "Goods issue: Problem Log" during the delivery process when activating Post Goods Issue button. We want to include our own error message to this list if the selected batch is not on a customer defined table. What is the best way?

Why u can call(r using) ssf_function_module_name in smartforms?

In scripts how to upload logo (it's saved in .bmp file ) What is the procedure?

More Links » »

ADO Tutorial Articles
No ADO Articles could be found as of now.

ADO Tutorial News
No News on ADO could be found as of now.

ADO Tutorial Jobs
No ADO Articles could be found as of now.

Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.

Keywords: recordset object, ado recordset object, cursor type, ado recordset imports

HTML Quizzes

XML Quizzes

Browser Scripting Quizzes

Server Scripting Quizzes

.NET (dotnet) Quizzes

Multimedia Quizzes

Gnuplot Programming Quiz

GIF Animation Quiz

Scientific Visualization Quiz

Web Building Quizzes

Web Site Hosting Quiz

Java Quizzes

Programming Langauges Quizzes

C Quiz

C++ Quiz

Visual Basic Quiz

Data Structures Using C Quiz

Cobol Quiz

Assembly Language Quiz

Mainframe Quiz

Forth Programming Quiz

Lisp Programming Quiz

Data Warehousing Quiz

Soft Skills Quizzes

Communication Skills Quiz

Time Management Quiz

Project Management Quiz

Team Work Quiz

Leadership Skills Quiz

Corporate Communication Quiz

Negotiation Skills Quiz

Database Quizzes

Oracle Quiz

MySQL Quiz

Operating System Quizzes

Software Testing Quizzes

SAP Module Quizzes

Business Warehousing Quiz

SAP Basis Quiz

Material Management Quiz

Sales & Distribution Quiz

Human Resource Quiz

Netweaver Quiz

Customer Relationship Management Quiz

Production and Planning Quiz

Networking Programming Quizzes

Corba Quiz

Networking Quiz

Microsoft Office Quizzes

Microsoft Word Quiz

Microsoft Outlook Quiz

Microsoft PowerPoint Quiz

Microsoft Publisher Quiz

Microsoft Excel Quiz

Microsoft Front Page Quiz

Microsoft InfoPath Quiz

Microsoft Access Quiz

Accounting Quizzes

Financial Accounting Quiz

Managerial Accounting Quiz

Testimonials \| Contact Us \| Link to Us \| Site Map
Copyright ? 2008. Academic Tutorials.com. All rights reserved	Privacy Policies \| About Us
Our Portals : Academic Tutorials \| Best eBooksworld \| Beyond Stats \| City Details \| Interview Questions \| Discussions World \| Excellent Mobiles \| Free Bangalore \| Give Me The Code \| Gog Logo \| Indian Free Ads \| Jobs Assist \| New Interview Questions \| One Stop FAQs \| One Stop GATE \| One Stop GRE \| One Stop IAS \| One Stop MBA \| One Stop SAP \| One Stop Testing \| Webhosting in India \| Dedicated Server in India \| Sirf Dosti \| Source Codes World \| Tasty Food \| Tech Archive \| Testing Interview Questions \| Tests World \| The Galz \| Top Masala \| Vyom \| Vyom eBooks \| Vyom International \| Vyom Links \| Vyoms \| Vyom World \| Important Websites
Copyright ? 2003-2024 Vyom Technosoft Pvt. Ltd., All Rights Reserved.

Testimonials \| Contact Us \| Link to Us \| Site Map
Copyright ? 2008. Academic Tutorials.com. All rights reserved	Privacy Policies \| About Us
Our Portals : Academic Tutorials \| Best eBooksworld \| Beyond Stats \| City Details \| Interview Questions \| Discussions World \| Excellent Mobiles \| Free Bangalore \| Give Me The Code \| Gog Logo \| Indian Free Ads \| Jobs Assist \| New Interview Questions \| One Stop FAQs \| One Stop GATE \| One Stop GRE \| One Stop IAS \| One Stop MBA \| One Stop SAP \| One Stop Testing \| Webhosting in India \| Dedicated Server in India \| Sirf Dosti \| Source Codes World \| Tasty Food \| Tech Archive \| Testing Interview Questions \| Tests World \| The Galz \| Top Masala \| Vyom \| Vyom eBooks \| Vyom International \| Vyom Links \| Vyoms \| Vyom World \| Important Websites
Copyright ? 2003-2024 Vyom Technosoft Pvt. Ltd., All Rights Reserved.

ADO Recordset

Create an ADO Table Recordset

Create an ADO SQL Recordset

Extract Data from the Recordset:

No eBooks on ADO could be found as of now.

No ADO Articles could be found as of now.

No News on ADO could be found as of now.

No ADO Articles could be found as of now.