Inserting Information Into A Database
This tutorial describes how to insert data into a database. It uses an example where you build an Access database of username & password for password protection. Source code of the example is available for download.
http://www.js-examples.com/asp/insertcode.htm
(Rating: 0.00 Votes: 0)
Rate ItReview It
Integrating User Search with ASP and SQL Server Full-Text Search
This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download.
http://www.15seconds.com/Issue/010423.htm
(Rating: 0.00 Votes: 0)
Rate ItReview It
Loading Text Files Into A Database
This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.
Price: Free
http://www.byte.com/art/9706/sec8/art1.htm
(Rating: 0.00 Votes: 0)
Rate ItReview It
Multiple Form Selection
Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.
Price: Free
http://www.codeave.com/asp/code.asp?u_log=125
(Rating: 0.00 Votes: 0)
Rate ItReview It
Multiple Form Selection (Where In)
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin’ Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.
http://www.codeave.com/asp/code.asp?u_log=127
(Rating: 0.00 Votes: 0)
Rate ItReview It
Name Search & Hyperlinks to Detail
This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.
http://www.codeave.com/asp/code.asp?u_log=96
(Rating: 0.00 Votes: 0)
Rate ItReview It
Named Recordsets
This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.
Platform: ASP 2.0
http://CoverYourASP.com/NamedRecordsets.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Paging Records With GetRows
You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. Its much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows lets you count the records correctly!
http://www.4guysfromrolla.com/webtech/070500-1.shtml
(Rating: 0.00 Votes: 0)
Rate ItReview It
Paging: Use ADO, getrows, or a Stored Procedure\?
Paging is basically querying a database and presenting a page full of the querys results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient when dealing with very large sets of data.
http://www.15seconds.com/Issue/010308.htm
(Rating: 0.00 Votes: 0)
Rate ItReview It
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
http://www.asp101.com/articles/hierarchy/index.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
