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.
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.
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.
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.
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.
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.
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.
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".
Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
0.0
4.0
4.5
1.0
5.0