Questions on UI for WinForms Forum

6 answers

360 views

GridViewCommandColumn PerformClick

Hello,

I need some help with my application code.

I'm trying to do a PerformClick on a CommandColumn in a single row in a single cell.

How can I access the ButtonElement in that cell and do a PerformClick event programmatically?

Thanks in advance

Roberto

GridView

answered on 24 Nov 2016

7 answers

253 views

RadWindow.StartPosition = Manual

Hi,

When this mode is set and new screen location point is applied, then the window shrinks in height each time it's shown.
Even from 1-st ShowDialog its width becomes less.

Example:
If it's used as the once instatiated dialogBox and is shown each time it is needed, then each showtime it becomes less and less in heigth, up to its Top bar.

General Discussions

answered on 24 Nov 2016

4 answers

909 views

Refresh RadGrid

I use the following function to load Horse names starting with a given letter

The first call returns and displays the list in the grid view

But at the second and following calls, while the HorseList is correctly generated, the display in the grid does not display the new list

I know that this questionhas been discussed many times but I have not found the solution .....

Thanks in advance

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Public Function LoadNode(ByVal FirstLetter As String) As Boolean
Try
Dim aHorse As New mHorse
Dim Horses As New List(Of Horse)
'Load the Horses list where the name starts with "FirstLetter"
Horses = aHorse.LoadNode(FirstLetter)
If Horses.Count > 0 Then
gvHorse.BeginUpdate()
gvHorse.DataSource = Horses
gvHorse.EndUpdate()
Else

End If
Catch ex As Exception

End Try
End Function

GridView

answered on 24 Nov 2016

4 answers

322 views

How do I set width to "auto" in excel export? And how do I change header style?

I can't figure out how to do the following 2 things.

1. Set the width of the exported columns. They look ok in my grid in the WinForm, but when exported take up too much space.

2. How do I change the style of the column headers? I would like to bold it.

Here's my code.

private void btnExportVendorInvoices_Click(object sender, EventArgs e)

{

using (SaveFileDialog dialog = new SaveFileDialog())

{

dialog.Filter = "Microsoft Excel (*.xlsx)|*.xlsx";

dialog.FilterIndex = 2;

dialog.RestoreDirectory = true;

if (dialog.ShowDialog() == DialogResult.OK)

{

rgvInvoices.EnableAlternatingRowColor = true;

var exporter = new ExportToExcelML(rgvInvoices);

exporter.SheetMaxRows = ExcelMaxRows._1048576;

exporter.HiddenColumnOption = HiddenOption.DoNotExport;

exporter.ExportVisualSettings = true;

exporter.ExcelCellFormatting += explorter_ExcelCellFormatting;

exporter.RunExport(dialog.FileName);

exporter.ExcelRowFormatting += exporter_ExcelRowFormatting;

var dr = RadMessageBox.Show(this, "File has been saved, would you like to open it?",

"File saved", MessageBoxButtons.YesNo, RadMessageIcon.Info);

if (dr.ToString() == "Yes")

{

System.Diagnostics.Process.Start(dialog.FileName);

}

private void explorter_ExcelCellFormatting(object sender, ExcelCellFormattingEventArgs e)

{

if (e.GridCellInfo.RowInfo is GridViewDataRowInfo)

{

if (e.GridCellInfo.ColumnInfo.Name == "vendorFedId")

{

e.ExcelCellElement.Data.DataItem = string.Format("{0:00-0000000}", Convert.ToInt32(e.GridCellInfo.Value));

}

GridView

answered on 24 Nov 2016

7 answers

151 views

Filter Multiple text condition

Hi all,
i have a problem with a pivotgrid, as the title say i would like to add some filter conditions to my grid, below some lines of my code:

this.radPivotGrid1.DataSource = LINQToDataTable(query);
this.radPivotFieldList1.AssociatedPivotGrid = this.radPivotGrid1;

this.radPivotGrid1.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "STATUS", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "SOMETHING", GroupComparer = new GrandTotalComparer() });
this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "SOMETHING_ELSE", AggregateFunction = AggregateFunctions.Count });

this.radPivotGrid1.AllowGroupFiltering = true;

PropertyGroupDescriptionBase description = (PropertyGroupDescriptionBase)this.radPivotGrid1.RowGroupDescriptions[0]; //STATUS
LabelGroupFilter filter = new LabelGroupFilter();
TextCondition condition = new TextCondition();

condition.Comparison = Telerik.Pivot.Core.Filtering.TextComparison.DoesNotContain;
condition.Pattern = "SELLED"; <-------------- here i would like to insert more than one condition
filter.Condition = condition;
description.GroupFilter = filter;

as you can read in the comment i would like to say, for example: "Display only if my STATUS is not "SELLED" or "LOST"

There is a way to do it?

thank you very much

Andrea

PivotGrid and PivotFieldList

answered on 24 Nov 2016

9 answers

2.7K+ views

RadDropDownList Selected Value

Hi,

Inthat scenario, when I try to edit the selected item, you'll see thelist.Selected Value is not changed.
But if you press button to get the Selected Value, you'll it's already = null.

It should keep the selected value, because it's needed to update data (text), using the id as value in a DB table..

public partial class RadForm2 : Telerik.WinControls.UI.RadForm

{

RadDropDownList list = new RadDropDownList();

TextBox tb = new TextBox();

Button b = new Button();

public RadForm2()

{

InitializeComponent();

this.Controls.AddRange(new Control[] { list, tb, b });

list.DropDownStyle = RadDropDownStyle.DropDown;

list.Location = new Point(30, 30);

list.Width = 100;

list.Height = 25;

list.DisplayMember = "name";

list.ValueMember = "id";

list.NullText = "not selected";

list.SelectedValueChanged += list_SelectedValueChanged;

tb.Location = new Point(30, 70);

tb.Width = 100;

tb.Height = 25;

DataTable dt = new DataTable();

dt.Columns.Add("id", typeof(int));

dt.Columns.Add("name", typeof(string));

dt.Rows.Add(1, "one");

dt.Rows.Add(2, "two");

dt.Rows.Add(3, "three");

dt.Rows.Add(4, "four");

dt.Rows.Add(5, "five");

list.DataSource = dt;

b.Location = new Point(30, 110);

b.Width = 100;

b.Height = 25;

b.Text = "Get Selected Value";

b.Click += b_Click;

}

void b_Click(object sender, EventArgs e)

{

tb.Text = list.SelectedValue + " <----> " + list.SelectedText;

}

void list_SelectedValueChanged(object sender, EventArgs e)

{

tb.Text = list.SelectedValue + " <----> " + list.SelectedText;

}

General Discussions

answered on 23 Nov 2016

1 answer

185 views

Using two versions of UI at the same time.

We are interested in upgrading to the latest version of UI. Can we use the version of UI alongside an older version?

We are currently using UI for Winforms version 2011.2.11.0712.

Can we gradually upgrade our programs by including controls from the new version without interfering with controls using the older version?

General Discussions

answered on 23 Nov 2016

4 answers

166 views

Attach Image with Coumn Text in MultiColumnComboBox

Is there any way to attach a picture before text of any any column ?

Regards

MSA

MultiColumn ComboBox

answered on 23 Nov 2016

1 answer

123 views

Programatically cancel an insert

Is there a way to fully cancel a user insert of a new row programatically?

I am looking to simulate the user hitting the esc key once initiating an insert of a new row.

Thanks,

GridView

answered on 22 Nov 2016

1 answer

171 views

RowFormatting and ElementVisibility.Collapsed Problem

Hello everybody,

I have a problem using the element visibilty property on ElementVisibility.Collapsed on the radgridview RowFormatting event.

When i try to put the row visibility to ElementVisibility.Collapsed, there is a strange behavior, the rows are not correctly displayed.

Here is a sample that reproduces the problem :

Imports Telerik.WinControls.UI

Public Class RadForm1

Private _Liste As New List(Of MyClass1)

Public Sub New()

' Cet appel est requis par le concepteur.

InitializeComponent()

' Ajoutez une initialisation quelconque après l'appel InitializeComponent().

_Liste.Add(New MyClass1 With {.Prop1 = 10, .Prop2 = "AAA" & .Prop1})

_Liste.Add(New MyClass1 With {.Prop1 = 10, .Prop2 = "BBB" & .Prop1})

_Liste.Add(New MyClass1 With {.Prop1 = 10, .Prop2 = "CCC" & .Prop1})

_Liste.Add(New MyClass1 With {.Prop1 = 100, .Prop2 = "DDD" & .Prop1})

_Liste.Add(New MyClass1 With {.Prop1 = 100, .Prop2 = "FFF" & .Prop1})

_Liste.Add(New MyClass1 With {.Prop1 = 1, .Prop2 = "QQQ" & .Prop1})

_Liste.Add(New MyClass1 With {.Prop1 = 1, .Prop2 = "SSS" & .Prop1})

RadGridView1.DataSource = _Liste

End Sub

Private Sub RadGridView1_RowFormatting(sender As Object, e As RowFormattingEventArgs) Handles RadGridView1.RowFormatting

If DirectCast(e.RowElement.RowInfo.DataBoundItem, MyClass1).Prop1 = 10 Then

e.RowElement.Visibility = Telerik.WinControls.ElementVisibility.Collapsed

Else

e.RowElement.Visibility = Telerik.WinControls.ElementVisibility.Visible

End If

End Sub

Private Class MyClass1

Public Property Prop1 As Integer

Public Property Prop2 As String

End Class

Maybe i'm missing something, but when i replace Telerik.WinControls.ElementVisibility.Collapsed by Telerik.WinControls.ElementVisibility.Hidden, i have the expected behavior (except that the rows are not collapsed).

Thanks in advance for your answers, and sorry for my aweful english ... I'm french.

I'm using Windows 7 64 bits, with 2016.3.1024.40 version of radcontrols, and .Net Framework v4

GridView