default value assigned to SqlParameter that can be overwritten

[confused]

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

[Bob Grommes]

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" <an*******@discussions.microsoft.com> wrote in message
news:06****************************@phx.gbl...

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" <an*******@discussions.microsoft.com> wrote in messagenews:06****************************@phx.gbl...

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

.