From Visual Studio (C#) - How to indicate a DEFAULT value for a function while calling a sql server function

I have a sql server function that I would like to call from Visual C#. I want to us开发者_开发知识库e the DEFAULT value for one of the parameters. What value should I pass from Visual C# to accomplish this? Thanks, rkg

---

Assuming you mean something like this:

 @MySampleSqlParam VarChar(50) = NULL

Because it's an optional parameter (it has a default supplied), all you need to do is simply not include that parameter when you call the procedure. So just omit adding the SqlParameter to the SqlCommand.Parameters collection.

---

Try this :

cmd.Parameters.Add("@YourParameter", SqlDbTypes.YourType).Value = DBNull.Value;

---

I would pass a nullable type into the function. Just don't pass the parameter if it's null:

public void saveSomething(int? somethingID, string somethingName)
{
     if (somethingID.HasValue)
     {
         //add the parameter
     }         
}

And use a default value in the sproc:

@SomethingID INT = NULL

Obviously, you'll also need to add logic to ignore the condition when the parameter is null.

---

Seems like you are looking for optional parameter in SQL. just Google for optional parameter in SQL.

You can create a function with a preset value for the parameter as:

CREATE FUNCTION dbo.fnMyFunction
(
@Param1 INT,
@Param2 INT = 2 --Default Values is Set no need to get it from parameter
)
RETURNS ..