Error: System.Security.Cryptography.CryptographicException: Keyset does not exist or Access is denied.

Posted on: 11/11/2008

This article provides a possible solution to fix the following exception: System.Security.Cryptography.CryptographicException - Keyset does not exist or Access is denied.

How To: Convert an object to XML string

Posted on: 11/10/2008

In this article we will show you how to output an object's data to an XML string.

Shortcut: No more hard coding the physical path to your access database in the ConnectionString section of your web.config

Posted on: 6/16/2008

If your database is located in the App_Data folder of your web application. Here is a neat little shortcut for your Access Database ConnectionString.

How To: Manually initialize a custom membership provider

Posted on: 5/08/2008

In this article, we will describe how to manually initialize a custom membership provider.

How To: Check a null value in a column of a DataTable in a DataSet

Posted on: 2/06/2008

This article will show some ways of checking for null values in a DataTable.

Shortcut: Use the @ Symbol instead of escaping slashes

Posted on: 1/29/2008

We all had to at one point or another modify a file path and escape the slashes before pasting it into our code or into a database table. Using the @ symbol in front of the string will eliminate the need to modify the path.

How To: Create and populate a DataTable manually

Posted on: 1/29/2008

This article will demonstrate how to create a DataTable manually and populate it with some random data.

How To: Easily take your ASP.NET 2.0 web application offline for maintenance updates

Posted on: 12/06/2007

This article describe how to easily take your ASP.NET 2.0 web application offline.

Error: System.Data.OracleClient.OracleException: ORA-01460: unimplemented or unreasonable conversion requested

Posted on: 12/05/2007

If you are using the Microsoft Oracle provider to call an Oracle Stored Procedure and passing a lot of data to a CLOB parameter, you get the following exception: ORA-01460: unimplemented or unreasonable conversion requested. This article will describe how to fix this.

How To: Separate your connectionStrings and appSettings configuration settings into external configuration files

Posted on: 12/04/2007

In this article, we will describe how to separate your connection strings and appSettings into external files from your web.config or app.config.

PLSQL: How to execute an Oracle package with a stored procedure and output the refcursor (reference cursor) results

Posted on: 9/27/2007

The article will demonstrate how to execute an Oracle stored procedure with an output reference cursor and printing the results.

SQL Basics: INSERT Statement

Posted on: 7/26/2007

The INSERT statement is used to insert a new row into the table

PLSQL: Return x number of rows in PL/SQL

Posted on: 7/18/2007

This article describes how to return the top x number of record.

TSQL: Return x number of rows

Posted on: 7/13/2007

This article describes how to return the top x number of record

SQL Basics: SELECT Statement

Posted on: 6/29/2007

SQL Select statement