jwcolby
jwcolby at colbyconsulting.com
Fri Jul 23 14:05:14 CDT 2010
OK so I want to do the right thing, I just don't know how. 8( In the following code, I want to declare the connection and command object outside the try, initialize the two objects inside of a try, catch any errors, and finally cleanup. The objects in the finally say that they were never initialized. If I put them inside of the try, it complains that the objects aren't valid in the scope of the finally. If I initialize them outside of the try it isn't using a try and errors will not be handled. It seems that I am damned any way I look at this. namespace projBaseObjects { class clsSQLReadWrite { public static void ExecuteNonQuery(string strCnn, string strSQL) { SqlConnection mCnn; SqlCommand myCommand; try { mCnn = new SqlConnection(strCnn); mCnn.Open(); myCommand = new SqlCommand(strSQL, mCnn); myCommand.ExecuteNonQuery(); } catch (SqlException) { throw; } catch (Exception) { throw; } finally { myCommand.Dispose(); mCnn.Close(); } } } } -- John W. Colby www.ColbyConsulting.com