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 GetRows To Get All Records From Table
2522
Using GetRows To Get All Records From Table
http://www.dotnetindex.com/read.asp?articleID=74
Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
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 GetRows To Get All Records From Table: |
|||
Other links at ASP > Tips and Tutorials > Database-related
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:
In the tutorials so far we have learned from connecting to the database via ASP to inerting, updating and selecting data from the database.
The area we waste a lot of database time is when we show records to the user and in the mean time keep our database connection open. Following example illustrates this point :
The area we waste a lot of database time is when we show records to the user and in the mean time keep our database connection open. Following example illustrates this point :
Category:
In the previous chapter, we looked at the basics of ADO, concerning ourselves mainly with the Recordset object and the manipulation of data. In most of the examples, we obtained data by simply specifying the name of a database table, but as you've seen from the object model, ADO has other objects that allow data to be accessed.
Category:
In this article we will learn on how to use database transactions in ASP. This will allow us to execute all database queries or none at all. How many times have you wanted to insert, update a lot of records collectively wanting that either all of them get executed or if there is an error then none is executed at all ? Well, if you haven't this need yet, you will have it in near future.
Category:
Presenting a large set of data in readable pages is a standard task for Web- application developers. Applications that need to produce search results in a digestible manner need to apply paging algorithms. This article will compare the three ways in which paging can be achieved for an ASP/SQL Server 7 application. The first uses ActiveX Data Object (ADO) paging; the second uses getrows and an array; and the third uses a SQL Server 7 stored procedure. Of those, the third is the most efficient because it returns the minimum set of data from the database server to the Web server
Category:
Main Category
199
2044
829
286
175
1801
1439
913
1177
7568
70
917
59
2238
175
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: 19870
Categories: 1275
Registered Users: 762
Mailing List Subscribers: 2047
Unique Outgoing Hits: 230666
Pagerank Statistics
PHP News