Peter Nordberg
asked on
Printing out sql query on screen
I would like to be able to see my sql querys on screen (or in any other way) when debugging.
In classing asp I could just print out the query with it's values like
sql = "Select * from table where id = " & request("id")
set rs = conn.execute(sql)
response.write(sql)
then I could see what values where in the query.
How can I get a similar result in asp.net?
In classing asp I could just print out the query with it's values like
sql = "Select * from table where id = " & request("id")
set rs = conn.execute(sql)
response.write(sql)
then I could see what values where in the query.
How can I get a similar result in asp.net?
You can also use System.Diagnostics.Debug.W riteLine to set it in the Output window.
Bob
Bob
ASKER
How do I do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, I'll try
Dim sql As String
Sql = "Select * from table where id = " & Request("id")
Response.Write(Sql)
End Sub