End the editing of row
You need to end the rowediting before an update.
Try inserting the below statement prior to sending the datatable for update/delete.
Me.BindingContext(MyDataSet).EndCurrentEdit()
Am not very clear on what u r exactly looking for.
If u need something like applying a filter on the rows of dataset1 and then adding them rows to dataset2, u can do it.
Select method of datatable can be used for this. The Select method takes a filter expression as parameter. The SQL...
One more Tip
One more tip:
if you want to remove a row from the datatable/dataset, but not from the database, u can use Remove method of the datatable.
In contrast to the Delete method, Remove does not delete rows from the database.
use AcceptChanges
Hi
You can call the AcceptChanges method of the newly added datarow immediately. This sets the datarow's RowState to "Unchanged".
Dataadapter decides and performs any action on the dataset rows based on their RowState. If the rowstate is "Unchanged", dataadapter does not...
I have a problem when dealing with identity columns and I request you to provide me a solution. I have described the problem below.
Problem Description:
I am currently developing an application which includes reading data from an excel file and updating around 10 tables in a SQL Sever 2000...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.