When I try to use this code as is, I get the error "CommandBehavior is not declared".

Also, when I paste the code into VS2005, SqlConnection, SqlCommand, and SqlDataReader are underlined in blue. The error is that they are not defined. When I use the suggestion to convert SqlConnection to Data.SqlClient.SqlConnection, the error goes away.

Can anyone tell me what i'm doing wrong?

Thanks!

The compile is basically saying it does not know what those objects are because it does not know where to find their definitions.

You need to either fully qualify each object with its full namespace path (eg System.Data.SqlClient.SqlConnection) so the compile knows where to locate those objects, or you can add a "using" statement if your coding in C# (or Import for VB) to your code to tell the compiler what namespaces are available in your code.

C#: using System.Data.SqlClient;

VB: Import System.Data.SqlClient

Devin