Search Filter
Search Filter
Sort Listings By
Show Only
By Customer Review
Licence Type

Database-related

Results 21-40 of 128
Executing Transact-SQL INSERT statement
In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.
(3 ratings)
Reviews0
PriceFree
Views2516
Counting Records In A Database Table
We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.
(9 ratings)
Reviews0
PriceFree
Views2308
Executing Transact-SQL DELETE statement
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.
(3 ratings)
Reviews0
PriceFree
Views1536
Custom Paging in ASP
This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.
(18 ratings)
Reviews0
PriceFree
Views5317
Uploading Images to Database Using Persist AspUpload
You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.
(9 ratings)
Reviews0
PriceFree
Views2436
ASP Speed Tricks
This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages.
(6 ratings)
Reviews0
PriceFree
Views2938
ASP and DBF database file connection
Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update), other ISAM formats + FOXPRO option, real sample code, create a new DBF file.
(9 ratings)
Reviews0
PriceFree
Views2274
Dynamic, database backed dropdown lists
How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list.
(9 ratings)
Reviews0
PriceFree
Views3978
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
Views1721
MS Access: Tables, Views and Procedures
Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP script.
(6 ratings)
Reviews0
PriceFree
Views3244
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
Views2882
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
Views2775
Add records with sql statments
Learn how to add 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.
(3 ratings)
Reviews0
PriceFree
Views1831
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
Views1537
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
Views1411
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
Views1040
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
Views1060
Uploading and inserting files (binary data) to the database
Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been explained in detail. Downloadable source code available.
(6 ratings)
Reviews0
PriceFree
Views3956
Displaying binary data from the database using plain ASP
Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail. Downloadable source code available.
(3 ratings)
Reviews0
PriceFree
Views2045
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
Views1166
Results 21-40 of 128