Grid Column data Bind

[Mostafa]

Hi
i have a grid and in that Grid i have a column name 'Result' which Show data like 6-5,10-11 etc
i have two way to make that 
1. select Set1 ,Set2   from table1

and then in grid 
 <telerik:GridTemplateColumn >
<ItemTemplate>
 <%# Eval("Set1")+" -"+Eval("Set2") +","+'^{'+Eval("Set1")+'}'+" -"+Eval("Set2") %>
</ItemTemplate>
</telerik:GridTemplateColumn >

2. i can return a field named 'result' from my data query store procedure like '(select ISNULL(CAST( Set1 as nvarchar(5)),'') +''+ ISNULL('-'+CAST(Set2 as nvarchar(5))+''+ISNULL('^{'+CAST(Set3 as nvarchar(5))+'}','')'')  as result  from table1' which give me 6-5,10-11

and in grid 
<telerik:GridBoundColumn UniqueName="Result" DataField="result" > </telerik:GridBoundColumn>


my Question is which one is better if the total number of set is 15.and number of row in result set more then 100

[Konstantin Dikov]

Hi Mostafa,

Adding the data directly to the DataSource of the grid would be faster, because no calculations will be performed while the ItemTemplate is being created. However, at the end it is up to the developer to choose the approach that best fits the requirement.

On a side note, you could take a look at the GridCalculatedColumn, which could be used for displaying calculated data:

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/columns/column-types#gridcalculatedcolumn

Hope this helps.


Regards,
Konstantin Dikov
Telerik