SHOWING LATEST TUTORIALS
Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.
In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database
Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was
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.
This sample ASP Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.
This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object.
AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This article explains how to use this function.
Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucida
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.
It is very common operation to request one field of information via a database query. This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO comm
This is a detailed tutorial on Recordset object. It first briefly describes the ADO technology, then covers such topics as Connectionless Recordsets and How to display data with a Recordset with and without a connection object. This article is designed fo
Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a
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.
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.
In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.
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.
This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object.
Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? Th
