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
Views2596
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
Views2377
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
Views1627
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
Views5462
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
Views2501
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
Views2995
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
Views2344
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
Views4041
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
Views1787
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
Views3312
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
Views2941
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
Views2833
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
Views1902
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
Views1676
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
Views1506
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
Views1089
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
Views1122
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
Views4017
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
Views2115
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
Views1229
Results 21-40 of 128