I have solved this problem now :)
I discovered the output window can be brought back to life. I never expected it to be under View menu. I thought it would be under Debug Windows...doh
If you're using Visual Studio, the strings you send to Debug.Write are displayed in the Output window. (You can view them by running your Web application and then selecting View, Other Windows, Output, or by using the keyboard shortcut Ctrl+Alt+O.)
here is the link that explained it to me
http://www.nedcomp.nl/support/origdocs/dotnetsdk/cpref/frlrfsystemdatasqlclientsqlcommandbuilderclasstopic.htm>I can not seem to get the debug or console command to output anywhere.
>My understanding is that debug outputs to the OUTPUT window, however this window diasappears whenever I run my app.
>
>Or if they are outputting somewhere I can not find it.
>
>I expect I am making some obvious mistake here.
>If these commands can not work in ASP.Net then does it mean I have to add everything to a watch window? This would be clumsy for some operations.
>
>
>
> Debug.WriteLine("Update command Generated by the Command Builder : ")
> Debug.WriteLine("Update command Generated by the Command Builder : ")
> Debug.WriteLine("==================================================")
> Debug.WriteLine(cb.GetUpdateCommand.CommandText)
> Debug.WriteLine(" ")
>
>
>
> Console.WriteLine("Insert command Generated by the Command Builder : ")
> Console.WriteLine("==================================================")
> Console.WriteLine(cb.GetInsertCommand.CommandText)
> Console.WriteLine(" ")