Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DefaultValue not set in columns of Data.DataTable VS2005
0 views
Skip to first unread message
Charles Waudby
May 8, 2007, 10:24:01 AM5/8/07
to
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).
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?
0 new messages