This is what I get when I copy value

{DELETE EventTargets WHERE EventID = 32
INSERT INTO EventTargets VALUES(32,'A')
}

so I guess I just can not see it correctly in debugger.

Now, in IE I see very nice error message when I try something to cause the problem, but in other cases it saves correctly.

In FireFox when I press Update button and make even a simplest change (say, add a . to a description field), it simply does nothing and remains in Update mode.

This is very frustrating. I know what I should do to fix the particular little problem in IE, but I spent already several days trying to figure out how to debug or find what's wrong in FireFox version.

Any help or ideas from ASP.NET gurus?

Thanks in advance.



>>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.
>
>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?
>
>Anyway, looks like the particular piece of code is executing even if I see it wrongly in debugger.
>
>However, for some reason it only executes in IE and does nothing in FireFox.