Hi Dharmendr,
Many thanks again for your assistance.
Here is what I found.
dtAirInfoTable Datatable has the following columns:
MarineRegNo
VesselRegNo
TaxPyrRetVal
VesselTaxPyrRetdVal
regtable datatable is supposed to have the following:
txBoatRegNum
txTaxPayerRet
txVesselRegNum
txVTaxPayerRet
but it doesnt show them in the columns row.
I had to drill down to find the following:
MarineRegNo
VesselRegNo
TaxPyrRetVal
VesselTaxPyrRetdVal
Then ItemArray has
txBoatRegNum
txTaxPayerRet
txVesselRegNum
txVTaxPayerRet
However, the value for txBoatRegNum is BP900 which is
row.ItemArray[1] but it is wrong.
That value belongs to txVesselRegNum which is
row.ItemArray[4] but not only does it not have that value, it doesn't even show it as an array.
By the way, txBoatRegNum is supposed to have same value as MarineRegNo, txTaxPayerRet is supposed to have same value as TaxPyrRetVal,
txVesselRegNum is supposed to have same value as VesselRegNo and txVTaxPayerRet is supposed to have same value as VesselTaxPyrRetdVal.
Everything is just messed up.
This is sad.
I just wanted to add that if I try saving records for the first time and I run the debugger, everything comes out fine.
In other words, txBoatRegNum,txTaxPayerRet,txVesselRegNum, txVTaxPayerRet, all come out with correct values.
It is only when the record is already in the DB and I pull them up that they are out of order.