How can I see the parameters as I passed them to SP? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How can I see the parameters as I passed them to SP?

Message

From

27/05/2008 16:24:05

John Baird
Coatesville, Pennsylvania, United States

To

27/05/2008 15:25:24

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

ASP.NET

Category:

Coding, syntax and commands

Title:

Re: How can I see the parameters as I passed them to SP?

Environment versions

OS:

Windows XP

Database:

MS SQL Server

Miscellaneous

Thread ID:

01319767

Message ID:

01319795

Views:

14

This message has been marked as the solution to the initial question of the thread.

>Hi everybody,
>
>I'm passing parameters to SP and using InsertCommand for SQLDataSource. The error coming from the SP tells me that one of the parameters is NULL, but it should not be NULL, I believe.
>
>Do you know how can I get parameters (and in which method) how they were passed to SP?
>
>Thanks a lot in advance.

Use the sql profiler to view the commands going to sql server..

Click here to load this message in the networking platform