Date: 01/13/05 (Asp Dot Net)    Keywords: asp, sql, web

I'm having some trouble with tracing. I have a static class whose method I call from a page that I'd like to get trace data from. The method looks like:

public sealed class DbUtils
{
static public int ExecuteNonQuery(string sql, string dsn)
{
  Trace.WriteLine("SQL", sql);
  int rowsAffected;

  OdbcConnection db     = new OdbcConnection(dsn);
  db.Open();
  OdbcCommand    cmd    = new OdbcCommand(sql, db);
  rowsAffected = cmd.ExecuteNonQuery();
  db.Close();
  return rowsAffected;
}
}

System.Web.HttpContext.Current.Trace.Write("SQL", sql);

Source: http://www.livejournal.com/community/aspdotnet/23616.html