Telerik RadGrid

Question

Does any one have a sample of the Telerik RadGrid that I am able to select the a row from the grid and get the real value from the selected row?

 

I have tried all samples and neither one can help, when I don't get an error I get the wrong value from the selected row.

 

This is what I've been trying (default.aspx)

<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" DataSourceID="SqlDataSource2" AllowSorting="True"
                PageSize="7" AllowPaging="True" runat="server" OnSortCommand="RadGrid1_SortCommand"
                OnPageIndexChanged="RadGrid1_PageIndexChanged"  OnPageSizeChanged="RadGrid1_PageSizeChanged" OnEditCommand="RadGrid1_EditCommand">
                <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
                <MasterTableView Width="100%" CommandItemDisplay="TopAndBottom" DataSourceID="SqlDataSource2"
                    DataKeyNames="logId" AutoGenerateColumns="false" InsertItemDisplay="Top"
                    InsertItemPageIndexAction="ShowItemOnFirstPage">
                    <Columns>
                        <telerik:GridButtonColumn DataTextField="logId" CommandName="Edit">
                        </telerik:GridButtonColumn>
                        <telerik:GridBoundColumn DataField="log_date" UniqueName="log_date" HeaderText="Date">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="log_type" UniqueName="log_type" HeaderText="Type">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="client_name" UniqueName="client_name" HeaderText="Client Name">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="delivery_method" UniqueName="delivery_method" HeaderText="Method">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="entered_by" UniqueName="entered_by" HeaderText="Entered By">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="facility_name" UniqueName="facility_name" HeaderText="Facility">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="log_status" UniqueName="log_status" HeaderText="Status">
                        </telerik:GridBoundColumn>
                        <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="DeleteColumn">
                        </telerik:GridButtonColumn>
                    </Columns>
                </MasterTableView>

             </telerik:RadGrid>
             <asp:SqlDataSource ID="SqlDataSource2" runat="server"></asp:SqlDataSource>

 default.aspx.cs (Code behind)

protected void LogDailyLogDataListing()
    {

        SqlDataSource2.ConnectionString = "Connection String Here"
        SqlDataSource2.SelectCommand = "select * from table";
        this.RadGrid1.DataBind();
    }
 protected void RadGrid1_EditCommand(object sender, EventArgs e)
    {
        //- Per Telerik sample this suppose to work but it does not.
        foreach (var item in RadGrid1.SelectedItems)
        {
            if (item is GridDataItem)
            {
                GridDataItem dataItem = item as GridDataItem; // found the
               string sLogId = dataItem["logId"]; // found the cell
            }
        }
    }
    protected void RadGrid1_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
    {
        LogDailyLogDataListing();
    }

    protected void RadGrid1_PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e)
    {
        LogDailyLogDataListing();
    }

    protected void RadGrid1_SortCommand(object sender, Telerik.Web.UI.GridSortCommandEventArgs e)
    {
        LogDailyLogDataListing();
    }

I will appriciate the help and sample code very much. 

 

Thanks 

Answer 1

Finally I got it to work thanks to a telerik old employee, who helped a lot

this is what he suggested, to replace the OnEditCommand for the following in the 

 

Default.aspx 

OnItemCommand="RadGrid1_ItemCommand" OnSelectedIndexChanged="RadGrid1_SelectedIndexChanged"

 Default.aspx.cs (Code behind)

 protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.SelectCommandName)
        {
            string sSelectedRowValue = "Primary key for the clicked item from ItemCommand: " + (e.Item as GridDataItem).GetDataKeyValue("logId").ToString();
        }
}
protected void RadGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
    {
        //- This gives me the row selected from the RadGrid
        Response.Write("Primary key for the clicked item from SelectedIndexChanged: "
        + (RadGrid1.SelectedItems[0] as GridDataItem).GetDataKeyValue("logId").ToString();
}

 Thank you all for all your help

 

Answer 2

Thanks Sagar for your reply, I have tried all sample from Telerik FAQ, Knowledge base etc.

and neither one help, all I want to accomplish is to select the primary Id items from the RadGrid and use it in another page that does not contain the RadGrid control, I was only able to make it to work using the Edit template and view the selected row within the same page that has the RadGrid control, but it is not what I am looking for.

 

I thought the Telerik RadGrid was more friendly, it appears to only works with its own template.

 

Thanks again. 

Answer 3

Hi,

try below link :-

 

https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Selecting/getting-cell-values-for-selected-rows

 

It might helps...