472,993 Members | 1,772 Online

Home Posts Topics Members FAQ

home > topics > unable to edit data in dataview/datable. column is read only??

Join Bytes to post your question to a community of 472,993 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

Subscribe Post Reply

1

2801

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

ADO.net: 3 Data Set Questions (Issues)

by: Mr. B | last post by:

I'm updating my current VB.et application. I currently reads about 6 tables from an MS Data base. I've created a new MDB file which combines the 6 tables into 1 table. I'm doing this because I...

Data/Business Object Tier Best Practices

by: D Witherspoon | last post by:

I am developing a Windows Forms application in VB.NET that will use .NET remoting to access the data tier classes. A very simple way I have come up with is by creating typed (.xsd) datasets. For...

DataView loop and edit?

by: Able | last post by:

Dear friends Dim myDataView as DataView = New DataView(dsData.Tables("tblCustomers")) myDataView.RowFilter = "City = 'London'" My question is how to loop through all rows in myDataView and...

Visual Basic .NET

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

by: Antonio Ooi | last post by:

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"...

Trying to extract Data from a DataTable

by: Henry | last post by:

My DataTabel has the following columns: org_id, org_name, parent_id DataTable dt = dsMyData.Tables; This next statement should create a data view with filter that results in one row ...

Filtering data inside the Gridview Control?

by: | last post by:

Hello, Does anyone have an idea on how I can filter the data in the gridview control that was returned by an sql query? I have a gridview that works fine when I populate it with data. Now I...

Binding data to a server control inside repeator control

by: muthu | last post by:

Hi guys, Iam using a repeator control in my page.In wich i have dropdown list as the last column.I have a label in the first column.Now i have binded a datable to the repeator in the page load...

setting BindingSource data types from an XML data source

by: michael sorens | last post by:

I have successfully bound an XmlDocument to a DataGridView but all fields seem to be strings. I want to retrofit appropriate datatypes on some of the fields. Let me take this in 2 parts. Part...

(v2003) Datagrid Dropdownlist Edit Problems

by: bh | last post by:

I'm trying to edit data in a datagrid through a dropdown list with different id/text values. The problem comes in when I click the edit button & nothing appears to be happening. Did I do...

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

Applying ComboBox filters Sequentially

by: SueHopson | last post by:

Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

Microsoft Access / VBA

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.

BYTES.COM © 2023
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!