Top Rated Scripts | ASP | Tutorials & Tips | Database-related
Randomizing a Recordset
posted byedinDatabase-related
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.
Reviews0
PriceFree
Views1670
Using Triggers to Track Database Action History
posted bytlkelleyinDatabase-related
This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.
Reviews0
PriceFree
Views1181
Two Ways To Connect To SQL Server 2000 Via ASP
posted byjoeinDatabase-related
This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples to get you started.
Reviews0
PriceFree
Views2247
Real-Time Data Grid Part 1/2
posted byannetteinDatabase-related
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.
Reviews0
PriceFree
Views1974
SQL In Simple English - Part 1
posted byfaisalinDatabase-related
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.
Reviews0
PriceFree
Views2173
Quick form 2 db
posted byderekinDatabase-related
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.
Reviews0
PriceFree
Views2225
An easy way to add tables
posted byderekinDatabase-related
Insert a table into a database dynamically. You don't even have to open MS Access. One simple asp does the trick. Using ADOX you can add and manipulate tables easily once you know how.
Reviews0
PriceFree
Views1689
Counting Records Wizard
posted byderekinDatabase-related
This little wizard will help you count records and display the total. Simply fill in the form, and it will generate the code for you.
Reviews0
PriceFree
Views1921
Access Connection DSN-Less Code
posted byderekinDatabase-related
So you need a DSN-Less connection but your not quite sure what to do. Well we can do this for you. A quick and easy way to make a connection without a DSN. This will work for your MS Access database only. Now includes SQL Server.
Reviews0
PriceFree
Views2524
Professional C# 2nd Edition : Data Access with .NET.
posted byfaisalinDatabase-related
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".
Reviews0
PriceFree
Views1494
ASP upload to database or file
posted byinfoinDatabase-related
To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of JetOLEB connection to MDB, test of MSSQL 2000 and AppendChunk method and UPDATE text SQL command.
Reviews0
PriceFree
Views3897
SQL In Simple English - Part II
posted byfaisalinDatabase-related
This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.
Reviews0
PriceFree
Views1670
SQL Reserved Words
posted byderekinDatabase-related
Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember every single one. Here's a concise listing of SQL Reserved words to help you along.
Reviews0
PriceFree
Views1463
Wielding the Power of the DataView
posted byarticlesinDatabase-related
When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In doing that with ADO.NET and trying to reproduce the basics or the recordset object, this article discusses the new and many uses of ADO.NET's DataView object.
Reviews0
PriceFree
Views1335
WiredNow.net: SQL Reserved Words
posted bydougrathboneinDatabase-related
It is an often problem with database intergration when you use a reserved word. Often asked why a script does not work and it quite often comes down the the author setting a field name as a reserved word, confusing SQL and making debugging hard. To solve this problem here is a quick list of the SQL Reserved Words.
Reviews0
PriceFree
Views1283
Delete records with sql statements
posted bycontactinDatabase-related
Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Reviews0
PriceFree
Views1818
Access and SQL Server DSN-LESS connections
posted bycontactinDatabase-related
There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection.
Reviews0
PriceFree
Views3125
Edit records with sql statements
posted bycontactinDatabase-related
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Reviews0
PriceFree
Views1938
Populate dropdowns from your database
posted bycontactinDatabase-related
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.
Reviews0
PriceFree
Views3033
Get the ID of the record entered
posted bycontactinDatabase-related
How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.
Reviews0
PriceFree
Views2163