>Hi everybody,
>
>The following piece of code I would assume is supposed to put carriage return between each delete and insert, right?
>

>strSQL.AppendFormat("DELETE EventTargets WHERE EventID = {0}\n",
>                e.Keys["EventID"]);
>
>            foreach (ListItem Item in lsbTargets.Items)
>            {
>                if (Item.Selected)
>                {
>                    strSQL.AppendFormat("INSERT INTO EventTargets VALUES({0},'{1}')\n",
>                        e.Keys["EventID"], Item.Value);
>                }
>            }

>
>However, I see DELETE EventTargets where EventID=32INSERT... in the debugger. So, apparently my guess that \n is supposed to be CRLF is wrong.
>
>Or do you see what else may be wrong in this code?

Try '\r\n'. But best practice is probably to use Environment.NewLine instead (or use the StringBuilder.AppendLine method)