Questions on UI for WPF Forum

0 answers

121 views

RadGridView Dynamic Row Height Resizing at Runtime?

Hello,

Can anyone please explain to me how to resize the row height whenever the RadGridView height is changed at runtime?

Thanks in advance.

GridView

asked on 13 Jul 2016

2 answers

489 views

Connecting a RadContextMenu to a RadGridView programmatically

How would I go about adding a RadContextMenu to a RadGridView programmatically? I am building the RadGridView completely in code at runtime, and don't have a predefined XAML component.

The RadGridView only seems to have a ContextMenu that can be set, but I can't hook a RadContextMenu to the ContextMenu property.

Any advice? I need this so I can have the row that is right-clicked selected, and I can look at the current cell so that I can have specific menu items added to the context menu.

ContextMenu

answered on 12 Jul 2016

4 answers

126 views

Scrollbar issue in Visual Studio light theme

Hello,

Looks like this issue is with the theme. We are using two themes in our application. In ExpressionDark theme, the scroll bar is working fine in Gridview.

If we use Visual studio light theme, scroll bar is not moving when we click on the area below scroll bar. We are able to scroll the data by dragging the scroll bar or clicking on top and bottom icons.

Can anyone help with the issue.

TIA

GridView

answered on 12 Jul 2016

11 answers

479 views

Excel File Export - OutOfMemoryException

I am using the below code to create an excel file:



Workbook workbook = new Workbook();

workbook.Worksheets.Add();

string fileName = "SampleFile.xlsx";

IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();

using (FileStream output = new FileStream(fileName, FileMode.Create))

{

formatProvider.Export(workbook, output); //System.OutOfMemoryException thrown here

}

Where the variable workbook contains a lot of data (about 115000 rows worth). My problem is that the host computer doesn't have enough memory to do the excel export, so an outofmemoryexception is thrown at formatProvider.export().

Is there a way to split up Excel file export into smaller parts so that I don't run out of memory? I need all of the data to be in the same excel file.

Siward

Spreadsheet

answered on 12 Jul 2016

1 answer

744 views

Custom group header text

Hi,

I want to change the default header text. For example I have following properties

Id
Title
Description

If user will group it by Id, then I want to show group header text like [Id]:[Title]. How can I do this?

Thanks,

Daler

GridView

answered on 12 Jul 2016

3 answers

375 views

Replace default styles of Controls

Hi,

I'm new to WPF and Telerik controls.

I'm using trial version of Telerik controls.

I'm developing a WPF desktop application. For one of its UI, it requires some complex requirement to have a Hierarchical Grid View, with two dependent ComboBox columns, UpDownNumeric button in Text Column and AutoFilter/Sorting on Columns in child and parent grids.

I'm able to achieve the above by using telerik controls, but the styles of all the controls are not matching my current WPF UI Desktop application. The telerik controls shows up yellow and orange colors on mouse over and selection in all controls.

I would like to override this default behaviour with the coloring schemes as per my application.

Please let me know where to make the change so as to affect all the controls to override the default color styles.

Below is the code snippet of UI:

GridView

answered on 12 Jul 2016

2 answers

643 views

Select Item based on row.IsSelected

Hi there,

I'm trying to get the multiselection of the RadGridView working. I have a class Building with a Property IsSelected. With the Selection_Changed event i set/unset the property of the item. Is it possible to bind to the Building.IsSelected, so each row gets selected, if its object.IsSelected is true?

I know about the solution with behaviors, but I'd like one without it.

A little sample here:

<telerik:RadGridView x:Name="BuildingListGrid" ItemsSource="{Binding BuildingList}" EnableRowVirtualization="True"
SelectionUnit="FullRow" SelectionMode="Extended" SelectionChanged="MasterBuildingListGrid_OnSelectionChanged"> <telerik:RadGridView.Columns>
<telerik:GridViewDataColumn DataMemberBinding="{Binding Building.Name}" Header="Column2" />

</telerik:RadGridView.Columns>

</telerik:RadGridView>

public class Building : INotifyPropertyChanged
{
    public Building(Building building){}
    public bool IsSelected
    {
        get { return _isSelected; }
        set
        {
            if (value == _isSelected) return;
            _isSelected = value;
            OnPropertyChanged();
        }
    }

public string Name { get; set; }

}

GridView

answered on 12 Jul 2016

5 answers

877 views

Applying multiple column filters with the OR logical operator between them

Hi guys,
As the title states, I'm trying to apply the OR logical operator between multiple column filters instead of the default AND operator that is applied when using the popup UI of the GridView.
I haven't found any simple way of doing this without attaching a DataFilter to the grid, and we do not like the UI of the DataFilter.
What I did come up with is handling the Sorted event and iterating over the columns to get their filters and add them to a compound filter like so:

Telerik.Windows.Data.CompositeFilterDescriptor mainFilter = new Telerik.Windows.Data.CompositeFilterDescriptor();

mainFilter.LogicalOperator = Telerik.Windows.Data.FilterCompositionLogicalOperator.Or;

this.dgTaskManager.FilterDescriptors.SuspendNotifications();

foreach (Telerik.Windows.Controls.GridViewColumn column in this.dgTaskManager.Columns)

{

//Add all active column filters to the main filter

if (column.ColumnFilterDescriptor.IsActive)

{

mainFilter.FilterDescriptors.Add(column.ColumnFilterDescriptor);

this.filteredColumnList.Add(column);

}

this.dgTaskManager.FilterDescriptors.Clear();

this.dgTaskManager.FilterDescriptors.Add(mainFilter);

this.dgTaskManager.FilterDescriptors.ResumeNotifications();

This works fine in terms of filtering correctly, but the funnel icon of the filtered columns is obviously unaffected since the FilterDescriptors collection of the grid no longer holds the filtered columns directly.
I tried manually setting each filtered column's FilterControl and setting its isActive property to true after ResumeNotifications(), but for some reasons it only highlights the last filtered column's funnel and only after opening and closing the filter control of the other filtered columns does it update their funnel's highlighting correctly. In addition it also doesn't seem to handle removing filters correctly (in terms of UI).
Does anyone have an idea how to achieve this? I can't believe that the need to apply the OR operator between columns hasn't arisen before me, am I missing something obvious?
Thanks
Orr

GridView

answered on 12 Jul 2016

3 answers

658 views

Stack overflow exception on DataBind()

We currently have an admin page that allows us to search for customers by email. My task is to also implement functionality that allows us to see all of a particular customer's orders for the past two weeks when we make that search. I modeled this data binding after the current data binding that exists, but it just causes a stack overflow exception, and I'm not sure what I'm doing wrong. Here's the markup:

<telerik:RadGrid ID="MailingsGrid" runat="server" AllowSorting="True" CellSpacing="0" GridLines="None" PageSize="50" OnItemDataBound="MailingsGrid_ItemDataBound">

<MasterTableView Width="100%" NoMasterRecordsText="No users found" AutoGenerateColumns="false">

<Columns>

<telerik:GridBoundColumn DataField="Sub_Order_ID" HeaderText="Sub_Order_ID" UniqueName="Sub_Order_ID" ReadOnly="true" DataType="System.Int32" FilterControlAltText="Filter Sub_Order_ID column" SortExpression="Sub_Order_ID" />

<telerik:GridBoundColumn DataField="Num_Pages" HeaderText="Num_Pages" UniqueName="Num_Pages" ReadOnly="true" DataType="System.Int32" FilterControlAltText="Filter Num_Pages column" SortExpression="Num_Pages" />

<telerik:GridTemplateColumn SortExpression="Address_1" HeaderText="Recipient" HeaderButtonType="TextButton" GroupByExpression="Address_1 Group by Address_1" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" ReadOnly="true" ItemStyle-Wrap="false">

<ItemTemplate

><%#MailALetter.Common.FormatAddressTo(DataBinder.Eval(Container, "DataItem.Title"), DataBinder.Eval(Container, "DataItem.Name"), DataBinder.Eval(Container, "DataItem.JobTitle"), DataBinder.Eval(Container, "DataItem.Company"), DataBinder.Eval(Container, "DataItem.Address_1"), DataBinder.Eval(Container, "DataItem.Address_2"), DataBinder.Eval(Container, "DataItem.Address_3"),  DataBinder.Eval(Container, "DataItem.City"), DataBinder.Eval(Container, "DataItem.State"),  DataBinder.Eval(Container, "DataItem.Zip_Code_5"), DataBinder.Eval(Container, "DataItem.Zip_Code_4"),  DataBinder.Eval(Container, "DataItem.Country"))%>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="Date_Created" DataType="System.DateTime" FilterControlAltText="Filter Date_Created column" HeaderText="Date_Created" ReadOnly="True" SortExpression="Date_Created" UniqueName="Date_Created">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Date_Fullfilled" DataType="System.DateTime" FilterControlAltText="Filter Date_Fullfilled column" HeaderText="Date_Fullfilled" ReadOnly="True" SortExpression="Date_Fullfilled" UniqueName="Date_Fullfilled">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

And here's the code behind:

protected void SearchButton_Click(object sender, EventArgs e)

{

string EmailSearchTerm = SearchText.Text;

UserResults = DBContext.Users.Where(x => SqlMethods.Like(x.Email, "%" + EmailSearchTerm + "%")).ToList();

MembershipResults = DBContext.Memberships.Where(x => UserResults.Select(y => y.UserId).Contains(x.UserId)).ToList();

SearchResults.DataSource = UserResults;

// This line is causing the overflow exception