dot net and sql server-2 quetion

[Guest]

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

 

[Guest]

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