Telerik Forums
UI for WinForms Forum
12 answers
1.6K+ views

Hello All, 

I have the problem with RadGridView.

How to fill RadGridView with only selected field from dataset.

I have 4 field in dataset, and only field BERAT that only i want to fill to datagrid.

How can make this happen.

 

The field is : NoTransaksi, NoUrut, Berat

 

 

 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 21 Feb 2020
1 answer
173 views

Hi Telerik Team,

I would like to ask how to change the border color of the raddropdownlist during mouse hover event?

Please see attached image for your reference. That is my desired outcome.

I appreciate your quick response on this concern. Thank you!

Nadya | Tech Support Engineer
Telerik team
 answered on 20 Feb 2020
1 answer
91 views

Hello,

Please help me figure out the error in below xml file. When I use function LoadLayout of RadGridView, the grid layout not load and the application is not repond

Thank you very much

<RadGridView BeginEditMode="BeginEditOnKeystroke" ShowNoDataText="False" AutoSizeRows="True" GroupExpandAnimationType="Slide" BackColor="239, 239, 239" ForeColor="Black" EnableCustomGrouping="True" Font="Microsoft Sans Serif, 11.25pt" Cursor="Default" RightToLeft="No" TabIndex="0" ImeMode="NoControl">
  <MasterTemplate MultiSelect="True" AllowColumnHeaderContextMenu="False" AllowCellContextMenu="False" AllowDeleteRow="False" AllowAddNewRow="False" AllowSearchRow="True" EnableCustomGrouping="True" EnableFiltering="True" AutoGenerateColumns="False" AutoExpandGroups="True" ShowFilteringRow="False">
    <Columns>
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="41" FieldName="FlightId" Name="FlightId" EnableExpressionEditor="False" IsVisible="False" IsPinned="True" PinPosition="Left" ReadOnly="True" HeaderText="FLT ID" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="29" Name="No" EnableExpressionEditor="False" IsVisible="True" IsPinned="True" PinPosition="Left" AllowSort="False" AllowGroup="False" HeaderText="No" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="64" FieldName="FlightNo" Name="FlightNo" EnableExpressionEditor="False" IsVisible="True" IsPinned="True" PinPosition="Left" AllowSort="False" ReadOnly="True" HeaderText="Flight" />
      <Telerik.WinControls.UI.GridViewImageColumn Width="53" Name="Icon" EnableExpressionEditor="False" IsVisible="False" IsPinned="True" PinPosition="Left" AllowSort="False" HeaderText="Notice" />
      <Telerik.WinControls.UI.GridViewDateTimeColumn Format="Custom" FormatString="{0:dd}" Width="35" FieldName="FlightDate" Name="FlightDate" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" ReadOnly="True" HeaderText="Date" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewComboBoxColumn Width="98" FieldName="ACType" Name="ACType" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Aircraft" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="92" FieldName="ACRegNo" Name="ACRegNo" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Registration" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="74" FieldName="Config" Name="Config" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="Config" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="65" FieldName="Booking" Name="Booking" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="Booking" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="84" FieldName="Route" Name="Route" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Route" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="ScheduledTime" Name="ScheduledTime" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="STA" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="41" FieldName="DepTime" Name="DepTime" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="DEP" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="52" FieldName="MVA" Name="MVA" EnableExpressionEditor="False" IsVisible="True" HeaderText="SKED&#xA;CHG" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="EstimatedTime" Name="EstimatedTime" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="ETA" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="52" FieldName="CTOT" Name="CTOT" EnableExpressionEditor="False" IsVisible="False" HeaderText="CTOT" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="InOutBoundTime" Name="InOutBoundTime" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="IBT" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="57" FieldName="ACDoorClose" Name="ACDoorClose" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="AC DR&#xA;CLS" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="PushBackTime" Name="PushBackTime" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="PBT" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="ActualTime" Name="ActualTime" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="ATA" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="48" FieldName="ChockTime" Name="ChockTime" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="C.ON" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="32" FieldName="ArrTime" Name="ArrTime" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="ARR" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="44" FieldName="CheckinOpenTime" Name="CheckinOpenTime" IsVisible="False" HeaderText="CKI&#xA;OPN" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="CheckinClosedTime" Name="CheckinClosedTime" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="CKI&#xA;CLS" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="52" FieldName="GateClosedTime" Name="GateClosedTime" EnableExpressionEditor="False" IsVisible="False" HeaderText="GATE&#xA;CLS" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="44" FieldName="BoardingTime" Name="BoardingTime" EnableExpressionEditor="False" IsVisible="False" HeaderText="BDG&#xA;Call" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="44" FieldName="BoardingStart" Name="BoardingStart" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="BDG&#xA;Start" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="51" FieldName="BoardingFinish" Name="BoardingFinish" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="BDG&#xA;Finish" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="44" FieldName="FirstBag" Name="FirstBag" EnableExpressionEditor="False" IsVisible="True" HeaderText="1ST&#xA;BAG" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="44" FieldName="LastBag" Name="LastBag" EnableExpressionEditor="False" IsVisible="True" HeaderText="LST&#xA;BAG" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="37" FieldName="ParkingBay" Name="ParkingBay" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Bay" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn Width="43" FieldName="Gate" Name="Gate" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Bus&#xA;Gate" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="53" FieldName="CkiRow" Name="CkiRow" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="CKI Row" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="60" FieldName="TotalPax" Name="TotalPax" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="TTL PAX" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="30" FieldName="ADL" Name="ADL" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="ADL" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="30" FieldName="CHD" Name="CHD" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="CHD" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="30" FieldName="INF" Name="INF" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="INF" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="20" FieldName="F" Name="F" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="F" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn DataType="System.Int32" FieldName="C" Name="C" EnableExpressionEditor="False" IsVisible="False" HeaderText="C" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" FieldName="ADL2" Name="ADL2" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="Ts&#xA;ADL" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" FieldName="CHD2" Name="CHD2" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="Ts&#xA;CHD" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" FieldName="INF2" Name="INF2" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="Ts&#xA;INF" />
      <Telerik.WinControls.UI.GridViewComboBoxColumn Width="53" FieldName="Status" Name="Status" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Status" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewCommandColumn Width="42" FieldName="FlightDelayReasons" Name="FlightDelayReasons" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="DLY&#xA;RSN" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewComboBoxColumn Width="61" FieldName="FlightType" Name="FlightType" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Nature&#xA;of Load" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewComboBoxColumn Width="56" FieldName="NatureOfFlight" Name="NatureOfFlight" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Nature&#xA;of Flt" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="70" FieldName="Terminal" Name="Terminal" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Terminal" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="52" FieldName="Lobby" Name="Lobby" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Lobby" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="36" FieldName="Belt" Name="Belt" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" HeaderText="Belt" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="40" FieldName="BagPcs" Name="BagPcs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="BAG&#xA;(Pcs)" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Decimal" Width="70" FieldName="BagKgs" Name="BagKgs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="BAG&#xA;(Kgs)" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Int32" Width="40" FieldName="CgoPcs" Name="CgoPcs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="CGO&#xA;(Pcs)" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Decimal" Width="70" FieldName="CgoKgs" Name="CgoKgs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="CGO&#xA;(Kgs)" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn DataType="System.Int32" FieldName="BookingCargo" Name="BookingCargo" EnableExpressionEditor="False" IsVisible="False" ReadOnly="True" HeaderText="Booking&#xA;CGO" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn DataType="System.Int32" FieldName="BookingOffload" Name="BookingOffload" IsVisible="False" HeaderText="Booking&#xA;OFLD" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn DataType="System.Int32" FieldName="LIRCargo" Name="LIRCargo" EnableExpressionEditor="False" IsVisible="False" ReadOnly="True" HeaderText="LIR&#xA;CGO" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Decimal" Width="40" FieldName="Mailkgs" Name="Mailkgs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="Mail&#xA;(Kgs)" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" DataType="System.Decimal" Width="60" FieldName="TransferKgs" Name="TransferKgs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="TS.&#xA;(Dom.)" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn DataType="System.Decimal" FieldName="Transfer2Kgs" Name="Transfer2Kgs" EnableExpressionEditor="False" IsVisible="False" HeaderText="TS.&#xA;(Int.)" TextAlignment="MiddleCenter" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn DataType="System.Int32" FieldName="DiffKgs" Name="DiffKgs" EnableExpressionEditor="False" IsVisible="False" AllowGroup="False" HeaderText="Diff.&#xA;Cgo" TextAlignment="MiddleRight" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" FieldName="OutputRemarks" Name="OutputRemarks" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" AllowGroup="False" HeaderText="Loading Remarks" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" Width="122" FieldName="SSR" Name="SSR" EnableExpressionEditor="False" IsVisible="True" AllowSort="False" AllowGroup="False" HeaderText="SSR" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="80" FieldName="Grnd_Cor" Name="Grnd_Cor" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="GRND&#xA;OPS COR" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="80" FieldName="Pbb_Agent" Name="Pbb_Agent" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="FPL" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="80" FieldName="Grnd_Ld" Name="Grnd_Ld" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="GRND&#xA;OPS LD" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="100" FieldName="Grnd_Ls" Name="Grnd_Ls" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="GRND&#xA;OPS LS" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="100" FieldName="PAX_SUPR" Name="Pax_Supr" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="ARR STAFF" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="80" FieldName="Pax_Csr" Name="Pax_Csr" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="BAG&#xA;HLD" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="80" FieldName="Ramp_Supr" Name="Ramp_Supr" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="RAMP&#xA;HLD SUP" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" FieldName="Vip_Svc" Name="Vip_Svc" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="VIP/CIP" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowSearching="False" Width="80" FieldName="CABIN_CLEAN" Name="CABIN_CLEAN" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="Cabin&#xA;Cleaning" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" AllowSearching="False" DataType="System.Int32" FieldName="Locked" Name="Locked" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="Locked" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" AllowSearching="False" DataType="System.Int32" FieldName="IsSAGS" Name="IsSAGS" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="IsSAGS" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn AllowFiltering="False" AllowSearching="False" DataType="System.Int32" FieldName="ClickedInOutBoundTime" Name="ClickedInOutBoundTime" EnableExpressionEditor="False" IsVisible="False" AllowSort="False" HeaderText="ClickedInOutBoundTime" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn FieldName="RouteType" Name="RouteType" EnableExpressionEditor="False" IsVisible="False" HeaderText="RouteType" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn FieldName="Indicator" Name="Indicator" EnableExpressionEditor="False" IsVisible="False" HeaderText="Indicator" />
      <Telerik.WinControls.UI.GridViewTextBoxColumn FieldName="COBT" Name="COBT" EnableExpressionEditor="False" IsVisible="False" HeaderText="COBT" TextAlignment="MiddleCenter" />
    </Columns>
    <ViewDefinition xsi:type="Telerik.WinControls.UI.TableViewDefinition" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" />
  </MasterTemplate>
</RadGridView>
Nadya | Tech Support Engineer
Telerik team
 answered on 20 Feb 2020
4 answers
462 views

hi I'm running visual studio 2019, with Telerik Winforms UI 2019.2.508.40

I'm trying to convert an existing VB project to Telerik controls, but I don't see the menu option for the converter tool.    (Under Extensions->Telerik->Telerik for WInforms, I see a bunch of options:  Configure project, AddRad** References, and AddRad** Forms, but no option to convert.   (In a new or existing project) 

I have read this thread: https://www.telerik.com/forums/convert-your-existing-application-to-telerik-ui-for-for-winforms-does-not-work

with no luck. 

I have tried adding the Telerik Winforms VsExtension through the Extention manager but it is not showing anywhere that I can find as an option to install. 

Running
C:\Program Files (x86)\Progress\Telerik UI for WinForms R2 2019\VSExtensions\VS2019\Telerik.WinControls.VSPackage.vsix
reports that:
"This extension is already installed to all applicable projects"

 

Any ideas?  Thanks,

 

 

 

Dimitar
Telerik team
 answered on 20 Feb 2020
1 answer
70 views

Hello.

I'm tring to make a custom cell with radtimepickerelement but something is not working in SetContentCore because any value I set in the timepicker editor when i see the value it's always nothing.

 

And in the other hand I can't use the custom editor in the row witch is used for add new rows in the grid.

 

I've done a sample code if you could help me

Thx.

 

 

  Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
        Dim colnombre As New GridViewTextBoxColumn("nombre")
        Dim colHora As New TimePickerColumn("hora")

        GVPrueba.Columns.Add(colnombre)
        GVPrueba.Columns.Add(colHora)

        GVPrueba.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill


    End Sub

    Private Sub GVPrueba_SelectionChanged(sender As Object, e As EventArgs) Handles GVPrueba.SelectionChanged
        If GVPrueba.SelectedRows.Count = 1 Then

            If GVPrueba.SelectedRows(0).Cells("hora").Value IsNot Nothing Then
                MsgBox(GVPrueba.SelectedRows(0).Cells("hora").Value.ToString)

            End If
        End If
    End Sub




    Private Sub RadButton1_Click(sender As Object, e As EventArgs) Handles RadButton1.Click
        If GVPrueba.Rows.Count > 0 Then
            GVPrueba.Rows(0).Cells("hora").Value = Now
        End If
    End Sub


    Public Class TimePickerCellElement
        Inherits GridDataCellElement

        Public Sub New(ByVal column As GridViewColumn, ByVal row As GridRowElement)
            MyBase.New(column, row)
        End Sub

        Private oRadTimePickerElement As RadTimePickerElement
        Protected Overrides Sub CreateChildElements()
            MyBase.CreateChildElements()
            oRadTimePickerElement = New RadTimePickerElement()
            Me.Children.Add(oRadTimePickerElement)
        End Sub

        Protected Overrides Sub SetContentCore(value As Object)
            If Me.Value IsNot Nothing AndAlso Me.Value IsNot DBNull.Value Then
                DateTime.TryParse(value, oRadTimePickerElement.Value)
                '       MyBase.SetContentCore(value)
            End If
        End Sub

        Public Overrides Function IsCompatible(ByVal data As GridViewColumn, ByVal context As Object) As Boolean
            Return TypeOf data Is TimePickerColumn AndAlso (TypeOf context Is GridDataRowElement OrElse TypeOf context Is GridNewRowElement)
        End Function

    End Class

    Public Class TimePickerColumn
        Inherits GridViewDataColumn
        Public Sub New(ByVal fieldName As String)
            MyBase.New(fieldName)
        End Sub

        Public Overrides Function GetCellType(ByVal row As GridViewRowInfo) As Type
            If TypeOf row Is GridViewDataRowInfo Then
                Return GetType(TimePickerCellElement)
            End If
            Return MyBase.GetCellType(row)
        End Function

    End Class

 


Nadya | Tech Support Engineer
Telerik team
 answered on 20 Feb 2020
7 answers
499 views

 Is there a way to display an encrypted file in PdfViewer ?

I created a file:

formatProvider = new Telerik.Windows.Documents.Fixed.FormatProviders.Pdf.PdfFormatProvider();
formatProvider.ExportSettings.UserPassword = "xxx";
formatProvider.ExportSettings.IsEncrypted = true;

formatProvider.Export( ...)

And now I want to display it, but haven't found a place to pass a password to the viewer.
It's not displaying any error, it's just displaying - the correct number of - empty pages.

 

Tanya
Telerik team
 answered on 20 Feb 2020
4 answers
587 views

Hi there,

I've been tasked with migrating DataTable functionality to Telerik RadGridView in a C# WinForms app.

DataTable code sample:

   var taxColumn = new DataColumn();
   taxColumn.DataType = System.Type.GetType("System.String");
   taxColumn.ColumnName = "tax";
   taxColumn.Expression = "SUBSTRING('ABC',2,3)";

My attempt to do the equivalent using a RadGridView TextBoxColumn fails with "unknown function SUBSTRING()".

Is there any similar functionality in RadGridView to the Substring function in DataColumn please? It's essential to be able to write expressions that do substirng operations in the app I'm working on.

 

Thanks as ever for your help!

Kind regards, James

James
Top achievements
Rank 1
 answered on 19 Feb 2020
3 answers
91 views

I am happy Telerik created these dialogs for aesthetic reasons.

Is there a way to restrict access to file operations (Delete, copy, et. al.)?? I want to restrict file functions that can be performed via these dialogs. For example, I want to prevent someone from copying files from a USB when selecting a folder or selecting a file.

 

Thanks,

 

Jim

 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 19 Feb 2020
15 answers
896 views

Hi,

I need to build a solution to export text from PDF including their X,Y cordinates. 

Could it be done with PDFViewer or other Telerik product?

Best regards,
André

Tanya
Telerik team
 answered on 19 Feb 2020
2 answers
112 views

Hi, i read the documentation for "custom-sorting" and "Setting Sorting Programmatically" but that´s not my case.

i need a possibility to add a custom-sorting only for one column and sort with the data of a hidden column.

What´s the right way to do that?

Best regards

Martin

Martin
Top achievements
Rank 1
 answered on 19 Feb 2020
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
ComboBox and ListBox (obsolete as of Q2 2010)
ListView
Chart (obsolete as of Q1 2013)
Form
PageView
MultiColumn ComboBox
TextBox
RichTextEditor
Menu
PropertyGrid
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
Rotator
TrackBar
MessageBox
SpinEditor
StatusStrip
CheckedListBox
Wizard
ShapedForm
SyntaxEditor
TextBoxControl
LayoutControl
CollapsiblePanel
Conversational UI, Chat
DateTimePicker
TabbedForm
CAB Enabling Kit
DataEntry
GroupBox
ScrollablePanel
WaitingBar
ScrollBar
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
ColorBox
Callout
FilterView
PictureBox
VirtualKeyboard
NavigationView
Accessibility
DataLayout
ToastNotificationManager
ValidationProvider
CalculatorDropDown
Localization
TimePicker
ButtonTextBox
FontDropDownList
Licensing
BreadCrumb
Security
LocalizationProvider
Dictionary
Overlay
Separator
SparkLine
TreeMap
StepProgressBar
SplashScreen
Flyout
ToolbarForm
NotifyIcon
Rating
TimeSpanPicker
BarcodeView
Calculator
OfficeNavigationBar
TaskbarButton
HeatMap
SlideView
PipsPager
AIPrompt
TaskDialog
DateOnlyPicker
TimeOnlyPicker
+? more
Top users last month
Henri
Top achievements
Rank 2
Iron
Iron
Iron
SUNIL
Top achievements
Rank 2
Iron
Iron
Iron
David
Top achievements
Rank 1
Jackson
Top achievements
Rank 1
Iron
Iron
Tim
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Henri
Top achievements
Rank 2
Iron
Iron
Iron
SUNIL
Top achievements
Rank 2
Iron
Iron
Iron
David
Top achievements
Rank 1
Jackson
Top achievements
Rank 1
Iron
Iron
Tim
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?