[Mono-list] DataAdapter.Update throws null constraint violation

plaid cholbr1 at lsu.edu
Fri Feb 3 16:02:56 UTC 2012


I'm also noticing an issue with using 

Dim dsUpdate As DataSet = DataSet.GetChanges()

Wherein it tells me I cannot modify columns marked as ReadOnly; whether I
use a "Generic" DataSet or a Typed DataSet makes no difference to that
premise.
(System.Data.ReadOnlyException: Cannot change a value in a read-only column
in System.Data.DataRow.CheckValue from
System.Data.DataRow.CopyValuesToRow->System.Data.DataSet.AddChangedRow)


...but if I change it to something like

'currDataSet -> Currently In Use DataSet
Dim dsUpdate As DataSet

For Each i As Table In currDataSet.Tables
     Dim temp As Table
     temp = i.GetChanges()
     If Not temp Is Nothing
          dsUpdate.Tables.Add(temp)
     End If
Next i

'Calling The Update From Here Being Vaguely The Same As The Previous
Posting.

It's a bit silly and ridiculous to have to effectively do what
DataAdapter.Update(DataSet, TableName)
should be doing for it... I can't seem to clearly find this in a bug list
anywhere though.  I find it hard to believe there aren't more people having
issues with this sort of thing though as it seems prevalent across
SQLServer, MySQL, NpgSQL, etc. and multiple iterations of Mono and *NIX
Distros... which really, to me, means that DataSet is improperly implemented
at this point.

-----
Ars Longa, Vita Brevis.
--
View this message in context: http://mono.1490590.n4.nabble.com/DataAdapter-Update-throws-null-constraint-violation-tp3727327p4354982.html
Sent from the Mono - General mailing list archive at Nabble.com.


More information about the Mono-list mailing list