I am putting into my heriarchial grids in-line editing but am running into a problem of how to get at the editing of the lower grids. i have the 1st grid working but how can I get at the sub grid to edit them inline. How can I have a unique update name, insert or delete fro each level of the grid. How can I differenitate between these 2 update commands for differetn grids. the 1st one is for the top level grid and the second one is for the 1st sub-level.
Protected Sub myRadGrid_ItemCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles myRadGrid.ItemCommand
'All the Inline Update Commands
If (e.CommandName = RadGrid.UpdateCommandName) Then
Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
Dim Id As Integer = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("intCategoryId")
Dim Cat As TextBox = CType(editedItem.FindControl("txtCategory"), TextBox)
Dim NSN As TextBox = CType(editedItem.FindControl("txtNSN"), TextBox)
Dim LIN As TextBox = CType(editedItem.FindControl("txtLin"), TextBox)
sql = "Update Drat_Category set strCategory = '" & sanitizeString(Cat.Text.ToUpper) & "', strNSN = '" & sanitizeString(NSN.Text.ToUpper) & "', strLIN = '" & sanitizeString(LIN.Text.ToUpper) & "' " _
& "where intCategoryId = " & Id
insertUpdateDelete(sql)
myRadGrid.Rebind()
End If
If (e.CommandName = RadGrid.UpdateCommandName) Then
Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
Dim Id As Integer = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("intManufacturerId")
Dim Man As TextBox = CType(editedItem.FindControl("txtManufacturer"), TextBox)
sql = "Update Drat_Manufacturer set strmanufacturer = '" & sanitizeString(Man.Text.ToUpper) & "' where intManufacturerId = " & Id
insertUpdateDelete(sql)
myRadGrid.Rebind()