SQL Server :: How To Debug A Very Complicatedm Sql Query

I want to debug a very complicatedm sql query, i am using parameterized style, to easier for me to debug, i want to print out the FULL query before the query hasbeen executed which we can super easy done in classic ASP by just using :

Response.Write (MySQLStatement)

Response.End

But how about in .NET, i want a simple & faster way like the classic ASP has. Anyway is it possible to print it out with FULL(+Parameter values) in .NET?

Example:

string userName = "MyName";
string cmdString = "Select user_id from users where user_name='" + userName + "'";

I want to print out the result as:

Select user_id from users where user_name='MyName';