How do I populate the DataColumn.DefaultValue property from SQLServer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I populate the DataColumn.DefaultValue property from SQLServer
i.e
I have a table in SQLServer. One of its columns has a default value. This column is populated with the default value when I insert a record and don't specifically set a value for the column
When I create a DataTable from the table's schema the corresponing DataColumn's DefaultValue property does not get set. So when I do DataTable.Rows.Add(NewDataRow) with a DataRow that does not specifically set a value for the column the column remains blank.
 
You will need to set this yourself when the DataTable is constructed.

myColumn.DefaultValue = "defaultValue" or something like this.


Dick said:
How do I populate the DataColumn.DefaultValue property from SQLServer?
i.e.
I have a table in SQLServer. One of its columns has a default value. This
Click to expand...
column is populated with the default value when I insert a record and don't
specifically set a value for the column.
When I create a DataTable from the table's schema the corresponing
Click to expand...
DataColumn's DefaultValue property does not get set. So when I do
DataTable.Rows.Add(NewDataRow) with a DataRow that does not specifically set
a value for the column the column remains blank.
 
I should add, there are properties on DataAdapter that you can set to
retrieve more or less schema info on your Select. MissingSchemaAction and
FillSchema will be your friends here. Pretty sure neither are nice enough
to return the Default Value though.


Dick said:
I don't want to hardcode the column's default value in my code. I want to
Click to expand...
set it to the value already assigned to the column in the database. i.e. in
the same way that I don't hardcode the table name, the column names, their
data types, etc., I don't want to hard code their default values either.
Because that would duplicate my business rules in both the database and in
my code!
So, is it possible to effect the way the table's schema is retrieved from
Click to expand...
SQLServer such that the default value information is retrieved? Or is there
another way?
 
Hi Richard,

I agree with Greg that we cannot retrieve the default value property with
DataAdapter from SQL server. We can only set the default value in a strong
typed dataset's schema manaully. For example:

<xs:element name="age" type="xs:int" minOccurs="0" default="34" />

When we create a dataset from this schema, it will has a default value for
column "age".

Hope this help,

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Back
Top