>>>>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