Pick a random record from a database - When you have lots of ads or lots of jokes and you want to show only one, you can choose to pick one at random from the database. This tutorial explains how. Price: Populate dropdowns from your database - Dropdowns or combo boxes are an excellent way to get input from a user. One of the biggest problems with user input is spelling and formatting. Here is how to use and populate dropdowns from a database. Price: Presentation Of Hierarchical Data - Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name "Hierarchy" and accesses the database using the user id "sa" with a blank password. The database is created in SQL Server 7.0. Price: Free Printing Headers on every page of a report (from a database) - The author writes "Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print a certain number of rows on each page with a column header on each page. This solution solves the problem." Source code available for download. Price: Professional C# 2nd Edition : Data Access with .NET. - Complete Online Chapter "Data Access with .NET" from Wrox Press book "Professional C# 2nd Edition". Topics covered include "Connecting to the database", "Executing Commands", "Stored Procedures", "The ADO.NET object model" and "Using XML and XML Schemas". Price: Querying an Access database in ASP - Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes. Price: Free Quick form 2 db - You fill in the blanks, and you are given the source code for the form, and a page to display the information in the database. Also the database is ready to download with all fields in your form. Price: Randomizing a Recordset - This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records with certain attributes to the top of an otherwise randomized list. Price: Real Time Data Grid Part 2/2 - This article wraps up the details of the real time data grid that started in part one of this two-part article. It looks at the JavaScript code that contacts our database server and allows us to update data in a database without actually refreshing the page. Price: Real-Time Data Grid Part 1/2 - The part one of this two-part article shows how to create an ASP class that allows us to work with our databases through a web browser. It will allow us to update and delete records dynamically using JavaScript and XMLHTTP, without ever having to refresh the page. Price: Running Stored Procedures in Access Database - Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download. Price: Search Database - This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database. Price: Search db by Field - Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations. Price: Free Search Within Search Results - 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 a 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. Price: Free Select Statement Code Generator - This code wizard can generate code for any select statement. It generates code from the database connection to retrieving the values of your fields in variables. Can generate code for any number of fields. Price: Freeware
|
Javascript
PHP
Java
ASP
CGI & Perl
Site Management
Webdesign Tools
HTML Editors
Site Builders
FTP
Flash Tools
More...
| Link Exchange Manager is a software program that manages your website's links pages. It is a time-saving way to reduce HTML coding and manual scanning for reciprocal links and dead links on your link partners websites. Link Exchange Manager is perfect for managing an organized links page, or a resource directory, and you can send off link request emails to website prospects. Also called link swapping, its a great way to increase your search engine rankings and boost your google rankings. |
