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