Browse a Listing
Top > ASP > Tips and Tutorials > Database-related
Popular Tags
Free Script links
ADO: An application programming interface (API) to access relational database management systems.
ADO is provided as a DLL, and usually installed at "c:program filescommon filessystemadomsadox.dll".
ADO can access databases connected through ODBC data source names (DSN).
ADO can also access MS Access database files.
ADO is built on top of OLE DB technology.
ADO API is very similar to DAO.
This chapter shows you how to use ADO to connect ASP pages to MS Access databases. It also shows various interesting issues related to taking user input data to database and retrieving data from database to Web pages.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 7 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
Let's see what's going on a fresh example
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 5 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Collecting visitor information is a useful tool for any webmaster. Whether it's collecting suggestions to improve your site, or contact information for sales leads, visitor information is a valuable resource. The following download will allow your visitors to submit their name, email, and any comments.
It is written with a minimalist implementation and lots of comments to make it easier for you to customize to your site's needs. The code is good "out of the box", just unzip the files and put them on your webserver and you're all set (though you will want to add your own site's design around the code). If you wish to have the database file in another folder, make sure you update the strDatabasePath variable in BasicForm.asp
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Data repeaters in .NET are very usefull to display database records onto screen. But usually, in a real world situation, you don?t have enough functionality with 1 repeater. Take for example some kind of menu structure. You want to display a category, but every category can have 0 or more subcategories. With 1 repeater, this cannot be done in a simple way. In .NET, you can use nested repeaters for this
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 4 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
ADO is used to query the data, and the underlying database may be MySQL, SQL Server, Access, Oracle, or any other major RDBMS. Unlike many other articles, complete examples are presented, which may be copied into a file and run directly. Techniques for optimizing the output of tabular data are presented first, followed by techniques for optimizing more complex tabular data typical of reports. The appendix contains instructions for configuring the tests, links to references, and books suggestions.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 1 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Database programming is like a confused little monkey. Puddlin? on the floor and screaming at the walls, it?s a tedious little thing that?s prone to memory leaks and lots of errors and mistakes. To the dismay of anyone hoping to avoid a headache, database programming is ridiculously redundant and incredibly boring. Because web development loves its little monkey sooooo much, it?s unfortunately here to stay.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 10, 2006 Hits: 3 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR