How do I debug SQL with Visual Studio?

[Javamahn]

I am using a formview which created the parameters and an Insert Statement as part of the wizard. The submit button does a postback but no new data is entered into the table. How can I trace what is happening? I would like to debug and use a watch. I double clicked the Submit button but I am not sure what to code for the onclick event. The insert is part of the page and not done using behind programming. Thank you for any help you can give.

 

[jbenson001]

If you are using a datasource control to do your data access/manipulation, then you cannot debug. You should write your own code or use something like Microsoft's Data Access Block.

 

[kss444]

I would say the problem is with you DB connection or you sql statment. I would take a look at the wizard again, and make sure everything is correct.

Ordinary Programmer