Row cannot be located for updating vb
When you data bind dataset tables to controls on a Windows Form or XAML page, the data binding architecture does all the work for you.
If you're familiar with Table Adapters, you can jump directly to one of these topics: Updating a data source is a two-step process.
If the dataset contains constraints (such as foreign keys or non-nullable constraints), it's possible that the record can temporarily be in an error state as you update it.
That is, it can be in an error state after you finish updating one column but before you get to the next one.
When you merge datasets, new records in the source dataset are added to the target dataset.
Additionally, extra columns in the source dataset are added to the target dataset.
For example, you might inadvertently write data of the wrong type to a column, or data that's too long, or data that has some other integrity problem.
A Data Row object is in this state immediately after it has been created, before it has been added to a collection, and after it has been removed from a collection. The Data Row Version fields are used when retrieving the value found in a Data Row using the Item[String, Data Row Version] property or the Get Child Rows method of the Data Row object.However, you can also use different adapters, for example, to move data from one data source to another or to update multiple data sources.If you aren't using data binding, and are saving changes for related tables, you have to manually instantiate a variable of the auto-generated dataset).By using this information, processes can determine what has changed in the dataset and can send appropriate updates to the data source.
The Row State property of a Data Row object is a value that provides information about the status of a particular row of data.For more information about suspending events, see Turn off constraints while filling a dataset.