Hi,

I want to assign a default value of DBNull.Value to my
stored procedure parameter, but also have the ability to
overwrite it, so:


SqlParameter param = new SqlParameter
("@EmployeeId",SqlDbType.Char,10);
param.Value = DBNull.Value; //but want to overwrite maybe
cmd.Parameters.Add(param);

How can I do this?

thanks in advance

Hello Confused,

cmd.Parameters.Add(new SqlParameter("@EmployeeId",SqlDbType.Char,10));
cmd.Parameters["@EmployeeId"].IsNullable = true;
cmd.Parameters["@EmployeeId"].Value = DBNull.Value;

// later

cmd.Parameters["@EmployeeId"].Value = somethingElse;

Or, to be more efficient:

SqlParameter param = new SqlParameter("@EmployeeId",SqlDbType.Char,10);
param.IsNullable = true;
param.Value = DBNull.Value;
cmd.Parameters.Add(param);

// later

cmd.Parameters["@EmployeeId"].Value = somethingElse;

// or, if you still have the param reference around, you can still use it:

param.Value = somethingElse;

--Bob

"confused" <(E-Mail Removed)> wrote in message
news:06a601c52984$16abd8f0$(E-Mail Removed)...
> Hi,
>
> I want to assign a default value of DBNull.Value to my
> stored procedure parameter, but also have the ability to
> overwrite it, so:
>
>
> SqlParameter param = new SqlParameter
> ("@EmployeeId",SqlDbType.Char,10);
> param.Value = DBNull.Value; //but want to overwrite maybe
> cmd.Parameters.Add(param);
>
> How can I do this?
>
> thanks in advance

cheers bob, i'll give it a go
>-----Original Message-----
>Hello Confused,
>
>cmd.Parameters.Add(new SqlParameter
("@EmployeeId",SqlDbType.Char,10));
>cmd.Parameters["@EmployeeId"].IsNullable = true;
>cmd.Parameters["@EmployeeId"].Value = DBNull.Value;
>
>// later
>
>cmd.Parameters["@EmployeeId"].Value = somethingElse;
>
>Or, to be more efficient:
>
>SqlParameter param = new SqlParameter
("@EmployeeId",SqlDbType.Char,10);
>param.IsNullable = true;
>param.Value = DBNull.Value;
>cmd.Parameters.Add(param);
>
>// later
>
>cmd.Parameters["@EmployeeId"].Value = somethingElse;
>
>// or, if you still have the param reference around, you
can still use it:
>
>param.Value = somethingElse;
>
>--Bob
>
>"confused" <(E-Mail Removed)> wrote
in message
>news:06a601c52984$16abd8f0$(E-Mail Removed)...
>> Hi,
>>
>> I want to assign a default value of DBNull.Value to my
>> stored procedure parameter, but also have the ability
to
>> overwrite it, so:
>>
>>
>> SqlParameter param = new SqlParameter
>> ("@EmployeeId",SqlDbType.Char,10);
>> param.Value = DBNull.Value; //but want to overwrite
maybe
>> cmd.Parameters.Add(param);
>>
>> How can I do this?
>>
>> thanks in advance
>
>
>.
>