List the Data in the List Box

Posted by: mohanmuthusamy on 8 September 2017, 1:31 pm EST

  • Posted 8 September 2017, 1:31 pm EST

    Dear Friends,

                       I used Farpoint Windows Edition. In the Below Image we see Commodity filed in Farpoint. If we press Any Letter, based upon the letter we must filter and show the related datas in the  list box(seen in right hand side).. For example in that Image they enter "p" . in that list box we are seeing that related datas.

                           I tried but its Working after comes out from the cell or else we press enter button only we can able to capture the particular cell data

     I need to to capture the data at time each and every key press. then only we capture the generate query using like function and Filtre the data and listed in the list box.

             Can u give solution for this problem or else Give solution to solve this problem for using some other concept

     Filter

  • Replied 8 September 2017, 1:31 pm EST

    Map the KeyDown and KeyUp events to the EditMode events...

    Private Sub FpSpread1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles FpSpread1.KeyDown

    '...
    End Sub



    Private Sub FpSpread1_EditModeOn(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOn

    Dim KeyDownHandler As System.Windows.Forms.KeyEventHandler = AddressOf FpSpread1_KeyDown

    AddHandler FpSpread1.EditingControl.KeyDown, KeyDownHandler

    End Sub



    Private Sub FpSpread1_EditModeOff(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOff

    Dim KeyDownHandler As System.Windows.Forms.KeyEventHandler = AddressOf FpSpread1_KeyDown

    RemoveHandler FpSpread1.EditingControl.KeyDown, KeyDownHandler

    End Sub 

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels