Want to hire a development team?
Search Filter
Search Filter
Sort Listings By
Show Only
By Customer Review
Licence Type

Top Rated Scripts | ASP | Tutorials & Tips | Database-related

Results 101-120 of 128
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.
(0 ratings)
Reviews0
PriceFree
Views1670
Using Triggers to Track Database Action History
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.
(0 ratings)
Reviews0
PriceFree
Views1181
Two Ways To Connect To SQL Server 2000 Via ASP
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.
(0 ratings)
Reviews0
PriceFree
Views2247
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.
(0 ratings)
Reviews0
PriceFree
Views1974
SQL In Simple English - Part 1
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.
(0 ratings)
Reviews0
PriceFree
Views2173
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.
(0 ratings)
Reviews0
PriceFree
Views2225
An easy way to add tables
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.
(0 ratings)
Reviews0
PriceFree
Views1689
Counting Records Wizard
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.
(0 ratings)
Reviews0
PriceFree
Views1921
Access Connection DSN-Less Code
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.
(0 ratings)
Reviews0
PriceFree
Views2524
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".
(0 ratings)
Reviews0
PriceFree
Views1494
ASP upload to database or file
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.
(0 ratings)
Reviews0
PriceFree
Views3897
SQL In Simple English - Part II
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.
(0 ratings)
Reviews0
PriceFree
Views1670
SQL Reserved Words
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.
(0 ratings)
Reviews0
PriceFree
Views1463
Wielding the Power of the DataView
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.
(0 ratings)
Reviews0
PriceFree
Views1335
WiredNow.net: SQL Reserved Words
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.
(0 ratings)
Reviews0
PriceFree
Views1283
Delete records with sql statements
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.
(0 ratings)
Reviews0
PriceFree
Views1818
Access and SQL Server DSN-LESS connections
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.
(0 ratings)
Reviews0
PriceFree
Views3125
Edit records with sql statements
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.
(0 ratings)
Reviews0
PriceFree
Views1938
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.
(0 ratings)
Reviews0
PriceFree
Views3033
Get the ID of the record entered
How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.
(0 ratings)
Reviews0
PriceFree
Views2163
Results 101-120 of 128