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


None that I'm aware of. I didn't change anything that I can recall.


>
>>>
>>>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?
>>
>>I've never seen that particular construct used.
>
>Do you mean you never saw try without a catch?


Yes, that's what I mean. I've never seen a try without a catch.