Telerik Forums
UI for WinForms Forum
1 answer
44 views

Using the expression editor in a gridview, I'm trying to determine how much time in minutes has passed between a column that only has time and NOW()

 

Column:  arrived_time (time)

something along the line of: DATEDIFFMINUTE(arrived_time, NOW()) >= 15

since arrived_time is time only, it seems to fail when compared to NOW().

Is there a way to add today()+arrived_time to get a proper datetime value?  

End goal is if more than 15 minutes has passed since arrived_time then change RowBackColor

Dinko | Tech Support Engineer
Telerik team
 answered on 21 Aug 2024
1 answer
56 views

Hi, 
       I want to drag and drop row in same grid like reorder the row. Is it possible to without create custom control ?
Actually we have file names in each row, user want to merge the file based on drag and drop, So user from which place to which place drop the row, we will merge that two file and refresh in grid. So for this we want drag and drop function.

I tried RadGridView.AllowRowReorder property to true , but still cant drag and drop the row. This is page load code for bind data in grid.

Private Sub LoadData()
        ' Create a DataTable and define its structure
        Dim dataTable As New DataTable()
        dataTable.Columns.Add("ID", GetType(Integer))
        dataTable.Columns.Add("Name", GetType(String))
        dataTable.Columns.Add("Age", GetType(Integer))

        ' Add some rows to the DataTable
        dataTable.Rows.Add(1, "John Doe", 30)
        dataTable.Rows.Add(2, "Jane Smith", 25)
        dataTable.Rows.Add(3, "Sam Brown", 35)

        ' Bind the DataTable to the RadGridView
        RadGridView1.DataSource = dataTable
    End Sub

Pls provide sample code in vb,

Thanks and Regards
Aravind
Nadya | Tech Support Engineer
Telerik team
 answered on 19 Aug 2024
1 answer
54 views

Hi folks.  There seems to be a lot of questions about this and every answer I could find pointed me at some web solution.  This is Winforms and nothing I've seen so far has been in line with my current issue - so here goes!

WinForms .Net 4.7.2 VB

A simple grid (See gridPIC.png)

3 Columns:

  • Decimal DecimalPlaces = 0  FormatString = {0:N0}
  • Decimal DecimalPlaces = 2  FormatString = {0:N2}
  • Decimal DecimalPlaces = 4  FormatString = {0:N4}

Export property settings:

  • HiddenColumnOption = HiddenOption.DoNotExport
  • SummariesExportOption = SummariesOption.DoNotExport
  • ExportVisualSettings = False


When using ExportFormat = SpreadStreamExportFormat.Csv you can see the integer shows 111, the 2 decimal data shows 222.22 and the four decimal data shows 333.3333 as expected. (See csvPIC.png)

But when using ExportFormat = SpreadStreamExportFormat.Xlsx the results are incorrect (*See ExcelPic.png)

 

I was expecting that the export file would include the format information.  I thought perhaps because I'd set spreadStreamExport.ExportVisualSettings = False that this was the cause but I can flip that to True and the output is identical.

The DATA that gets into Excel IS CORRECT.  It's just not formatting the cells as expected.

Is there any way for spreadStreamExport to output the proper Decimal formatting? 

If yes, can you point me at a sample?  C# is just fine if you folks aren't vb.net users.

 

Thank you all!

Curtis

 

Nadya | Tech Support Engineer
Telerik team
 answered on 15 Aug 2024
4 answers
1.9K+ views

I have  abound gridview that i have added a checkbox column to as the first column.
i cannot check any checkboxes in any row, only able to check the headercheckbox which selects all checkboxes of every row.

Dim checkboxcolumn As New GridViewCheckBoxColumn
checkboxcolumn.DataType = GetType(Integer)
checkboxcolumn.Name = "SelectedColumn"
checkboxcolumn.FieldName = "Select"
checkboxcolumn.HeaderText = "Select?"
GV_Assets.MasterTemplate.Columns.Add(checkboxcolumn)
checkboxcolumn.EnableHeaderCheckBox = True

 

Julian
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 15 Aug 2024
8 answers
798 views
Hi,

I am unable to highlight the full dropdown list (including the text box and button) 

The attached file will show how it is currently highlight but would like to highlight in the same way(color and thickness) as the textbox in the attached file. I used the below code but it did not highlight the button.

Thanks in advance for your help.



radDDL.DropDownListElement.TextBox.Fill.BackColor = Color.Red;
Todor
Telerik team
 updated answer on 12 Aug 2024
1 answer
108 views

How to convert PDF pages to images in .NET Framework app? I've scoured the site, and it seems you recommend something like this:


RadPdfViewer pdfViewer = new RadPdfViewer();

pdfViewer.DocumentLoaded += (sender, e) =>
{
	if (sender is RadPdfViewerElement pdfViewerElement)
	{
		for (int i = 1; i <= pdfViewerElement.Document.Pages.Count; i++)
		{
			Image pageImage = pdfViewerElement.ExportPage(i, 1, true, ImageFormat.Jpeg);

			// Use pageImage
		}
	}
};

pdfViewer.LoadDocument(pdfPath);
pdfViewer.LoadElementTree();
Application.DoEvents();

Is this really the best way for .NET Framework apps? There is an example that uses PdfProcessing instead of PdfViewer, but requires the assembly Telerik.Documents.Fixed.FormatProviders.Image.Skia, which I don't have available in my Visual Studio with latest update of Telerik UI for WinForms 2024.3.806.462. Nor is it available on nuget, or I don't know how to find it.

Dinko | Tech Support Engineer
Telerik team
 answered on 08 Aug 2024
2 answers
104 views

Hi everyone,

I’m currently using RadRichTextEditor to print logs. I have the following scenario:

  • The first line prints "Hello" in black font.
  • The second line prints "world" in red font.

How can I change the font color for different lines in RadRichTextEditor?

Thank you!

Kevin
Top achievements
Rank 2
Iron
Iron
 updated question on 05 Aug 2024
1 answer
54 views
I know how to copy text using context menu, but I also need copy text using shortcut.
Nadya | Tech Support Engineer
Telerik team
 answered on 05 Aug 2024
1 answer
75 views

Created a column like this:


if (operation == "viplata")
            {
                GridViewCheckBoxColumn checkBoxColumn = new GridViewCheckBoxColumn
                {
                    DataType = typeof(bool),
                    Name = "Выбрать",
                    FieldName = "Выбрать",
                    HeaderText = "Выбрать",
                    EditMode = EditMode.OnValueChange,
                    ReadOnly = false
                };
                checkBoxColumn.EnableHeaderCheckBox = true;
                radGridView1.MasterTemplate.Columns.Add(checkBoxColumn);
            }

The column is shown, but nothing can be selected. I have an event connected to DataGridView1_DoubleClick, so the checkboxes must be set by one click. How can I implement it?

I have grouping enabled in my grid.How can I make it so that when I press a key, only open checkBoxColumn groups are selected?Thanks for your help.

Jesse
Top achievements
Rank 1
Iron
 updated answer on 05 Aug 2024
3 answers
69 views

Hi, I am customizing the theme VisualStudio2022Light. I have changed the purple color to the teal. However, I am not able to change the background and selected row in the theme.

 

When I run my application, it is still in purple.

I found a similar issue where I couldn't find where I can change the close button during click in the RadForm.

Henri
Top achievements
Rank 2
Iron
Iron
Iron
 answered on 01 Aug 2024
Narrow your results
Selected tags
Tags
GridView
General Discussions
Scheduler and Reminder
Treeview
Dock
RibbonBar
Themes and Visual Style Builder
ChartView
Calendar, DateTimePicker, TimePicker and Clock
DropDownList
Buttons, RadioButton, CheckBox, etc
ListView
ComboBox and ListBox (obsolete as of Q2 2010)
Chart (obsolete as of Q1 2013)
Form
PageView
MultiColumn ComboBox
TextBox
RichTextEditor
PropertyGrid
Menu
RichTextBox (obsolete as of Q3 2014 SP1)
Panelbar (obsolete as of Q2 2010)
PivotGrid and PivotFieldList
Tabstrip (obsolete as of Q2 2010)
MaskedEditBox
CommandBar
PdfViewer and PdfViewerNavigator
ListControl
Carousel
Diagram, DiagramRibbonBar, DiagramToolBox
GanttView
Panorama
New Product Suggestions
Toolstrip (obsolete as of Q3 2010)
VirtualGrid
AutoCompleteBox
Label
Spreadsheet
ContextMenu
Panel
Visual Studio Extensions
TitleBar
Documentation
SplitContainer
Map
DesktopAlert
ProgressBar
CheckedDropDownList
TrackBar
MessageBox
Rotator
SpinEditor
StatusStrip
CheckedListBox
LayoutControl
SyntaxEditor
Wizard
ShapedForm
TextBoxControl
DateTimePicker
CollapsiblePanel
Conversational UI, Chat
TabbedForm
CAB Enabling Kit
GroupBox
DataEntry
ScrollablePanel
ScrollBar
WaitingBar
ImageEditor
Tools - VSB, Control Spy, Shape Editor
BrowseEditor
DataFilter
ColorDialog
FileDialogs
Gauges (RadialGauge, LinearGauge, BulletGraph)
ApplicationMenu
RangeSelector
CardView
WebCam
BindingNavigator
PopupEditor
RibbonForm
Styling
TaskBoard
Barcode
Callout
ColorBox
PictureBox
FilterView
Accessibility
VirtualKeyboard
NavigationView
DataLayout
ToastNotificationManager
ValidationProvider
CalculatorDropDown
Localization
TimePicker
ButtonTextBox
FontDropDownList
Licensing
BarcodeView
BreadCrumb
Security
LocalizationProvider
Dictionary
Overlay
Flyout
Separator
SparkLine
TreeMap
StepProgressBar
SplashScreen
ToolbarForm
NotifyIcon
DateOnlyPicker
Rating
TimeSpanPicker
Calculator
OfficeNavigationBar
TaskbarButton
HeatMap
SlideView
PipsPager
AIPrompt
TaskDialog
TimeOnlyPicker
+? more
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?