I have an ultrwebgrid bound to a sqldatasource. The UpdateRow event fires when I add a row, along with the AddRow event, but it does not fire when I update a row. I think I have all the AllowUpdate type fields set. The adding of rows run fine. I have taken out the paging to simplify. I can edit the lone updateable cell just fine. I have a multiple field primary key, but it is supposed to handle it as I input the fields, in the correct order, separated by commas in the DataKeyFields property. I have attached the pertinent markup and C# code.
The grid is bound to the datasource via the ultrawebgrid property in the designer.
DataSourceID
="sqldsNote"
I only call UltraWebGrid.DataBind in two places. Once when I get the values for the table key I do the below along with the SqlDataSource. This is only firing once as is proper.
sqldsNote.SelectParameters[
"Identifier"].DefaultValue = tbVendID.Text;
sqldsNote.DataBind();
uwgNotes.DataBind();
The other was in the uwgNotes_PageIndexChanged event which no longer occurs as paging is removed.
The AddRow is updating the database and firing UpdateRow successfully so the grid must be connected to the sqldatasource with its InsertCommand and UpdateCommand.
I do not get any error, just no database update occurs and the UpdateRow event does not fire. I am using the latest version of Infragistics35 8.3.20083.2059.
How are you binding your grid to the SqlDataSource?
If you're doing this in code, you may need to move this to a different location (Page_Load is the most often used and may be too late in the page's lifecycle), or possibly avoid calling DataBind().
If you're doing this in the designer, then I can't think of a reason why this should occur. Can you reproduce in a sample application that we can run and debug?
I did so. I removed them from the markup. Good for you to ask though.
I am sure you are aware of this but just in case, when you remove them make sure you are deleting them from the property window. This causes them to be "unwired". If you just deleted or comment out the code it will remain "wired up".
I have no client side events. I tried removing the other 3 server side events below. UpdateRows still did not fire.
onaddrow="uwgNotes_AddRow"
oninitializelayout="uwgNotes_InitializeLayout"
onpageindexchanged="uwgNotes_PageIndexChanged"