hebelurbele
New Member
I have been doing classing ASP and pretty new to ASP.NET. In classic ASP, I am normally response.write all the submitted values, make sure I am able to capture correct values, put those values in the SQL String, then response.write the SQL string before insert to SQL Server.This helps to troubleshoot when there is an "SqlException" error, I just need copy/paste the whole query string in Server Management Studio and run it.I wonder if there is any option in ASP.NET in which can perform sililiar like classic ASP. In ASP.Net, it display some errors, but it doesn't show the value that I am submitting. For example, "[SqlException (0x80131904): Incorrect syntax near ']'", I know where the problem in the query after review in the codes, but I would like to write whole the query string (with values submitted) in the screen so I can copy/pasted it in SQL Server Management Studio to troubleshoot it easier. Thanks in advance.