I use a stored procedure to retrieve data from a SQL Server 2000 dB using
Data.SqlClient.SqlDataAdapter to fill a DataTable. In SQL several columns of
the table have default values but the DefaultValue of each DataColumn is
always System.dbNull (which causes a problem with the InsertCommand).
We can fix the problem in the stored procedure for the InsertCommand but
that means we have to maintain the column default values in two places (ie
the table definition and the InsertCommand stored procedure, actually we
probably need to do it for the UpdateCommand SP as well).
It's hard to believe that this is true - am I missing something?