Defaults in Column Mappings

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

Guest

Dear All,

I have designed a DataAdapter which reads data from a table. The table has
an auto-incrementing Primary Key. None of the columns in the table accept
Nulls although some of the columns do have defaults.

My question is - Is there an automatic method of filling these properties on
the table when I call the fill method, or do I have to manually key the
properties for each column when the table has been filled?

Thanks in advance for your assistance

Mike
 
Sorry, just to be more specific - it is the column defaults which I want to
be populated.

Thanks

Mike
 
Thanks for this Cor, but what I want is for the adapter (or some other
object) to read the default information from the database schema and populate
the default property in the datatable's datacolumn.

Does this make sense?
 
Mike,
Does this make sense?
Click to expand...
Yes however that is not done. I have seen many flaming messages to Microsoft
about this how stupid they are not to implement this. However don't forget
that AdoNet connects to all kind of databases. It should be an SQL function
to get this from the schema.

It does not help you, however now you know.

Cor
 
Back
Top