Selecting Desired Records In RadGrid

[Charles]

I am receiving records from a web service that are displayed in a
RadGrid. I need to mark certain records as selected based on the
existence of matching records in a database table. The records in
the table were produced from the web service at one time and contain
only matching records. The records are matched via the "AccDesc"
DataKeyNames. Any suggestions would be appreciated.

<radControls:RadGrid ID="AccessoriesGrd" runat="server" Width="780px" AllowMultiRowSelection="true" Visible="true">

<MasterTableView DataKeyNames="AccDesc, Retail, TradeIn" AutoGenerateColumns="false" EnableHeaderContextMenu="true">

<Columns> 

<radControls:GridClientSelectColumn HeaderText="Select" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="55px" UniqueName="SelectColumn" ItemStyle-VerticalAlign="Top" />

<radControls:GridBoundColumn DataField="AccDesc" AllowSorting="true" HeaderText="Description" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="350px" ItemStyle-VerticalAlign="Top" />

<radControls:GridTemplateColumn HeaderText="Retail" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="55px" SortExpression="Retail" ItemStyle-HorizontalAlign="Right" ItemStyle-VerticalAlign="Top">

<ItemTemplate>

<%#Consumers.StandardFunctions.FormatCurrency(Eval("Retail"))%>

</ItemTemplate>

</radControls:GridTemplateColumn> 

<radControls:GridTemplateColumn HeaderText="Trade-In" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="55px" SortExpression="TradeIn" ItemStyle-HorizontalAlign="Right" ItemStyle-VerticalAlign="Top">

<ItemTemplate>

<%#Consumers.StandardFunctions.FormatCurrency(Eval("TradeIn"))%>

</ItemTemplate>

</radControls:GridTemplateColumn> 

</Columns>                  

</MasterTableView>

<ClientSettings EnableRowHoverStyle="true" AllowColumnsReorder="true" ColumnsReorderMethod="Reorder">

<Selecting AllowRowSelect="true" />

</ClientSettings>

</radControls:RadGrid>

 

[Mira]

Hello Wayne,

In order to implement the desired functionality, I recommend that you traverse all grid items on PreRender, check whether a record with the same AccDesc is contained in the database and set the Selected property of the corresponding grid item if there is.

Please give this approach a try and let me know how it goes.

Greetings,
Mira
the Telerik team