[Solved] radgrid in userControl with new data table

[Mohammadreza reiazi]

hi
i create a form with a radgrid and a mini form(some text box) inside a panel on it that save data in new Datatable, and editform is a webusercontrol
(

UserControlName

 

="EditForm.ascx" EditFormType="WebUserControl"

 

)
when i click submit button ,main data save in main tabel(datatable1) and mini form data save in new table(datatable2).and id of main table save in datatable2 for later,to load page.
in the webUserControl form i add a new radgrid that show my data of dataTable2 in edit form.it give id of main table and load datas in dataTable2 where (id = main table id).
when  i click on edit button i need to know id of clicked row(id number in datatable1 that saved in datatable2 ,too) for load dataTable2 fields in my new radgrid.
how can i find id of current edit form table.to list data in new  radgrid

Radgrid(new radgrid1 in edit form) bine code

  protected void RadGridEdit1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            pcpc_imploymentSabegheController pcpcImploymentsabegh = new pcpc_imploymentSabegheController();
            RadGridEdit1.DataSource = pcpcImploymentsabegh.List(Id);

        }

EditForm codes

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="EditForm.ascx.cs" Inherits="imployment.EditForm" %>
<%@ Register TagPrefix="telerik" Namespace="imployment" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register Assembly="Telerik.Web.UI, Version=2009.2.826.20, Culture=neutral, PublicKeyToken=121FAE78165BA3D4"
    Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<div dir="rtl">
    <table id="tableTmp1" dir="rtl" id="Table2" cellspacing="2" cellpadding="1" width="100%"
        border="0" rules="none" style="border-collapse: collapse; background: white;">
        <tr>
            <td colspan="2" style="font-size: small">
                <b>نمایش / ویرایش مدیر ,Edit Form</b>
            </td>
        </tr>
        <tr>
            <td>
                <table dir="rtl" id="tableTmp2" cellspacing="1" cellpadding="1" width="250" border="0"
                    class="module">
                    <tr>
                        <td>
                        </td>
                        <td>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            نام :
                        </td>
                        <td>
                            <asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            نام خانوادگی :
                        </td>
                        <td>
                            <asp:TextBox ID="FamilyTextBox" runat="server" Text='<%# Bind("Family") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            سن :
                        </td>
                        <td>
                            <asp:TextBox ID="FNameTextBox" runat="server" Text='<%# Bind("BirthDay") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            مدرک :
                        </td>
                        <td>
                            <asp:TextBox ID="StateTextBox" runat="server" Text='<%# Bind("StudyState") %>'></asp:TextBox>
                        </td>
                    </tr>
                </table>
            </td>
            <td>
                <table dir="rtl" id="tableTmp3" cellspacing="1" cellpadding="1" width="250" border="0"
                    class="module">
                    <tr>
                        <td>
                        </td>
                        <td>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            رشته تحصیلی :
                        </td>
                        <td>
                            <asp:TextBox ID="MStringTextBox" runat="server" Text='<%# Bind("StudyString") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            محل تحصیل :
                        </td>
                        <td>
                            <asp:TextBox ID="SiteTextBox" runat="server" Text='<%# Bind("StudySite") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            وضعیت تاهل :
                        </td>
                        <td>
                            <asp:TextBox ID="MatrimonyTextBox" runat="server" Text='<%# Bind("MatrimonyState") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            وضعیت نظام وظیفه :
                        </td>
                        <td>
                            <asp:TextBox ID="MilitaryLTextBox" runat="server" Text='<%# Bind("MilitaryState") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <asp:TextBox ID="IdTextBox" runat="server" Text='<%# Bind("Id") %>'></asp:TextBox>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <table dir="rtl" id="tableTmp4" cellspacing="1" cellpadding="1" width="500" border="0"
                    class="module">
                    <tr>
                        <td colspan="2">
                            سوابق کاری :
                        </td>
                    </tr>
                    <td colspan="2">
                        <telerik:RadGrid ID="RadGridEdit2" runat="server" GridLines="None" OnNeedDataSource="RadGridEdit2_NeedDataSource">
                            <MasterTableView>
                                <RowIndicatorColumn>
                                    <HeaderStyle Width="20px"></HeaderStyle>
                                </RowIndicatorColumn>
                                <ExpandCollapseColumn>
                                    <HeaderStyle Width="20px"></HeaderStyle>
                                </ExpandCollapseColumn>
                                <Columns>
                                    <telerik:GridTemplateColumn DataField="FromYear" UniqueName="FromYear">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="FromYearTextBox" runat="server" Text='<%# Bind("FromYear") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="FromYearLabel" runat="server" Text='<%# Eval("FromYear") %>'></asp:Label>
                                        </ItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn DataField="TOYear" UniqueName="TOYear">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TOYearTextBox" runat="server" Text='<%# Bind("TOYear") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="TOYearLabel" runat="server" Text='<%# Eval("TOYear") %>'></asp:Label>
                                        </ItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn DataField="InWhere" UniqueName="InWhere">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="InWhereTextBox" runat="server" Text='<%# Bind("InWhere") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="InWhereLabel" runat="server" Text='<%# Eval("InWhere") %>'></asp:Label>
                                        </ItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn DataField="Worke" UniqueName="Worke">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="WorkeTextBox" runat="server" Text='<%# Bind("Worke") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:Label ID="WorkeLabel" runat="server" Text='<%# Eval("Worke") %>'></asp:Label>
                                        </ItemTemplate>
                                    </telerik:GridTemplateColumn>
                                </Columns>
                            </MasterTableView>
                            <ClientSettings>
                                <Selecting AllowRowSelect="True" />
                            </ClientSettings>
                        </telerik:RadGrid>
                    </td>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <table dir="rtl" id="tableTmp5" cellspacing="1" cellpadding="1" width="500" border="0"
                    class="module">
                    <tr>
                        <td colspan="2">
                            نممو نه کارها :
                        </td>
                    </tr>
                    <td colspan="2">
                        <asp:TextBox ID="SamplesTextBox" runat="server" Text='<%# Bind("Samples") %>' Width="450"
                            Height="100"></asp:TextBox>
                    </td>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <table dir="rtl" id="tableTmp6" cellspacing="1" cellpadding="1" width="500" border="0"
                    class="module">
                    <tr>
                        <td>
                            وقت آزاد :
                        </td>
                    </tr>
                    <tr>
                        <td>
                            صبح :
                        </td>
                        <td>
                            <asp:TextBox ID="TimeAmTextBox" runat="server" Text='<%# Bind("TimeAm") %>'></asp:TextBox>
                        </td>
                        <td>
                        </td>
                        <td>
                            عصر :
                        </td>
                        <td>
                            <asp:TextBox ID="TimePmTextBox" runat="server" Text='<%# Bind("TimePm") %>'></asp:TextBox>
                        </td>
                        <td>
                        </td>
                        <td>
                            زمان کل :
                        </td>
                        <td>
                            <asp:TextBox ID="TimeAllTextBox" runat="server" Text='<%# Bind("TimeAll") %>'></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            حقوق پیشنهادی :
                        </td>
                        <td>
                            <asp:TextBox ID="RequestSalaryTextBox" runat="server" Text='<%# Bind("RequestSalary") %>'></asp:TextBox>
                        </td>
                        <td>
                            ریال
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <table dir="rtl" id="tableTmp7" cellspacing="1" cellpadding="1" width="500" border="0"
                    class="module">
                    <tr>
                        <td>
                            تلفن منزل :
                        </td>
                        <td>
                            <asp:TextBox ID="TelTextBox" runat="server" Text='<%# Bind("Tel") %>'></asp:TextBox>
                        </td>
                        <td>
                            موبایل :
                        </td>
                        <td>
                            <asp:TextBox ID="MobilTextBox" runat="server" Text='<%# Bind("Mobil") %>'></asp:TextBox>
                        </td>
                        <td>
                            پست الکترونیکی :
                        </td>
                        <td>
                            <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <telerik:RadGrid ID="RadGridEdit1" runat="server" GridLines="None" OnNeedDataSource="RadGridEdit1_NeedDataSource">
                    <MasterTableView>
                        <RowIndicatorColumn>
                            <HeaderStyle Width="20px"></HeaderStyle>
                        </RowIndicatorColumn>
                        <ExpandCollapseColumn>
                            <HeaderStyle Width="20px"></HeaderStyle>
                        </ExpandCollapseColumn>
                        <Columns>
                            <telerik:GridTemplateColumn DataField="title" HeaderText="عنوان تخصص" UniqueName="title">
                                <EditItemTemplate>
                                    <asp:TextBox ID="titleTextBox" runat="server" Text='<%# Bind("title") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="titleLabel" runat="server" Text='<%# Eval("title") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="darsad" HeaderText="درصذ" UniqueName="darsad">
                                <EditItemTemplate>
                                    <asp:TextBox ID="darsadTextBox" runat="server" Text='<%# Bind("darsad") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="darsadLabel" runat="server" Text='<%# Eval("darsad") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="_comment" HeaderText="توضیحات" UniqueName="_comment">
                                <EditItemTemplate>
                                    <asp:TextBox ID="_commentTextBox" runat="server" Text='<%# Bind("_comment") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="_commentLabel" runat="server" Text='<%# Eval("_comment") %>'></asp:Label>
                                </ItemTemplate>
                            </telerik:GridTemplateColumn>
                        </Columns>
                    </MasterTableView>
                </telerik:RadGrid>
            </td>
        </tr>
    </table>
</div>

Main form Grid code(radgrid1 in main form)

 

<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" OnNeedDataSource="RadGrid1_NeedDataSource"
                        Width="100%" AllowSorting="True" AutoGenerateColumns="False" Skin="Office2007"
                        OnItemInserted="RadGrid1_ItemInserted" AllowPaging="True" OnDeleteCommand="RadGrid1_DeleteCommand"
                        AutoGenerateEditColumn="True" OnUpdateCommand="RadGrid1_ItemUpdated1"
                        onitemdatabound="RadGrid1_ItemDataBound" >
                        <MasterTableView EditMode="PopUp">
                            <RowIndicatorColumn>
                                <HeaderStyle Width="20px"></HeaderStyle>
                            </RowIndicatorColumn>
                            <Columns>
                                <telerik:GridTemplateColumn DataField="Name" UniqueName="Name" EditFormColumnIndex="0">
                                    <ItemTemplate>
                                        <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:Label ID="lblname" runat="server" Text="نام"></asp:Label>
                                        <asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="Family" UniqueName="Family" EditFormColumnIndex="1">
                                    <ItemTemplate>
                                        <asp:Label ID="FamilyLabel" runat="server" Text='<%# Eval("Family") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:Label ID="lblfamily" runat="server" Text="نام خانوادگی"></asp:Label>
                                        <asp:TextBox ID="FamilyTextBox" runat="server" Text='<%# Bind("Family") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="BirthDay" UniqueName="BirthDay1" EditFormColumnIndex="2">

                                    <EditItemTemplate>
                                        <asp:Label ID="lblbirthDay" runat="server" Text="سن"></asp:Label>
                                        <asp:TextBox ID="FNameTextBox" runat="server" Text='<%# Bind("BirthDay") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn EditFormColumnIndex="1" UniqueName="TemplateColumn">
                                    <ItemTemplate>
                                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="false" CommandName="Delete"
                                            Text="Delete"></asp:LinkButton>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="StudyState" EditFormColumnIndex="3" UniqueName="StudyState">
                                    <ItemTemplate>
                                        <asp:Label ID="StateLabel" runat="server" Text='<%# Eval("StudyState") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox ID="StateTextBox" runat="server" Text='<%# Bind("StudyState") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="StudyString" EditFormColumnIndex="0" UniqueName="StudyString">
                                    <ItemTemplate>
                                        <asp:Label ID="StringLabel" runat="server" Text='<%# Eval("StudyString") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MStringTextBox" runat="server" Text='<%# Bind("StudyString") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="StudySite" EditFormColumnIndex="1" UniqueName="StudySite">

                                    <EditItemTemplate>
                                        <asp:TextBox ID="SiteTextBox" runat="server" Text='<%# Bind("StudySite") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="MatrimonyState" EditFormColumnIndex="2" UniqueName="MatrimonyState">
                                    <ItemTemplate>
                                        <asp:Label ID="MatrimonyLabel" runat="server" Text='<%# Eval("MatrimonyState") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MatrimonyTextBox" runat="server" Text='<%# Bind("MatrimonyState") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="MilitaryState" UniqueName="MilitaryState"
                                    EditFormColumnIndex="3">
                                    <ItemTemplate>
                                        <asp:Label ID="MilitaryLabel" runat="server" Text='<%# Eval("MilitaryState") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MilitaryLTextBox" runat="server" Text='<%# Bind("MilitaryState") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="Id" UniqueName="Id" EditFormColumnIndex="1">
                                    <ItemTemplate>
                                        <asp:Label ID="IdLabel" Enabled="false" runat="server" Text='<%# Eval("Id") %>' Visible="true"></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox ID="IdTextBox" runat="server" Text='<%# Bind("Id") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>

                                <telerik:GridTemplateColumn DataField="Samples" UniqueName="Samples" EditFormColumnIndex="0">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="SamplesTextBox" runat="server" Text='<%# Bind("Samples") %>' Width="300"
                                            Height="100"></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="TimeAm" UniqueName="TimeAm" EditFormColumnIndex="0">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TimeAmTextBox" runat="server" Text='<%# Bind("TimeAm") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="TimePm" UniqueName="TimePm" EditFormColumnIndex="1">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TimePmTextBox" runat="server" Text='<%# Bind("TimePm") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn UniqueName="TimeAll" EditFormColumnIndex="2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="RequestSalary" UniqueName="RequestSalary"
                                    EditFormColumnIndex="0">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="RequestSalaryTextBox" runat="server" Text='<%# Bind("RequestSalary") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="RequestSalaryLabel" runat="server" Text='<%# Eval("RequestSalary") %>'></asp:Label>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="Tel" UniqueName="Tel" EditFormColumnIndex="0">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TelTextBox" runat="server" Text='<%# Bind("Tel") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="Mobil" UniqueName="Mobil" EditFormColumnIndex="1">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="MobilTextBox" runat="server" Text='<%# Bind("Mobil") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="Email" UniqueName="Email" EditFormColumnIndex="2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn DataField="Adress" UniqueName="Adress" EditFormColumnIndex="0">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="AdressTextBox" runat="server" Text='<%# Bind("Adress") %>'></asp:TextBox>
                                    </EditItemTemplate>

                                </telerik:GridTemplateColumn>
                            </Columns>


                            <EditFormSettings UserControlName="EditForm.ascx" EditFormType="WebUserControl">
                                <EditColumn UniqueName="EditCommandColumn1">
                                </EditColumn>
                            </EditFormSettings>
                        </MasterTableView>

                        <AlternatingItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                            Font-Strikeout="False" Font-Underline="False" ForeColor="Aqua" Wrap="True" />
                        <ClientSettings>
                            <Selecting AllowRowSelect="True" />
                        </ClientSettings>
                    </telerik:RadGrid>

[Radoslav]

Hi Mohammadreza,

You could get the value from "Id" column on the selected row in RadGrid's  ItemCommand event handler with following code snippet:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.EditCommandName)
    {
      GridDataItem item = e.Item as GridDataItem;
      int id = Convert.ToInt32(item["Id"].Text);
    }
}

Then you could set the value from id in the Session object and use it later when you bind the second RadGrid in edit form.

Additionally you could get more information on how to access cells and rows in RadGrid here:

http://www.telerik.com/help/aspnet-ajax/grdaccessingcellsandrows.html

I hope this helps.

Greetings,
Radoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Mohammadreza reiazi]

thanks Radoslav
it worke.