Questions on UI for WPF Forum

2 answers

325 views

I'm trying to export 100,000+ rows to Excel from the data grid, and as expected, I'm running into OutOfMemoryException issues. That's understandable, and I've seen your help articles that recommend we use Reporting when that may be the case.

I want to avoid that, though, for simplicity. It's much more preferable for our users if they can just click an export button, specify a location to save it, and just fire and forget, no matter how big the data set is or how long it would take.

So, my question to you is, is it possible to append to an existing Excel file when exporting from the grid view? This way, I can request say 5,000 entities at once, put the objects in a data grid, export it to the file selected by the user, and then request the next set of entities. Rinse and repeat. I want to batch the requests, since requesting 100,000+ rows will likely lead to a timeout anyway, so this would be really convenient. All I've seen in all your documentation, though, requires overwriting the existing file.

If that's not possible, can you provide any guidance on how else we could export 100,000+ rows to Excel without resorting to Reporting, while still leveraging the data grid or RadSpreadsheet?

GridView

answered on 10 Oct 2016

1 answer

214 views

RadGridView localization doesn’t work

Hi

I try localize RadGridView to Slovak culture.

I have resource files in external assemnly MyApp.Resources.

In this assembly I have resouce files named Translations.sk-Sk.resx

This file contains:

GridViewGroupPanelText "Some awesome string will be there"

I MyApp assembly in App.xaml.cs in method OnStartup I set current culture and resource for

LocalizationManager.Manager.Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture = new CultureInfo(cultureCode);

LocalizationManager.Manager = new LocalizationManager()

{

ResourceManager = Translations.ResourceManager

};

When I try access to GridViewGroupPanelText from ViewModel class it works good.

var groupBy= LocalizationManager.Manager.ResourceManager.GetString("GridViewGroupPanelText");

But in view RadGridView use still english translations.

Thread.CurrentThread.CurrentCulture is sk-Sk (Slovak).

Windows culture is en-GB.

Any advice?

General Discussions

answered on 10 Oct 2016

1 answer

94 views

Aggregate not working until a sort is done

I have a new window opening with a gridview. It had been displaying my footer aggregates fine until the latest update. Since then the aggregates do not display until I sort one of the columns. I did try calling the CalculateAggregates function on the Window_Loaded event but that didn't seem to help.

Any other ideas on how to solve this issue?

GridView

answered on 10 Oct 2016

1 answer

99 views

Drop appointment from other instance

Hi,

Is it possible to drag an appointment from one instance of a ScheduleView and drop it on an other instance?

Thanks

John

ScheduleView

answered on 10 Oct 2016

3 answers

342 views

Grid with cells merging

Hello
We want to use grid in our WPF project which must looks like grid on picture in attachments.

We want to do merging by multiple rows on equals. For example we want to do merge the same values in first column then, in this range we want to merge by third column. Something like GroupBy("Column1").ThenBy("Column2").

I don't find any grid in your demos, which can help us to solve this problems.
Could you possibly prompt your product, which can do this things and demos for it if they are exist.

Thank you. Have a nice day!

GridView

answered on 10 Oct 2016

1 answer

85 views

Linking a RadPivotGrid to a RadPieChart

Hello,

Is there an easy way to link a RadPivotGrid to a RadPieChart, in a similar way to the RadCartesianChart described here: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/radchartview-integration?

Thanks,

Richard

ChartView

answered on 10 Oct 2016

1 answer

248 views

Circular Grid

Hi,

Can I add a "circular grid" to a chart?

I must draw a "Polar chart" that is not a real polar chart but is a "movement in a plane chart".

It is a standard scatter line in a standard scatter chart where each point is X and Y coordinate at time T.

I want to show as background an "ellipse grid" that show distance by the origin.

I hope this is clear...

Thanks

marc.

movement in the plane

ChartView

answered on 10 Oct 2016

3 answers

113 views

[Solved] how to make the beginning and end label of Y-Axis editable

how to make the beginning and end label of Y-Axis editable (if could assgin a template to edit, it will be nicer)

Thank you

ChartView

answered on 10 Oct 2016

0 answers

130 views

ContextSwitchDeadlock when loading too many rows to VirtualQueryableCollectionView

Hello,

At this line

public DataServiceCollection<CustomerDto> Customers = new DataServiceCollection<CustomerDto>(Container.Customers.IncludeTotalCount());

in the code below i am getting the ContextSwitchDeadlock exception when loading 100 000 to VirtualQueryableCollectionView using an OData v4 rest service. The VirtualQueryableCollectionView is boud to the ItemsSource of the RadGridControl

If i deactivate ContextSwitchDeadlock in the Exception Settngs of VS2015 it just takes 10 - 15 minutes for the rows "to load".

Why is this?

Why the ContextSwitchDeadlock (how would i prevent it)??

I thought the idea of VirtualQueryableCollectionView is that it returns in a jiffy (isnt that what data virtualisation is about?) with a couple hundred rows, and then loads the rest as we scroll. It shouldnt take 10 - 15 minutes just to start up.

I would like to reactivate ContextSwitchDeadlock Exception Setting in VS2015 and debug without the exception being raised.

Any ideas on how to go about it?

Also i would like to solve the issue of the long load time - that isnt data virtualisation. What causes it? How to solve it? Should i rather use the DataServiceDataSource? Is the VirtualQueryableCollectionView is wrong candidate for loading large quantities of data in small bites?

If a full demo of the VS2015 solution is needed to answer this, you can download here (use the Inserting10000Customers.sql file in it to the Customer SQL Express table with 100 000 rows), at: https://app.box.com/s/73dufnlkf63se19ehhzfzz6upevbn92m

Hope someone at Telerik or someone who knows answers.

Paul S.

nb. removing IncludeTotalCount() doesnt change the problem.

public partial class MainWindow

{

private static readonly Container Container = new Container(new Uri("http://localhost:21026/")); //http://localhost:21026/

public DataServiceCollection<CustomerDto> Customers = new DataServiceCollection<CustomerDto>(Container.Customers.IncludeTotalCount());

public MainWindow()

{

InitializeComponent();

IQueryable<CustomerDto> test = Customers.OrderBy(o => o.Name).AsQueryable();

var source = new VirtualQueryableCollectionView(test) { LoadSize = 1000 };

// source.ItemsLoading += Source_ItemsLoading;

DataContext = source;

}

private void Source_ItemsLoading(object sender, VirtualQueryableCollectionViewItemsLoadingEventArgs e)

{ }

}


<Window x:Class="ODataAndAutoMapper.Telerik.UI.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:controls="http://schemas.telerik.com/2008/xaml/presentation"
        mc:Ignorable="d">
    <Grid>
        <controls:RadGridView ItemsSource="{Binding}" FilteringMode="FilterRow"/>
         
    </Grid>
</Window>

Data Virtualization

asked on 07 Oct 2016

1 answer

341 views

Expand Tree Node via Code

I have a simple RadTreeView that is defined like this:

<telerik:RadTreeView

x:Name="contextTree"

Margin="8"

ItemsSource="{Binding Hierarchy, Mode=TwoWay}">

<telerik:RadTreeView.ItemTemplate>

<HierarchicalDataTemplate

ItemsSource="{Binding Children}">

<TextBlock Text="{Binding Name}" />

</HierarchicalDataTemplate>

</telerik:RadTreeView.ItemTemplate>

</telerik:RadTreeView>

My Hierarchy is an ObservableCollection of a HierarchyContext object that has an ID, Name, Role, ParentID and Children properties.

I would like to have all nodes in the collection Expanded by default. I'd also like to be able to control if each node is expanded through Code. I assume I'd need to add a "IsExpanded" bool? property to my object but, can you give me an example of how to do this?

Thanks, Joel.

TreeView

answered on 07 Oct 2016