Database Sample Code
-
ADO Utility Class
by NeverMalchik
ADO class containing useful functions - counting records, creating database from scratch, openning/closing database, filling listbox/combo box with an sql statements, manipulating records....and much more.
-
Transactions made easy with .NET 2.0
by Xavier Larrea
One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace.
-
Send an email using a ColdFusion form
by Julia Lynne Green
How to create a simple form, that posts to the page and emails a letter, and the results to everyone, including you.
-
SQL Data Provider VB.NET Class
by
This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly.
-
RSS Feed Helper Class
by James Crowley
A simple helper class to make generating an RSS feed a piece of cake - its the one we use on Developer Fusion too!
-
Form filter example
by Thamar
An example of filtering the data displayed in Microsoft Access Forms using VBA.
-
Remote ODBC
by Crispin Wright
How to install ODBC connections remotely using the Registry API, connect to a network machine, and install users System DSN's without having to travel around sites.
-
SQL Running Total
by Neil
One SELECT statement to calculate running total in Access OR MS-SQL (And anything else for that matter).
-
Calculate Diskspace Used by a Table or Database
by James Crowley
This short snippet shows how to discover how large a particular table or an entire database is in SQL Server.
-
Database Schema using ADOX
by CodeWarrior
Print all the Table names and their respective Column names in whatever database you choose
-
Reuse ADO recordsets
by ElementK Journals
How to reuse ADO recordsets without destroying them first
-
T-SQL implementation of SKIPJACK
by David Janecka
A T-SQL implementation of the crypt algorith SKIPJACK as a user function for MS-SQL 2000
-
Database Independent ADO.NET 2.0
by Xavier Larrea
ADO.NET 2 has new classes that makes it quite easy to write data-programs independent of the database engine. Learn how here.
-
Data-shaped SQL clauses
by ElementK Journals
How to build a data-shaped SQL clause for VB
-
Paginate a recordset
by James Crowley
How to split up a recordset into multiple pages using ADO and ASP
-
Handling multiple Direct ODBC calls that fail.
by Dale Harkness
The article addresses the problem that sometimes occurs when making several direct ODBC calls in a sequence.
-
Randomly Sorting Records
by James Crowley
Here's now to randomly sort records in SQL Server 2000 - so you can potentially select say 10 random items from a table.
-
Databinding SqlTypes
by Dan Glass
Demonstrates how Databind the SqlTypes using the PropertyDescriptor class and the ITypedList Interface.
-
Auto Form
by Santi Mondejar
Automatically generate a HTML form from an SQL query
-
Parameters in a DAO parameter query
by ElementK Journals
Entering parameters into a DAO parameter query