This is a migrated thread and some comments may be shown as answers.

RadGrid populated by the selected row of another isn't selectable

4 Answers 118 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Jerald asked on 09 Nov 2017, 12:44 AM

I'm using the following SqlDataSource to populate a RadGrid and it works as expected:

SqlDataSource sdsRgVens = new SqlDataSource();

sdsRgVens.ID = "sdsRgVens";

this.Page.Controls.Add(sdsRgVens);

sdsRgVens.DataSourceMode = SqlDataSourceMode.DataSet;

sdsRgVens.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["drappConnectionString"].ConnectionString;

sdsRgVens.SelectCommand = "SELECT venIdPk, venNm, venCity, venStateAcro, venZipCode FROM vendors";

rgVens.DataSource = sdsRgVens;

rgVens.DataBind();

Here's the code for the RadGrid:

<telerik:RadGrid ID="rgVens" runat="server" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" AllowFilteringByColumn="True" ShowGroupPanel="True" OnPreRender="rgVens_PreRender" OnItemCommand="rgVens_ItemCommand" >

<ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True" ReorderColumnsOnClient="True"></ClientSettings>

<MasterTableView DataKeyNames="venIdPk" PagerStyle-AlwaysVisible="true">

<Columns>

<telerik:GridButtonColumn CommandName="Select" Text="Select" ButtonType="LinkButton"></telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="venIdPk" ReadOnly="True" HeaderText="venIdPk" SortExpression="venIdPk" UniqueName="venIdPk" DataType="System.Int32" FilterControlAltText="Filter venIdPk column"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="venNm" HeaderText="Name" SortExpression="venNm" UniqueName="venNm" FilterControlAltText="Filter venNm column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="venCity" HeaderText="City" SortExpression="venCity" UniqueName="venCity" FilterControlAltText="Filter venCity column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="venStateAcro" HeaderText="State" SortExpression="stateProvAcro" UniqueName="stateProvAcro" FilterControlAltText="Filter stateProvAcro column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="venZipCode" HeaderText="Zip Code" SortExpression="venZipCode" UniqueName="venZipCode" FilterControlAltText="Filter venZipCode column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="true"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

When a row is selected in the first RadGrid another RadGrid is populated as expected.

Here's the SqlDataSource for the second RadGrid

<asp:SqlDataSource ID="sdsRgVenDocs" runat="server"

ConnectionString='<%$ ConnectionStrings:drappConnectionString %>'

SelectCommand="SELECT [docIdPk], [docTitle], [venIdFk] FROM [docs] WHERE ([venIdFk] = @venIdFk)">

<SelectParameters>

<asp:ControlParameter ControlID="rgVens" PropertyName="SelectedValue" Name="venIdFk" Type="Int32"></asp:ControlParameter>

</SelectParameters>

</asp:SqlDataSource>

Here's the code for the second RadGrid:

<telerik:RadGrid ID="rgVenDocs" runat="server" DataSourceID="sdsRgVenDocs" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" AllowFilteringByColumn="True" ShowGroupPanel="True" Skin="Default">

<ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True" ReorderColumnsOnClient="True"></ClientSettings>

<MasterTableView DataKeyNames="docIdPk" DataSourceID="sdsRgVenDocs">

<Columns>

<telerik:GridButtonColumn CommandName="Select" Text="Select" ButtonType="LinkButton"></telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="docIdPk" ReadOnly="True" HeaderText="docIdPk" SortExpression="docIdPk" UniqueName="docIdPk" DataType="System.Int32" FilterControlAltText="Filter docIdPk column"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="docTitle" HeaderText="docTitle" SortExpression="docTitle" UniqueName="docTitle" FilterControlAltText="Filter docTitle column"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="venIdFk" HeaderText="venIdFk" SortExpression="venIdFk" UniqueName="venIdFk" DataType="System.Int32" FilterControlAltText="Filter venIdFk column"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

At this point I should be able to select a row in the second RadGrid, but when I click on the "Select" link button the row is not selected.

How can I get the row in the second RadGrid to be selectable like the first RadGrid? I can get this to work as expected if I just use the asp:GridView controls.

RadGrid populated by the selected row of another isn't selectable

4 Answers, 1 is accepted