sqlHelper exception handling

[=?Utf-8?B?Ymlj?=]

Hi,

Calling my method below how does my page caller display the exception since
the return type is int?

int ret = 0;
string spname = "sp_UpdateAd";
try
{
//Retrieve the parameters from the cache
SqlParameter[] storedParams =
SqlHelperParameterCache.GetCachedParameterSet( connString, spname );
if( storedParams == null )
{
//Cache the parameters
SqlParameter[] paramsToStore = new SqlParameter[]
{

};
SqlHelperParameterCache.CacheParameterSet( connString, spname,
paramsToStore );
storedParams = paramsToStore;
}
ret = SqlHelper.ExecuteNonQuery( _trans, CommandType.StoredProcedure,
spname, storedParams );
}
catch( Exception ex ) { throw; }
finally{} // Do NOT dispose connection

return ret;

Thanks,

--
bic

[sloan]

I'd read this:

http://blogs.msdn.com/kcwalina/archi...16/396787.aspx

since you have a "throw", the exception gets bubbled up.

the "page" you have would probably catch the exception, and then display a
message to the user.

in winforms, if you don't handle the exception in the "page", your app will
crash.

in webforms, if you don't handle the exception in the "page", your page will
show a nasty dotnet type exception message.
"bic" <bi*@discussions.microsoft.comwrote in message
news:89**********************************@microsof t.com...

Hi,

Calling my method below how does my page caller display the exception
since
the return type is int?

int ret = 0;
string spname = "sp_UpdateAd";
try
{
//Retrieve the parameters from the cache
SqlParameter[] storedParams =
SqlHelperParameterCache.GetCachedParameterSet( connString, spname );
if( storedParams == null )
{
//Cache the parameters
SqlParameter[] paramsToStore = new SqlParameter[]
{

};
SqlHelperParameterCache.CacheParameterSet( connString, spname,
paramsToStore );
storedParams = paramsToStore;
}
ret = SqlHelper.ExecuteNonQuery( _trans, CommandType.StoredProcedure,
spname, storedParams );
}
catch( Exception ex ) { throw; }
finally{} // Do NOT dispose connection

return ret;

Thanks,

--
bic