Back to Home
Debugging Process
Table of Contents
Overview
- What you need to know about the debugging process.
- Below lists the process of debugging.
List
If Error Occurs From aspx or cs page.
- Error message usually shows which line is causing the error.
- Go to that line and add a debugger.
- Check all variables and values being passed.
- If all variables are being set with the proper values, locate stored procedure and debug.
Debugging Stored Procedures
- Open the Stored Procedure and insert values to the proper parameters located at the top of the Stored Procedure and EXECUTE.
- High light just the Stored Procedure and EXECUTE.
- If the Stored Procedure runs correctly create a Temp Table and see what values are being passed from the web page.
- If the Stored Procedure DOES NOT run correctly an error message will usually display and show which line the error is occuring.
- When Error Code is located put code block into a new window and break down the issue.