>>>>AppendFormat just adds to the end of a string. It allows you to "parameterize" content of the string. It has nothing to do with CR/LF.
>>>
>>>Fred,
>>>
>>>I read the help of AppendFormat function. My question was WHY I do not see some sort of visual indication that I have CRLF in the generated string in the Debugger.
>>
>>If there's a CR or other special character I see a square in the debugger.
>>
>
>Hmmm, why I don't see anything then? Could be some VS setting I have to adjust?
>
>>>
>>>In fact the string seems to be correct, because ExecuteNonQuery returned 2 (number of rows affected).
>>>
>>>I'm also wondering, why in the code there is no CATCH block
>>>
>>> try
>>> {
>>> Command.Connection.Open();
>>> Result = Command.ExecuteNonQuery();
>>> }
>>> finally
>>> {
>>> if (Conn.State == System.Data.ConnectionState.Open)
>>> Command.Connection.Close();
>>> Conn.Dispose();
>>> }
>>> return Result;
>>>
>>>
>>>
>>>Do we supress the exception this way if it occurs?
No. If an exception is thrown the code in the finally{} block is executed then the exception is passed up the chain. It's a valid construct but probably not used a great deal.
HTH,
Viv