dot net and sql server-2 quetion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pelegk1 - 13 Aug 2007 23:30 GMT

1)when i call to a Stored Procedure
and for exampe i do :
myCommand.Parameters.Add("@flag", Data.SqlDbType.Int)
myCommand.Parameters("@flag").Value = DEAULT
how can i pass a DEFAULT value tothe stored procedure (in which the stored
procedure for the specific variable uses its default defined value)?
2)how /what do i nedd to define and how do i get the returned vale,which i
return from the Stored Procedure
thnaks in advance
peleg

Reply to this Message

Peter Bromberg [C# MVP] - 14 Aug 2007 01:00 GMT

Typically if you want the sproc to use the default value for a parameter, you
would either pass null or System.DbNull.Value as the parameter value.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

> 1)when i call to a Stored Procedure
> and for exampe i do :
[quoted text clipped - 6 lines]
> thnaks in advance
> peleg

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...