Most Popular Scripts | ASP | Tutorials & Tips | Database-related
Counting Records in SQL Script
posted byinfoinDatabase-related
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
Reviews0
PriceFree
Views1405
Faster Singleton Queries with ADO
posted byhumbadsinDatabase-related
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 command object to perform faster singleton queries.
Reviews0
PriceFree
Views1402
Get the ID of the record entered
posted bycontactinDatabase-related
How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.
Reviews0
PriceFree
Views2176
Delete records with sql statements
posted bycontactinDatabase-related
Learn how to delete records with an SQL 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.
Reviews0
PriceFree
Views1829
Access and SQL Server DSN-LESS connections
posted bycontactinDatabase-related
There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection.
Reviews0
PriceFree
Views3133
Edit records with sql statements
posted bycontactinDatabase-related
Learn how to edit 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.
Reviews0
PriceFree
Views1948
Populate dropdowns from your database
posted bycontactinDatabase-related
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.
Reviews0
PriceFree
Views3043
WiredNow.net: SQL Reserved Words
posted bydougrathboneinDatabase-related
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 solve this problem here is a quick list of the SQL Reserved Words.
Reviews0
PriceFree
Views1293
Wielding the Power of the DataView
posted byarticlesinDatabase-related
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.
Reviews0
PriceFree
Views1347
SQL Reserved Words
posted byderekinDatabase-related
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.
Reviews0
PriceFree
Views1472
SQL In Simple English - Part II
posted byfaisalinDatabase-related
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.
Reviews0
PriceFree
Views1680
Professional C# 2nd Edition : Data Access with .NET.
posted byfaisalinDatabase-related
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".
Reviews0
PriceFree
Views1501
ASP upload to database or file
posted byinfoinDatabase-related
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.
Reviews0
PriceFree
Views3910
Quick form 2 db
posted byderekinDatabase-related
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.
Reviews0
PriceFree
Views2236
An easy way to add tables
posted byderekinDatabase-related
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.
Reviews0
PriceFree
Views1696
Counting Records Wizard
posted byderekinDatabase-related
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.
Reviews0
PriceFree
Views1933
Access Connection DSN-Less Code
posted byderekinDatabase-related
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.
Reviews0
PriceFree
Views2536
SQL In Simple English - Part 1
posted byfaisalinDatabase-related
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.
Reviews0
PriceFree
Views2189
Real-Time Data Grid Part 1/2
posted byannetteinDatabase-related
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.
Reviews0
PriceFree
Views1983
Two Ways To Connect To SQL Server 2000 Via ASP
posted byjoeinDatabase-related
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.
Reviews0
PriceFree
Views2253