Is there a way i can debug through the Sql script in my SqlDataSource ....

microsoft.public.dotnet.framework.adonet

30 Mar 2006 7:47 AM

jens Jensen

Hello,
I'm very excited about the new SqlDataSource in asp.net 2.0.

I have written a wuite long sql script on my SqlDatasource UpdateCommand.

I want to see wheater it actually does what it was meant to do.

Is there any way i can do this?

Many thanks
JJ

30 Mar 2006 4:28 PM

Cowboy (Gregory A. Beamer) - MVP

This is a wonderful "it depends" answer type of question.

If you are using VS 2005 with SQL 2005 (Express can work), you can
automagically step through a stored procedure directly from code. It is
easiest if you have code projects.

If not, you can step through any supported database's sprocs by opening the
sproc and choosing intervening at the point of calling (supplying values to
the sproc and running in the GUI). This is not automagic.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

Show quote

"jens Jensen" wrote:

>
> Hello,
> I'm very excited about the new SqlDataSource in asp.net 2.0.
>
> I have written a wuite long sql script on my SqlDatasource UpdateCommand.
>
> I want to see wheater it actually does what it was meant to do.
>
> Is there any way i can do this?
>
> Many thanks
> JJ
>
>
>

30 Mar 2006 8:15 PM

jens Jensen

Many thanks
JJ