How to Use Dictionary Object ASP / Web Forms
Dictionary object is an useful object to store any form of data in an array list. Following asp script block stores all data coming from a form and list them in our HTML codes.
Using Data Shape to create hierarchical recordsets ASP / Database Integration
In this code code snips; we will create hierarchical recordsets using data shaping. We will create a new table using two data table. We will list results of one table with sub-records related to master table. Data shaping is an advanced technic to spend less server memory.
Using ASP for Form Handling: Part 4 - Filling the Gaps ASP / Web Forms
This article covers a number of miscellaneous topics include: handling radio buttons and check boxes, emailing attachments with CDONTS, sending HTML in an email message, and some ways of using the data stored in the registration database.
Multiple Form Selection (Where In) ASP / Database Integration
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. The following 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.
Select Case Example ASP / General Development
Many times we need to perform an action or display something different based on some different parameters. Using select case is one such way to do this.
SQLServerTools Object ASP / Database Integration
This example was easy Get a list of all current tables in the database created by your's truly, get a list of dependent stored procedures for each table and do it all in a stored procedure.
An Useful Method : RecordSet.Filter ASP / Database Integration
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.
Get Your Data Faster with a Data Cache ASP / Database Integration
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.
Randomizing a Recordset ASP / Database Integration
Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about always being last on the list.
Creating a Mailing List Program ASP / Scripts
Have you ever wanted to create a mailing list on your site? Tired of using those so-called free services that insert advertisements into all of your e-mails? Well this is your lucky day. I have written a basic tutorial on how to accomplish this task. Included with this article is all source code free to download.
Presentation Of Hierarchical Data ASP / Database Integration
It is very common to see hierarchical data in many of the forms used in web applications. The data is presented to the user in combo boxes. When the user selects the data in the first level combo box, the next level combo box gets filled with the data that is associated to the selected value in the previous level combo box.