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

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



"pelegk1" wrote:


> 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
> 
>