Scriptsmount a free web scripts directory provides website scripts, webmaster scripts, web directory scripts, directory scripts, php scripts, perl scripts, cgi scripts, html scripts, database scripts, asp.net scripts, form scripts, guestbook scripts for webmasters
Web Scripts :: ASP :: ASP Tips and Tutorials :: Database-related
81.
Fun With Stored Procedures...
|
|
This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.
Hits: 28 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
82.
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.
Hits: 21 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
87.
Get Your Data Faster with a Data Cache
|
|
Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.
Hits: 25 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
88.
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.
Hits: 21 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
89.
Two Table Join
|
|
Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.
Hits: 19 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
|
|
|
|
