Custom edit in nested grid

[Alice]

Okay so I've been through the forums and the tutorials but I must have a hard head this week because I'm still not getting it.  :)

How do I create a custom edit form for a nested grid?   I want to change a couple of the text boxes to combo boxes, but when I tried it in the source code it didn't work, i.e. it didn't look like I did anything.

[Princy]

Hello Alice,

I would suggest you to use GridDropDownColumns instead of GridBoundColumns where data appears as in GridBoundColumns, when in Normal mode and when in Edit mode data would be bound to dropdownlists.
aspx:

 <telerik:GridDropDownColumn UniqueName="DropDownListColumn" ListTextField="CustomerID" ListValueField="CustomerID" DataSourceID="SqlDataSource1" DataField="ContactName" >
 </telerik:GridDropDownColumn>

You can also refer to this link - Column Types

Another alternative would be to replace the default Edit form with a UserControlEditForm or TemplateEditForm .

Thanks
Princy.

[Alice]

Thanks,

That's all good but I'm still not sure where in the code I'm supposed to effect the changes, or what property to use.  Is it done under the master table or the nested grid? 

[Shinu]

Hi Alice,
 
This is how you can implement a template Editform for the master and child table in Grid hierarchy.

ASPX:

 <telerik:RadGrid ID="RadGrid1" runat="server"    AllowMultiRowSelection="True" DataSourceID="SqlDataSource1"  >
            <MasterTableView DataSourceID="SqlDataSource1"   EditMode="EditForms"    >
                <EditFormSettings EditFormType="Template" >
                    <FormTemplate>
                        <telerik:RadComboBox ID="RadComboBox1" runat="server" >
                        </telerik:RadComboBox>
                    </FormTemplate>
                 </EditFormSettings>

                <Columns>
                    <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName"
                        UniqueName="FirstName">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" SortExpression="LastName"
                        UniqueName="LastName">
                    </telerik:GridBoundColumn>
                    <telerik:GridEditCommandColumn>
                    </telerik:GridEditCommandColumn>
                </Columns>

             <DetailTables>
                <telerik:GridTableView runat="server"  EditMode="EditForms"  DataSourceID="SqlDataSource1" >
                 <EditFormSettings EditFormType="Template" >
                    <FormTemplate>
                        <telerik:RadComboBox ID="RadComboBox2" runat="server" >
                        </telerik:RadComboBox>
                    </FormTemplate>
                 </EditFormSettings>
                 <Columns>
                  <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName"
                        UniqueName="FirstName">
                    </telerik:GridBoundColumn>
                    <telerik:GridEditCommandColumn></telerik:GridEditCommandColumn>
                 </Columns>
                </telerik:GridTableView>
              </DetailTables>
            </MasterTableView>
        </telerik:RadGrid>

Thanks
Shinu.

[Alice]

Thanks,

That's what I needed.  I'm about half way there now.  I've got the form set up the way I want it, but the "cancel" and the "update" links don't show up.

I just need to know how to add them back in.  :)

[Yavor]

Hi Alice,

Since you are using a Template edit form for the inner grid, you will need to manually include Cancel/Update Buttons or link buttons for the form. These must also have the appropriate commandName. I hope this information helps.

Kind regards,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Shinu]

Hi Alice,

Try placing the Update and Cancel Linkbuttons in the FormTemplate as shown below.

ASPX:

<EditFormSettings  EditFormType="Template"  >
                    <FormTemplate>
                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                        <asp:LinkButton ID="LinkButton3" runat="server" Text="Update" CommandName="Update"  ></asp:LinkButton>
                        <asp:LinkButton ID="LinkButton2" runat="server" Text="Cancel" CommandName="Cancel" ></asp:LinkButton>
                    </FormTemplate>
                 </EditFormSettings>

CS:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.CommandName == "Update")
        {

        }
    }

Thanks
Shinu.

[Alice]

Thanks,

I've added the link buttons in the form but I'm not sure about the code for the click event, since it's in a nested grid.  Could you help me with the code for this in vb?

[Shinu]

Hi Alice,

ItemCommand event will fire for both master and detail table. Make sure that you have set the CommandName property for the LinkButton in the aspx. Here is the code snippet in VB.

VB:

 Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As GridCommandEventArgs)

     If e.CommandName = "Update" Then
     End If
 End Sub

Thanks
Shinu.

[Alice]

Thanks, I think I have it.  :)  I really appreciated the help.

[Shinu]

Hi Alice,

You can use the following link to convert code from C# to VB and viceversa.
http://converter.telerik.com/

Regards
Shinu

[Bill]

Hello Alice,

There is a really good video on how to create a custom edit form

Video 45

[Alice]

That was a great vid thanks.

Well guys,

Everything is working perfect except insert.  Here is what I have in the code:

Private Sub RadGridGoals_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGridGoals.ItemCommand

Select e.CommandName

Case e.CommandName = "Update"

Me.ObjectDataSourceGoals.Update()

Case e.CommandName = "Cancel"

Me.RadGridGoals.Rebind()

End Select

End Sub

Here's what I tried:

Private Sub RadGridGoals_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGridGoals.ItemCommand

Select e.CommandName

Case e.CommandName = "Update"

Me.ObjectDataSourceGoals.Update()

Case e.CommandName = "Cancel"

Me.RadGridGoals.Rebind()

Case e.CommandName = "Insert"

Me.ObjectDataSourceGoals.Insert()

End Select

End Sub

Any suggestions?

[Yavor]

Hello Alice,

Based on the code supplied, it is hard to determine the cause of the issue. To further investigate it, you can open a formal support ticket, and send us a small project sample, for additional testing.

Sincerely yours,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.