Sunday, March 11, 2012

Value Cannot Be Null Parameter Name: dataTable ERROR

JT,

The GetChanges call is returning null, because there is no changed information in your DataSet. When you add a new row in the way that you are doing it, you need to add the DataRow to the table as your last step. The DataRow that is returned by NewRow is not part of the DataTable until you add it. In the following code:

Dim NEWLedgerRow As CommandryDataSet.TBLLedgerRow
NEWLedgerRow = CommandryDataSet.TBLLedger.NewRow

NEWLedgerRow.CheckNum = "0"
NEWLedgerRow.MemID = MemIDTextBox.Text

Add the line

CommandryDataSet.TBLLedger.AddRow(NEWLedgerRow)

and your update should work.

Thanks,
Erick Thompson

No comments:

Post a Comment