NetNut wrote:

> Dim Cn As SQLClient.SqlConnection = New SqlCilent.SqlConnection(ConfigurationSettings.AppSettings("SQLConn"))
> CN.Open
>
> Dim Cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand("@sp_Test", Cn)
>
> C.
> Cn.Close
>
> Cn = Nothing
> Cmd = Nothing

I always use C. For more information check out
http://blogs.sqladvice.com/dpenton/a...03/16/786.aspx

--
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/

Aaron Weiker wrote:

> I always use C. For more information check out
> http://blogs.sqladvice.com/dpenton/a...03/16/786.aspx
>

Yeah, I forgot to mention, I also through in a Dispose to Connection. I
program using C# so I just use the "using" statement which handles this
automatically for me.


--
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/