NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Using Disconnected Recordsets
2572
Using Disconnected Recordsets
http://www.4guysfromrolla.com/webtech/080101-1.shtml
This article looks at a neat and not often discussed feature of ADO - disconnected Recordsets. A disconnected Recordset, as its name implies, is a Recordset that lacks a connection. This may seem a bit confusing at first - how can a Recordset lack a connection to a data store? - but will hopefully become more clear as the article progresses
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Using Disconnected Recordsets: |
|||
Other links at ASP > Tips and Tutorials > Database-related
Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes our db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on. Note the db only has 50 observations in it. For best results search on a letter and search for another letter within those results.
Category:
This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. Therefore, it is essential that the reader have a fluid understanding of both data shaping and custom Recordsets, topics that this article doesn't aim at teaching. To learn about these topics, be sure to read the following articles
Category:
SQL Server 7.0 - installed on a server. This can be either a Windows NT 4 or Windows 2000 Server system. For help on seting up SQL Server, click HERE.
Configure SQL Server to use SQL Server and Windows NT authentication:
Open the SQL Server Enterprise Manager.
Right-click on the SQL Server which will be used with your ASP pages.
Click on Properties.
Click on the Security tab.
In the Authentication: section, click on SQL Server and Windows NT.
Click on the OK button to finish.
Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components
Configure SQL Server to use SQL Server and Windows NT authentication:
Open the SQL Server Enterprise Manager.
Right-click on the SQL Server which will be used with your ASP pages.
Click on Properties.
Click on the Security tab.
In the Authentication: section, click on SQL Server and Windows NT.
Click on the OK button to finish.
Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components
Category:
Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about always being last on the list.
Category:
Here is an invaluable program that you can use to view and control the presentation of records in your database. We will use the Recordset object and the MaxRecords property via ADO, to set the number of records to return to the recordset and therefore to your screen. This is like a table in memory, holding records which are subdivided into individual fields.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19539
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 228046
Pagerank Statistics
PHP News