I have a WebDataGrid bound to a DataSource. The columns are not being autogenerated. I've made edits to the items in the WebDataGrid. However, I'm not seeing the changes reflected in the GridRecordItem when I loop thru the rows. I was expecting to see the changed values in objGridRecordItem.Text, but I'm still seeing the original values prior to my edits.What am I doing wrong?
Ed T
Private Sub WebDataGridLoop() Dim strColumnName As String Dim objGridRecordItem As GridRecordItem Dim objBoundDataField As BoundDataField Dim i As Integer
For Each row As GridRecord In Me.wdgInvoiceServiceFeeDefault.Rows
Dim objInvoiceServiceFeeDefault As New InvoiceServiceFeeDefault
i = row.Items.Count
For i = 0 To (i - 1)
objGridRecordItem = row.Items(i) objBoundDataField = row.Items(i).Column strColumnName = objBoundDataField.DataFieldName
Select Case strColumnName Case AutoSignupDefaultInvoiceServiceFeeDCSchema.InvoiceServiceTypeID objInvoiceServiceFeeDefault.InvoiceServiceTypeID = objGridRecordItem.Text Case AutoSignupDefaultInvoiceServiceFeeDCSchema.ServiceUnitID objInvoiceServiceFeeDefault.ServiceUnitID = objGridRecordItem.Text Case AutoSignupDefaultInvoiceServiceFeeDCSchema.ServiceFreeQty objInvoiceServiceFeeDefault.ServiceFreeQty = objGridRecordItem.Text Case AutoSignupDefaultInvoiceServiceFeeDCSchema.ServiceFee objInvoiceServiceFeeDefault.ServiceFee = objGridRecordItem.Text End Select
Next
Me.InvoiceServiceFeeDefaultInsert(objInvoiceServiceFeeDefault)
End Sub
Hi,
I would bet you're running that procedure before the rowupdating event so you'll only see the old values. In the Rowupdating event you can see both. After that (in the rowupdated event) you'll only see the new ones.
Ed
I don't have any code in either the rowupdating or the rowupdated server side events. I could be wrong, but I assumed these events get triggered when moving from row to row. I'm trying to update the database after the row edits are complete by looping thru the grid rows. The user would click on a Save button and run the procedure. I want to avoid postbacks after every row edit.
Thanks,
Then you should look at this post about batch updating with WDG:
http://community.infragistics.com/forums/p/35865/209676.aspx#209676
In the initial Page_Load I'm binding 25 rows from Table1 to a WebDataGrid. The user is allowed to edit, delete, or add new rows. When the user clicks a Save button, I want to write the rows in the grid to Table2. Radoslav's work around for Batch Updating is turning off Activation Behavior and using the server side RowUpdating Event handler. This works fine, just as long as the user makes a change to the row. However, I need to write all rows from the grid to Table2. Isn't there a way to simply loop through the grid and get the new values from the edited rows as well as the unchanged rows?
Ed,
Let me know if I can help.
I guess that would shut off sorting and filtering too so you'd have to make that call.
You can probably turn off Ajax in the grid and then leave activation on and the system wouldn't do any updates until you hit the button.
Its working now. I moved the sub to the PreRender event as you suggested and also set the EnableDataViewState property to True.
Although I'm not using Radoslav's work around for Batch Updating, I noticed a problem with turning off Activation Behavior...I could no longer tab from cell to cell. Is it possible to selectively turn off Activation Behavior properties so that both Batch Updating and cell tabbing works?
Thanks for all your help.
Are you rebinding the data on page load even on postbacks? You would be overwriting the changes.