Deleting a row from a dynamically populated gridview

[Derek]

Hi,
My radgridview is dynamically populated and I am trying to delete a row. It deletes it from the grid but not from the database. My code is as follows:

'bsMaintenance is the bindingsource

bsMaintenance.RemoveCurrent()

bsMaintenance.EndEdit()

'Save changes

Dim

 

myBuilder As SqlCommandBuilder = New SqlCommandBuilder(daDataAdapter)

 

 

Dim iResult As Integer

 

 

Dim bResult As Boolean = False

 

bsMaintenance.EndEdit()

myBuilder.GetUpdateCommand()

 

daDataAdapter.UpdateCommand = myBuilder.GetUpdateCommand()

 

daDataAdapter.Update(DSData, "TBL_CALL_TYPES")

 

Any help would be appreciated.

[Martin Vasilev]

Hi Derek,

Thank you for writing. I cannot see anything wrong in your code. It is not related to RadGridView functionality and it should work. You can try to use the Update method without changing the UpdateCommand. Also check if you have a primary key in your table which has to be updated. This is necessary for the Update method to work properly.

All the best,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Derek]

It's working now, it seems it lost its currentrowchanging event handler.  Sometime this happens when I copy and paste a control.

[Martin Vasilev]

Hello Derek,

I am glad that you have managed to find a solution. Do not hesitate to contact me again if you need additional assistance.

Best wishes,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.