[Solved] How to take the value for Invisible columns in gridview

[Senthil S]

Hi,

I am using the RadgridView and updated the latest version.In the Gridview(grdTReview) some columns
 (like Conflicts,MissingMileage,Approved) are invisible.

 

in grdTReview_RowLoaded event i am formatting the some columns using that invisible columns.In previous version it worked fine but after updating the latest version i cant able to take the values or content of that invisible columns..........


In previous version e.Row.Cells.count is 18.......in current version it is showing 14.......

 

 

Here is my xaml code

 

<

 

telerik:RadGridView x:Name="grdTReview" AutoGenerateColumns="False" Margin="-9,17,-11,0" RowIndicatorVisibility="Collapsed" ShowColumnFooters="False"

 

 

ScrollViewer.VerticalScrollBarVisibility="Visible" ScrollViewer.HorizontalScrollBarVisibility="Visible" d:LayoutOverrides="GridBox" Height="324" VerticalAlignment="Top" Visibility="Collapsed" >

 

 

 

<telerik:RadGridView.Columns>

 

 

 

<telerik:GridViewColumn HeaderText="" Width="90" IsResizable="False" IsVisible="False" >

 

 

 

<telerik:GridViewColumn.CellTemplate >

 

 

 

<DataTemplate>

 

 

 

<Button x:Name="btnView" Content="View" Width="80" Height="20" />

 

 

 

</DataTemplate>

 

 

 

</telerik:GridViewColumn.CellTemplate>

 

 

 

</telerik:GridViewColumn>

 

 

 

<telerik:GridViewDataColumn HeaderText="Manager" Width="140" TextWrapping="Wrap" IsResizable="True" DataMemberBinding="{Binding Manager}"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Employee" DataMemberBinding="{Binding Employee}" Width="150" TextWrapping="Wrap" IsResizable="True" />

 

 

 

<telerik:GridViewDataColumn HeaderText="Jobs" HeaderTextAlignment="Right" DataMemberBinding="{Binding Jobs}" IsResizable="False" Width="65" TextAlignment="Right" DataFormatString=" {}{0:c}" />

 

 

 

<telerik:GridViewDataColumn HeaderText="Admin" HeaderTextAlignment="Right" DataMemberBinding="{Binding Admin}" TextAlignment="Right" Width="65" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Travel" HeaderTextAlignment="Right" DataMemberBinding="{Binding Travel}" TextAlignment="Right" Width="65" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Other" HeaderTextAlignment="Right" DataMemberBinding="{Binding Other}" TextAlignment="Right" Width="60" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Total" HeaderTextAlignment="Right" DataMemberBinding="{Binding Total}" TextAlignment="Right" Width="60" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="StdHrs" HeaderTextAlignment="Right" DataMemberBinding="{Binding StandardHours}" TextAlignment="Right" Width="60" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Est.Travel" HeaderTextAlignment="Right" DataMemberBinding="{Binding EstTravel}" TextAlignment="Right" Width="75" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Difference" HeaderTextAlignment="Right" DataMemberBinding="{Binding Difference}" TextAlignment="Right" Width="75" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Miles" HeaderTextAlignment="Right" DataMemberBinding="{Binding Miles}" TextAlignment="Right" Width="73" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Mileage" HeaderTextAlignment="Right" DataMemberBinding="{Binding Mileage}" Width="74" TextAlignment="Right" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn HeaderText="Expenses" HeaderTextAlignment="Right" DataMemberBinding="{Binding Expenses}" Width="75" TextAlignment="Right" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn x:Name="gConflicts" HeaderText="Conflicts" HeaderTextAlignment="Right" DataMemberBinding="{Binding Conflicts}" TextAlignment="Right" Width="0" IsVisible="False" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn x:Name="MissingMileage" HeaderText="MissingMileage" HeaderTextAlignment="Right" DataMemberBinding="{Binding MissingMileage}" TextAlignment="Right" Width="0" IsVisible="False" IsResizable="False"/>

 

 

 

<telerik:GridViewDataColumn x:Name="Approved" HeaderText="Approved" HeaderTextAlignment="Right" DataMemberBinding="{Binding Approved}" TextAlignment="Right" Width="0" IsVisible="False" IsResizable="False"/>

 

 

 

 

<telerik:GridViewDataColumn HeaderText="" HeaderTextAlignment="Right" DataMemberPath="BeginTime" IsResizable="False" >

 

 

 

<telerik:GridViewDataColumn.CellTemplate>

 

 

 

<DataTemplate>

 

 

 

<Button x:Name="btnAprove" Content="Approve All" Width="80" Height="20" ClickMode="Press" Tag="{Binding EmployeeNo_PK}" Click="btnAprove_Click" Loaded="btnAprove_Loaded" />

 

 

 

</DataTemplate>

 

 

 

</telerik:GridViewDataColumn.CellTemplate>

 

 

 

</telerik:GridViewDataColumn>

 

 

 

</telerik:RadGridView.Columns>

 

 

 

</telerik:RadGridView>

Thanks & Regards

Senthil.S

 

[Pavel Pavlov]

Hi Senthil S,

Due to a high client demand we have introduced a horizontal virtualization to our RadGridView. This means that to increase speed and minimize memory usage RadGridView will realize only the cells needed to be displayed rather than all cells at once.

This is why you see a different count. Now to the solution :
You may read the values from the underlying business object , rather than from the Cells in the UI .
You may get access to the underlying business object using the DataContext property of the row.

e.g.
var MyBusinessObject =  e.Row.DataContext
having the business object you may read the properties directly.

Kind regards,
Pavel Pavlov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.