// answers in line
On Thu, Oct 7, 2010 at 6:00 AM, Gourav <[email protected]> wrote:
> Hi All ,
> I just make a connection class in App_code .But i didn't know what
> i write in catch block for Error exception.Any body can tell me ??
> i'll wait for reply.....
> and one more thind what is differance between
> catch and catch (Exception ex)....means in which condition we use it
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
> public static void ExecuteNonQuery(string query)
-----------------
Does it matter at all? This is a void, thus you don't care what
happens in the process.
Why not return a string?
> {
> SqlConnection Scon = new
> SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
> Scon.Open();
StringOhNo;
> try
> {
> SqlCommand cmd = new SqlCommand();
> cmd = Scon.CreateCommand();
> cmd.CommandType = CommandType.Text;
> cmd.CommandText = query;
OhNo = cmd.ExecuteNonQuery() > 0 ? "cool" : "no records manipulated";
>
> }
> catch (Exception ex)
> {
OhNo = ex.Message;
> }
>
> finally
> {
> Scon.Close();
> }
return OhNo;
> }
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
--
Stephen Russell
Sr. Production Systems Programmer
CIMSgts
901.246-0159 cell
