Generic SQL and .NET help [RESOLVED]

[Dador]

Heyas!

Did the usual searching...couldn't come up with anything...

I'm new to .NET, but have a good grasp of VB6.

Anyway, I'm sure I have a configuration error, but I can't figure out where. Seems like .NET is much more strict about having your program setup the exact way it wants...

Ok, I have a simple Windows app that is trying to read and write to a SQL Server on the company network.

I'm using an OleDb dataadapter and connection. (Never could get the SQL data components working...). I don't get any errors when I create the components through the wizard, everything looks good.

I can also read the SQL Server table and dump it all in the dataadapter/dataset without issue.

As far as writing, I can't update any of the fields in a given row if that row has null values in it. Even if the field I'm dealing with doesn't have a null, as long as there is a null somewhere in the row it throws an error. I set the data adapter to update on error anyway (not caring about the other fields) but of course it doesn't do anything but move on.

In any case, I'm sure this is a configuration error with my data adapter or some other property I need to set. I've looked everywhere, including my numerous books, but can't seem to hit on the right search string to find my answer.

Thanks for any help!