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

Database-related

Results 41-60 of 128
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
Views1440
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
Views3615
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
Views1277
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
Views1934
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
Views1743
An Easy Way Delete A Record
Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
(6 ratings)
Reviews0
PriceFree
Views1594
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
Views1432
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
Views1172
Easy way to add a record
Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you.
(3 ratings)
Reviews0
PriceFree
Views2319
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
Views1870
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
Views1761
Compact & Repair Access Database
Compact and repair your access database online from ASP code. This is example code of how this can be done.
(3 ratings)
Reviews0
PriceFree
Views2410
Using MyODBC To Access Your MySQL Database Via ASP
MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.
(3 ratings)
Reviews0
PriceFree
Views2375
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
Views2029
Analyzing Duplicate Records
This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.
(3 ratings)
Reviews0
PriceFree
Views1225
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
Views977
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
Views1467
Using Multiple Recordsets
This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database.
(0 ratings)
Reviews0
PriceFree
Views2088
ASP Access Database Tutorials
This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials together allow you to build a simple Guestbook for your web site.
(51 ratings)
Reviews0
PriceFree
Views17106
Fastest way of Database Access : Caching Records in Memory
A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available.
(3 ratings)
Reviews0
PriceFree
Views1910
Results 41-60 of 128