default value assigned to SqlParameter that can be overwritten

  • Thread starter Thread starter confused
  • Start date Start date
C

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

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
Click to expand...


.
Click to expand...
 
Back
Top