Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

• Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
• Discuss Programming Problems and Freshers Jobs related issues here.
• Discuss Final Year Project Ideas here.

Script Name Executing Transact-SQL UPDATE statement 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 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. 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. 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. Simple database techniques When you start using ASP, you will begin working with databases. Interacting with databases can be very important. In this tutorial, we will be using a Microsoft Access Database along with technologies like ADO and the Connection and Recordset objects. Add N number of records to a dB This article shows how to insert records to a database, when the number of records that need to be inserted is unknown. A must read for ASP/ADO programmers. 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. Paging Records With GetRows You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly! 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 connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server). 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.

Google Search