Debug ASP.NET pages using Tracing

In Classic ASP one might debug some code using VB Script:

Response.Write strSQL

and the comment/uncomment the code accordingly. This was a bit of a pain during the development process. In ASP.NET, one can use the Trace feature which simplifies matters somewhat. Page-level tracing can be set in the Page directive on the ASPX page:

<%@ Page Language="c#" Trace="true"%>

and in the code one could use:

string strSQL="select * from " + Table + " " + WhereClause + " order by " + OrderingColumn;

When the page is run in the browser, you'll see:

So, you'd be able to see the SQL that is executed. By using Trace.Warn instead of Trace.Write, the line would be highlighted in Red. When the application is deployed, you'd simply disable tracing by setting the Trace attribute to false. If you have many pages that you wish to trace, then it may be more viable to set the tracing in your web.config file:

    <trace enabled="true" requestLimit="20" pageOutput="true" traceMode="SortByCategory" localOnly="true" />

So, you can easily enable/disable tracing as required.

You might also like...


Julian Roberts I've been a freelance web developer since Feb '00. Prior to that, I'd spent most of my working life in the pub trade. I'd also worked as a security guard in a local factory. Luckily, I was able to ...


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“To iterate is human, to recurse divine” - L. Peter Deutsch