Questions on UI for WinForms Forum

2 answers

333 views

How do I export RadDataGridView datas to Excel file with NPOI

Hello everybody,

I am learning C# in the software specialist course. I want to get datas from RadGridView and export to Excel file. I managed that get datas from RadGridView like this:

private bool Save_As_Excel_Format()

{

if (Personal.Id <= 0) return true;

foreach (var gridViewRowInfo in GetAllRows(rgv.MasterTemplate))

{

var dataRow = (GridViewDataRowInfo) gridViewRowInfo;

foreach (GridViewCellInfo cell in dataRow.Cells)

{

MessageBox.Show(cell.Value.ToString());

}

return true;

}

public List<GridViewRowInfo> GetAllRows(GridViewTemplate template)

{

var allRows = new List<GridViewRowInfo>();

allRows.AddRange(template.Rows);

foreach (var childTemplate in template.Templates)

{

var childRows = this.GetAllRows(childTemplate);

allRows.AddRange(childRows);

}

return allRows;

}

But I do not know how I export to Excel with using NPOI library.

GridView

answered on 31 Jan 2017

0 answers

146 views

Custom filter telerik winforms UserControl

Hello,

I have one question.

When I make custom filter example name is Standard, and saved it and change some column,on user control grid.

After update something in my form custom filter reload not stay on Standard custom filter.

How to make when I update something on my form stay allways on selected filter in my case Standard?

GridView

asked on 31 Jan 2017

1 answer

289 views

GridViewComboBoxColumn selection change event handling issue

Hi,

I am using telerik library version 'UI for WinForms Q2 2014' and need to implement a selection change event for one of the GridViewComboBoxColumn type column. As per http://docs.telerik.com/devtools/wpf/controls/radgridview/columns/how-to/howto-selectionchanged-comboboxcolumn I have to use the AddHandler method for which Telerik.Windows namespace has to be used, However for the version I am currently having doesn't contain any of these Telerik.Windows libraries. What is the best thing to do for me now to implement my feature.

Thanks in advance.

Chandra.

GridView

answered on 31 Jan 2017

3 answers

240 views

Time control

So, here goes.

I have a user requirement. The basically need 1 textbox, it doesnt matter if it is a masked textbox or a datetimepicker or whatever.
This textbox needs to allow only hh:mm and when it gains focus it needs to select the whole of the contents.

When the user navigates to this textbox initially, it should be blank (it can be __:__ if masked) and should allow a user to type:

0125

without needing to press any other keys (01 is the hours and 25 is the minutes). The control should be smart enough to display 01:25 but not require the user to press the arrow keys to move from hours to minutes.

I have tried this using the maskededitbox and found that it doesnt work as intended and I cant clear the text if I set the mask to ##:## which is annoying. I then used the datetimepicker and selected time, but it has hh:mm:ss and to get from hours to minutes you have to use the arrow key.

Any help you can give would be greatly appreciated.

MaskedEditBox

answered on 31 Jan 2017

8 answers

127 views

Custom Cell Editor nested controls events

I'm writing a custom editor which have to contains 2 drowdown controls: the second dropdown must be filled on values loaded from DB based on value selected in first dropdown. I need to let user add new values for both dropdowns.

I tried two ways but with no success.

First way: I created a custom editor containing 2 DrowDownListEditorElements and I tried to override EndEdit() method of each object to create new items if needed, but it seems that each EndEdit was never invoked and I cannot intercept when user pass from one dropdown to other, or when exit from the editor.

Second way: I created a custom editor containing a user control containing two RadDropDownList controls and I used the Leave event of each dropDown to obtain excepted behaviour, but all I obtained is that EndEdit() of editor was first called before other event of child/nested controls.(for example if user press TAB when focused on second dropdown, editor EndEdit is fired before the drowdown Leave event handler, so new values aren't created yet and Editor value has not been set.

What's the correct way to manage events in complex grid cell custom editors?

Thnaks.

GridView

answered on 30 Jan 2017

3 answers

295 views

Custom aggregate function for winforms PivotGrid and PivotFieldList

Dear Telerik,

I am using winworms PivotGrid and PivotFeildList.

In the PivotFieldlist I want to have more aggregate functions like upper quartile and lower quartile.

Plese let me know if it is possible to make a custom function.

Thanks,

Nishan.

PivotGrid and PivotFieldList

answered on 26 Jan 2017

1 answer

195 views

Memory not getting released after creating a large mail merge

I am running into a memory issue when trying to perform a mail merge. I need to do two things:
1. Generate individual PDF files to be stored on a file share
2. generate a single PDF so it could be sent to a printer as a single job.

I am noticing, that after my large PDF file is generated, the memory usage remains very large. When I re-run the process, it starts climbing up, but then falls back down to an acceptable level during the generation of single document, only to climb back up during the final single PDF. I am pasting my code below. For some odd reason my random data isn't actually making it into the files, but since that's not my problem at this moment, I am not concerned about it.

using System;

using System.Collections.Generic;

using System.Data;

using System.IO;

using System.Linq;

using System.Threading.Tasks;

using Telerik.WinForms.Documents.FormatProviders.OpenXml.Docx;

using Telerik.WinForms.Documents.FormatProviders.Pdf;

using Telerik.WinForms.Documents.Model;

namespace MailMergeMemoryBenchmark

{

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

{

List<DummyItem> dataSource;

public RadForm1()

{

//get the rest of the string at http://pastebin.com/i6PZiJ1c

byte[] template = Convert.FromBase64String(@"UEsDBBQ...[TRUNCATED]");

dataSource = new List<DummyItem>();

for (int i = 0; i < 1000; i++)

{

dataSource.Add(DummyItem.GetRandom());

}

InitializeComponent();

var provider = new DocxFormatProvider();

radRichTextEditor1.Document = provider.Import(template);

radRichTextEditor1.ScaleFactor = new Telerik.WinForms.Documents.Model.SizeF(.4f, .4f);

radRichTextEditor1.ChangeAllFieldsDisplayMode(FieldDisplayMode.Code);

radRichTextEditor1.Document.ShowMergeFieldsHighlight = true;

radRichTextEditor1.Document.MailMergeDataSource.ItemsSource = dataSource;

}

private async void btnPerformMailMerge_Click(object sender, EventArgs e)

{

btnPerformMailMerge.Enabled = false;

var progress = new Progress<string>(value => UpdateProgress(value));

await Go(progress);

btnPerformMailMerge.Enabled = true;

}

private void UpdateProgress(string value)

{

radLabel1.Text = value + Environment.NewLine;

}

private Task<bool> Go(IProgress<string> progress)

{

return Task.Run(() =>

{

var pdfProvider = new PdfFormatProvider();

PdfExportSettings pdfExportSettings = new PdfExportSettings()

{

ContentsCompressionMode = PdfContentsCompressionMode.Automatic,

ContentsDeflaterCompressionLevel = 9,

FloatingUIContainersExportMode = PdfInlineUIContainersExportMode.Image,

ImagesCompressionMode = PdfImagesCompressionMode.Automatic,

ImagesDeflaterCompressionLevel = 9,

InlineUIContainersExportMode = PdfInlineUIContainersExportMode.Image,

};

pdfProvider.ExportSettings = pdfExportSettings;

byte[] letterBytes;

radRichTextEditor1.Document.MailMergeDataSource.MoveToFirst();

int i = 0;

do

{

using (var document = radRichTextEditor1.Document.MailMergeCurrentRecord())

{

letterBytes = pdfProvider.Export(document);

File.WriteAllBytes($"{i}-{DateTime.Now.Ticks}.pdf", letterBytes);

}

letterBytes = null;

progress.Report($"Merged {i + 1} out of {dataSource.Count()}");

i++;

} while (radRichTextEditor1.Document.MailMergeDataSource.MoveToNext());

progress.Report($"Starting large PDF creation");

using (var document = radRichTextEditor1.MailMerge(true))

{

letterBytes = pdfProvider.Export(document);

File.WriteAllBytes($"ALL RECORDS-{DateTime.Now.Ticks}.pdf", letterBytes);

}

progress.Report($"Done with large PDF creation");

letterBytes = null;

pdfProvider = null;

pdfExportSettings = null;

GC.Collect();

return true;

});

}

internal class DummyItem

{

public string ContactName;

public string CompanyName;

public string Address;

public static DummyItem GetRandom()

{

return new DummyItem()

{

ContactName = RandomStringGenerator.RandomString(20, 40),

CompanyName = RandomStringGenerator.RandomString(20, 40),

Address = RandomStringGenerator.RandomString(100, 200)

};

}

internal static class RandomStringGenerator

{

private const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789 ";

private static Random random = new Random();

public static string RandomString(int minLength, int maxLength)

{

var length = random.Next(minLength, maxLength);

return new string(Enumerable.Repeat(chars, length)

.Select(s => s[random.Next(s.Length)]).ToArray());

}

RichTextEditor

answered on 26 Jan 2017

3 answers

116 views

SectionBreakType.Continuous

I'm working with radrichtexteditor and I'm trying to insert section breaks, the problems is that I need the next section to star on the same page, I don't have this option, as I only have NextPage,EvenPage and OddPage. Please let me know if there's a way to accomplish this.

My versions
UI for WinForms is 2015.2.728
radrichtexteditor is v4.0.30319

Thank you.

RichTextEditor

answered on 26 Jan 2017

8 answers

280 views

Issue with DragDropService and TreeView

I am using a RadTreeView and the DragDropService to Drag/Drop of nodes into the same tree at different levels. The data on the Tree is bound to an object. Everything is working except, I can't get the tree on my form to show when the dragdrop has completed so I can update the underline table when changes are made. None of the events are firing, DragDrop, DragEnded, etc. What am I missing.

If this has already been discussed, can someone just point me to the thread. I search, but didn't see this anywhere.

TIA.

Treeview