Re: Not supported?..
- From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Jun 2006 19:30:18 -0500
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" <TJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B9D58454-F932-4F55-8962-CB27BDEA3B6A@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Design question
- Next by Date: Re: Why Do Rererences Get Switched?
- Previous by thread: Casting arrays fails at runtime
- Next by thread: Re: Why Do Rererences Get Switched?
- Index(es):
Relevant Pages
|
