Unable to edit data in DataView/Datable. Column is read only??

[Antonio Ooi]

Hi,

I did this but failed:

dtbResultConfig.Rows(0).BeginEdit()
' Hit a 'Column 'FKTableName' is read only error at the line below
dtbResultConfig.Rows(0)("FKTableName") = "something"
dtbResultConfig.Rows(0).EndEdit()
dtbResultConfig.AcceptChanges()

Can anyone helps? Thank in advance!

Antonio

[Antonio Ooi]

Solved. Do not use:

sqlAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

if you planned to edit your data in within the DataTable or DataView.
Thanks.

Antonio

"Antonio Ooi" <an*******@homail.com> wrote in message
news:eE**************@TK2MSFTNGP09.phx.gbl...

Hi,

I did this but failed:

dtbResultConfig.Rows(0).BeginEdit()
' Hit a 'Column 'FKTableName' is read only error at the line below
dtbResultConfig.Rows(0)("FKTableName") = "something"
dtbResultConfig.Rows(0).EndEdit()
dtbResultConfig.AcceptChanges()

Can anyone helps? Thank in advance!

Antonio