Getting new values from edit mode of RadGrid ?

[Tahir Ahmed]

Hello,

Can someone please explain me in a simple approach how to access values of text boxes, drop downs and other controls that appear in edit mode ? I feel like striking my head against the wall because it's been sometime since I last used Telerik and I can't find any solution to this.

My grid has a mix of GridBoundColumns and GridTemplateColumns, it is populated using a stored procedure that is called using ASP SQLDataSource but I want update to be manual on UpdateCommand Event unfortunately I can't figure out how to access all those controls that appear in edit mode.

   <telerik:RadGrid ID="OnGoingProjectsGrid" runat="server" CellSpacing="0" DataSourceID="OnGoingProjectsDS" GridLines="None" Skin="Metro" OnDataBound="OnGoingProjectsGrid_DataBound" OnItemDataBound="OnGoingProjectsGrid_ItemDataBound" OnUpdateCommand="OnGoingProjectsGrid_UpdateCommand">
        <MasterTableView DataSourceID="OnGoingProjectsDS" AutoGenerateColumns="false" DataKeyNames="SNO" AllowSorting="False">
            <Columns>
                <telerik:GridEditCommandColumn ButtonType="LinkButton">

                </telerik:GridEditCommandColumn>

                <telerik:GridBoundColumn DataField="SNO" HeaderText="SNO" UniqueName="SNO" Visible="false" ReadOnly="true" ForceExtractValue="Always" ConvertEmptyStringToNull="true">

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="JOBORDER" HeaderText="JOB ORDER" UniqueName="JOBORDER">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="CLIENT" HeaderText="CLIENT" UniqueName="CLIENT">
                    <HeaderStyle Width="300px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                    <FilterTemplate>
                        <telerik:RadComboBox ID="ClientComboBox" DataValueField="CLIENT" AppendDataBoundItems="true" runat="server" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("CLIENT").CurrentFilterValue %>'>
                            <Items>
                                <telerik:RadComboBoxItem Text="Select Client" />
                            </Items>
                        </telerik:RadComboBox>
                    </FilterTemplate>
                </telerik:GridBoundColumn>

                <telerik:GridTemplateColumn DataField="STATUS" HeaderText="STATUS" UniqueName="STATUS">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />
                    <ItemTemplate>
                        <asp:Label ID="lblStatusEdit" runat="server" Text=<%# Bind("STATUS") %>></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="StatusComboBox" runat="server" Skin="Metro" EnableLoadOnDemand="false" MarkFirstMatch="false" OnLoad="StatusComboBox_Load" AllowCustomText="false"></telerik:RadComboBox>
                    </EditItemTemplate>

                </telerik:GridTemplateColumn>

                <telerik:GridBoundColumn DataField="DATE" HeaderText="DATE" UniqueName="DATE" ReadOnly="true">
                    <HeaderStyle Width="150px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="DESIGNATEDPERSON" HeaderText="DESIGNATED PERSON" UniqueName="DESIGNATEDPERSON">
                    <HeaderStyle Width="100px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="AFFILIATE" HeaderText="AFFILIATE" UniqueName="AFFILIATE">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="DESCRIPTION" HeaderText="DESCRIPTION" UniqueName="DESCRIPTION">
                    <HeaderStyle Width="200px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="ACTIONWHO" HeaderText="ACTION WHO" UniqueName="ACTIONWHO">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="DELIVERABLES" HeaderText="DELIVERABLES" UniqueName="DELIVERABLES">
                    <HeaderStyle Width="150px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                
                <telerik:GridTemplateColumn DataField="DEADLINE" HeaderText="DEADLINE" UniqueName="DEADLINE">
                    <HeaderStyle Width="150px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text=<%# Bind("DEADLINE") %>></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <telerik:RadCalendar ID="RadCalendar1" runat="server" Skin="Metro" EnableMultiSelect="false"></telerik:RadCalendar>
                    </EditItemTemplate>

                </telerik:GridTemplateColumn>

                <telerik:GridBoundColumn DataField="PERCENTAGE" HeaderText="PERCENTAGE" UniqueName="PERCENTAGE">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="DAYSLEFT" HeaderText="DAYSLEFT" UniqueName="DAYSLEFT" ReadOnly="true">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridTemplateColumn DataField="REMARKS" HeaderText="REMARKS" UniqueName="REMARKS">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />

                    <ItemStyle HorizontalAlign ="Center" />
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text=<%# Bind("REMARKS") %>></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text=<%# Bind("REMARKS") %>></asp:TextBox>
                    </EditItemTemplate>
                </telerik:GridTemplateColumn>

                <telerik:GridBoundColumn DataField="COST" HeaderText="COST" UniqueName="COST">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="PROFITMARGIN" HeaderText="PROFIT MARGIN" UniqueName="PROFITMARGIN">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="NETPROFIT" HeaderText="NET PROFIT" UniqueName="NETPROFIT">
                    <HeaderStyle Width="80px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="PAYMENTDURATION" HeaderText="PAYMENT DURATION" UniqueName="PAYMENTDURATION">
                    <HeaderStyle Width="100px" Font-Size="Smaller" Font-Bold="true" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign ="Center" />

                </telerik:GridBoundColumn>

            </Columns>
            <EditFormSettings>

            </EditFormSettings>
        </MasterTableView>
    </telerik:RadGrid>

    <asp:SqlDataSource ID="OnGoingProjectsDS" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>" SelectCommand="Get_Projects" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="0" Name="UserId" SessionField="LoggedInUserID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

I appreciate any help.

[Eyup]

Hi Tahir,

You can use the approach demonstrated in the following section in order to achieve this requirement:
( Section Accessing controls in edit/insert mode )
http://www.telerik.com/help/aspnet-ajax/grid-accessing-cells-and-rows.html

Alternatively, you can use the ExtractValues method:
http://demos.telerik.com/aspnet-ajax/grid/examples/data-editing/manual-crud-operations/defaultcs.aspx

Hope this helps.

Regards,
Eyup
Telerik