Telerik RadGrid

Jose Saiz

8y11.2k.NET

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)

"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">
"NextPrevAndNumeric">
"100%" CommandItemDisplay="TopAndBottom" DataSourceID="SqlDataSource2"
DataKeyNames="logId" AutoGenerateColumns="false" InsertItemDisplay="Top"
InsertItemPageIndexAction="ShowItemOnFirstPage">
"logId" CommandName="Edit">
"log_date" UniqueName="log_date" HeaderText="Date">
"log_type" UniqueName="log_type" HeaderText="Type">
"client_name" UniqueName="client_name" HeaderText="Client Name">
"delivery_method" UniqueName="delivery_method" HeaderText="Method">
"entered_by" UniqueName="entered_by" HeaderText="Entered By">
"facility_name" UniqueName="facility_name" HeaderText="Facility">
"log_status" UniqueName="log_status" HeaderText="Status">
"Delete" Text="Delete" UniqueName="DeleteColumn">
"SqlDataSource2" runat="server">

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jose Saiz8y ago
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
0
Jose Saiz8y ago
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.
0
Sagar Pandurang Kap8y ago
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...
0