Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
A. Clay
40
Updating SQL database with cell values from code
posted

I have an UltraWebGrid with a Webcombo EditorControl with hidden columns containing the ID's of the related objects.  In the UpdateRow event I get the ID values from the selected row of the WebCombo and stuff them into the UltraWebGrid cells:

 

 

 

 

 

 

 

Protected 

 

Sub ActsGrid_UpdateRow(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.RowEventArgs) Handles ActsGrid.UpdateRow

 

 

If e.Row.DataChanged

Then

 

 

'Updated

e.Row.Cells(24).Value = Now()

 

 

'MatterID and EventID

 

 

If Me.EventsCombo.SelectedRow IsNot Nothing

Then

 

 

Dim evid As Integer = Me.EventsCombo.SelectedRow.Cells(0).Value

 

 

Dim matid As Integer = Me.EventsCombo.SelectedRow.Cells(1).Value

e.Row.Cells(6).Value = evid

e.Row.Cells(7).Value = matid

The correct values are arriving safely into the row.cells, but the integer values are not being saved into the SQL database.  The DateTime value is correctly saved. My SQLDataAdapter INSERT query includes the parameters from these cells.  How do I save these values??

thanks 

 

 

 

 

End

If

  • 4555
    posted

    Hi,

    The values in the UltraWebGrid should contain the correct values, even for the WebCombo. If you  have defined a DataValueField and a DataTextField then the grid's cell's value should be be that of the  DataValueField and this can be used for updating the DataBase.

    Magued