I'd like to submit the default value of a SQL column as the value to send in
my parameter. I know you can use DBNull.Value to enter NULLs. Is there a
way to enter the DEFAULT value?

i.e. in sql it would look something like UPDATE MyTable SET MyColumn =
DEFAULT

in .NET I want to write something like

SqlParameter myParam = new SqlParameter("@MyColumn", SqlDBType.Varchar, 20);
myParam.Value = Default.value;

On Wed, 9 Feb 2005 17:46:21 -0000, "Janaka" <(E-Mail Removed)> wrote:

¤ I'd like to submit the default value of a SQL column as the value to send in
¤ my parameter. I know you can use DBNull.Value to enter NULLs. Is there a
¤ way to enter the DEFAULT value?
¤
¤ i.e. in sql it would look something like UPDATE MyTable SET MyColumn =
¤ DEFAULT
¤
¤ in .NET I want to write something like
¤
¤ SqlParameter myParam = new SqlParameter("@MyColumn", SqlDBType.Varchar, 20);
¤ myParam.Value = Default.value;
¤

Can't you just set the default value for the column at the database level and omit the parameter
from your update query?


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)

Unfortuanately no. It is an optional field and may have user input or it
may not.


"Paul Clement" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Wed, 9 Feb 2005 17:46:21 -0000, "Janaka" <(E-Mail Removed)> wrote:
>
> ¤ I'd like to submit the default value of a SQL column as the value to
> send in
> ¤ my parameter. I know you can use DBNull.Value to enter NULLs. Is there
> a
> ¤ way to enter the DEFAULT value?
> ¤
> ¤ i.e. in sql it would look something like UPDATE MyTable SET MyColumn =
> ¤ DEFAULT
> ¤
> ¤ in .NET I want to write something like
> ¤
> ¤ SqlParameter myParam = new SqlParameter("@MyColumn", SqlDBType.Varchar,
> 20);
> ¤ myParam.Value = Default.value;
> ¤
>
> Can't you just set the default value for the column at the database level
> and omit the parameter
> from your update query?
>
>
> Paul ~~~ (E-Mail Removed)
> Microsoft MVP (Visual Basic)

On Thu, 10 Feb 2005 13:36:05 -0000, "Janaka" <(E-Mail Removed)> wrote:

¤ Unfortuanately no. It is an optional field and may have user input or it
¤ may not.
¤

I don't think I understand your reply. If you're using a default value when the field is not
specified then what different does it make whether you specify it at the query level, or the
database level?


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)