Hi,

 I'm not used to using datacontainers, and I generally use a using statement for sql operations such as:

using (conn = new SqlConnection(connString))
{
  //etc
}

What about if I'm using a dataset or data adapter. I put the connection in the constructor, but should this be inside a using block?

 Thanks.

What I do with my sites is put a try catch in all event handlers, since these are called from within the "system", any exception will force the page to fall over.

Unless I need some special granularity, this minimum of handlers is sufficent

I also have an SQL table that logs all exceptions, holding the the text of the exception, as well as the stack trace.

As a last resort, an error page is used to capture anything I missed

You can then continue with the using statement as this self disposes for you in the pre-compiler

Yeah I just went ahead and used a using statement. Works great. Thanks.

using (SqlConnection conn = new SqlConnection(_pasteConInfo.PasteConnectionString))
        {
            DataSet data = new DataSet();
            data.DataSetName = "PasteEntries";
            SqlDataAdapter adapter = new SqlDataAdapter("EXECUTE sp_getCode 1", conn);
            adapter.Fill(data, "entryTable");
            XmlDocument doc = new XmlDocument();
            doc.LoadXml(data.GetXml());

            XmlWriter writer = null;
            writer = XmlWriter.Create(Response.Output);
            doc.Save(writer);
        }
        Response.End();