Top Rated Scripts | ASP | Tutorials & Tips

Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

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.

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 little wizard will help you count records and display the total. Simply fill in the form, and it will generate the code for you.

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.

Many times it is necessary to consider the clients browser. Some things are not cross browser compliant. Some things look right in IE but are a little different in NS. The opposite is true as well. By looking at the USER AGENT we can do a little server side scripting to show what is needed depending on the browser. Here is how.

If you try to do any ASP programming, it won't be long before you need the If...then statement. This very simple tutorial talks you through the syntax used and shows you how can use it.

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".

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.

Want to show current number of users on your ASP page? This article lets you show a way to access IIS/ASP performance values from ASP. Source to show current number of anonymous users or main IIS performance values in HTML, values from other computers.

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.

A short tip on passing info between pages via a query string.

There are several different ways of displaying times. Using FormatDateTime and DatePart functions we can manipulate the time in many different ways.

Many times we need to perform an action or display something different based on some different parameters. Using If ElseIf End If is one such way to do this.

Many times we need to perform an action or display something different based on some different parameters. Using select case is one such way to do this.

Overview and a quick example of the Len() function that calculates the LENGTH of a string.

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 example is a simple counter using graphics to display the numbers that will only show page views, not actual visitors. It uses the File Scripting Object to interact with a text file.

There are many ways to use arrays. This page shows a couple of quick examples for using arrays in ASP.

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.