How to access the Grid Value for RadGridView ??

[Munish]

Hi All
I have a RadGridView in my code of the namespace "Telerik.Windows.Controls.RadGridView". I need to iterate through the rows and get all the data. I am using the code as :
IList<GridViewRow> rows = RadGridView1.ChildrenOfType<GridViewRow>();
foreach (GridViewRow row in rows)
 {if (!(row is GridViewNewRow))
{foreach (var x in row.Cells)
                    {
                        GridViewCell y = (GridViewCell)x;
                        System.Diagnostics.Debug.WriteLine(y.Value);     
                    }}}

The value comes as null if the column if is of type checkbox. I need some generic code to get the value. 

Anybody any idea about this ??

[Munish]

I have seen there are few solutions on telerik website ..but they are using the namespace Telerik.WinControls....i dont have this dll reference to me.

[Dimitrina]

Hello,

My suggestion is that you iterate on the bound data items instead. You can access them through RadGridView.Items.

Regards,
Didie
Telerik

[Munish]

Hi 

Thanks for the revert. The items gives me the view model. Each row in my grid is an instance of view model. Issues in that :

1. For each column name , i Need to access the corresponding property of the VM using some select statement. ( Sort of mapping between column and VM property)

2.Property in VM returns the plain data , where as GUI is showing value after conversion ( Converters defined in the XAML).

[Dimitrina]

Hello,

Indeed, in that case you can only work with the plain data. I should mention that when the UI Virtualization is enabled, we do not recommend you to rely on the visual elements. 

Regards,
Didie
Telerik

[Munish]

Well , I have seen the telerik export csv functionality too....It accepts the underlying dataitems to the API...but still the value in exported file is same as shown in the GUI itself , i.e after appyling the converters.

[Dimitrina]

Hello,

I am afraid that there is not an option to export the raw data by default. You can format the exported value back in the ElementExporting event of the RadGridView.

Regards,
Didie
Telerik

[Ed]

" You can access them through RadGridView.Items"

I'm a newbie especially with the RadGridView so it would be helpful if you can you provide an example.  

[Dimitrina]

Hello,

You can check our Exporting WPF Demos and our online documentation on how to export and format the data based on the ExportFormat you use. Do you export to CSV format?

Regards,
Didie
Telerik