Categories
ASPTips and Tutorials → Database-related

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 s...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 discuss...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

How to display records from top 4 database systems using plain ASP?

Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database conne...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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&&qu...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com