Not supported?..

[TJ]

Hi,

C# / .NET Framework 1.1

I would like to query extended stored procedure like stored procedure...
However, I found that CommandType property does not have Extended Stored
Procedure value.....

I tried something like..

SqlConnection con = new SqlConnection(....);
SqlCommand command = new SqlCommand('xp_blahblahblah", con);
command.CommandType = CommandType.StoredProcedure;
......
....
command.ExecuteScalar();

However, it always throw exception saying "Could not find store procedure
xp_blahblahblah"....
Is there any way I can use the extended stored procedure programatically?

Thanks.

.................................................. .................TJ

[Cowboy \(Gregory A. Beamer\)]

Wrap it with a "normal" stored procedure. There may be another way, but SQL
Server is touchy on its possessions, which extended sprocs are. Ask in the
SQL Server programming group, also, as there are some great peeps in there
that know a lot about programming .NET against SQL Server.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************
"TJ" <[e-mail]> wrote in message
news:B9**********************************@microsof t.com...

Hi,

C# / .NET Framework 1.1

I would like to query extended stored procedure like stored procedure...
However, I found that CommandType property does not have Extended Stored
Procedure value.....

I tried something like..

SqlConnection con = new SqlConnection(....);
SqlCommand command = new SqlCommand('xp_blahblahblah", con);
command.CommandType = CommandType.StoredProcedure;
.....
...
command.ExecuteScalar();

However, it always throw exception saying "Could not find store procedure
xp_blahblahblah"....
Is there any way I can use the extended stored procedure programatically?

Thanks.

.................................................. ................TJ