471,349 Members | 1,967 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,349 software developers and data experts.

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

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
Jul 21 '05 #1
1 2741
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

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by D Witherspoon | last post: by
14 posts views Thread by Able | last post: by
reply views Thread by Henry | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.