SqlDataAdapter, insert, DBNull problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marius Horak - 31 Mar 2004 09:42 GMT

Hello,

Update(DataTable) fails with HasErrors set to true.
This is due that some columns have DBNull value.
But those columns are defined as NULL (SQL Server).
Is it a dotnet bug or null values are not allowed?

Thanks

MH

Reply to this Message

Jon Skeet [C# MVP] - 31 Mar 2004 09:59 GMT

> Update(DataTable) fails with HasErrors set to true.
> This is due that some columns have DBNull value.
> But those columns are defined as NULL (SQL Server).
> Is it a dotnet bug or null values are not allowed?

Please give more details of your exact schema, the exact exception, and
your code.

Signature

Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Reply to this Message

Marius Horak - 31 Mar 2004 14:01 GMT

Thank you for reply.
Problem not important any more as the table in question is no longer in use.

MH

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...