GridViewMultiColumnComboBox Filtering

[meraj]

Hi..
   We are using RadGridMultiColumnCombo Column in the gridview...
We have hundreds of rows in the dropdown, we want to filter them ....
 For this I have set the AutoCompleteMode To AppendSuggest And set DropDownStyle to DropDown
still i m not able to filter the records...

I want it to filter in such a way that, when i click some number it should give me all records starting with that number..

[Richard Slade]

Hello,

It sounds like you are doing the right things but here is an examepl for you to try

Designer File vb

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class Form1
    Inherits System.Windows.Forms.Form

    'Form overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()> _
    Protected Overrides Sub Dispose(ByVal disposing As Boolean)
        Try
            If disposing AndAlso components IsNot Nothing Then
                components.Dispose()
            End If
        Finally
            MyBase.Dispose(disposing)
        End Try
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> _
    Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container()
        Me.RadGridView1 = New Telerik.WinControls.UI.RadGridView()
        Me.BindingSource1 = New System.Windows.Forms.BindingSource(Me.components)
        CType(Me.RadGridView1, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.BindingSource1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'RadGridView1
        '
        Me.RadGridView1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.RadGridView1.EnableHotTracking = False
        Me.RadGridView1.Location = New System.Drawing.Point(0, 0)
        '
        'RadGridView1
        '
        Me.RadGridView1.MasterTemplate.EnableFiltering = True
        Me.RadGridView1.MasterTemplate.EnableSorting = False
        Me.RadGridView1.Name = "RadGridView1"
        Me.RadGridView1.ShowGroupPanel = False
        Me.RadGridView1.Size = New System.Drawing.Size(418, 372)
        Me.RadGridView1.TabIndex = 0
        Me.RadGridView1.Text = "RadGridView1"
        Me.RadGridView1.UseCompatibleTextRendering = False
        '
        'Form1
        '
        Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
        Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
        Me.ClientSize = New System.Drawing.Size(418, 372)
        Me.Controls.Add(Me.RadGridView1)
        Me.Name = "Form1"
        Me.Text = "Form1"
        CType(Me.RadGridView1, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.BindingSource1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub
    Friend WithEvents RadGridView1 As Telerik.WinControls.UI.RadGridView
    Friend WithEvents BindingSource1 As System.Windows.Forms.BindingSource

End Class

Form1.vb

Imports Telerik.WinControls
Imports Telerik.WinControls.UI
Imports System.ComponentModel
Imports Telerik.WinControls.Data


Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object,
                           ByVal e As System.EventArgs) Handles MyBase.Load


        Me.RadGridView1.EnableFiltering = True
        Me.RadGridView1.ShowFilteringRow = True

        Dim objectList As New List(Of MyObject)
        objectList.Add(New MyObject("AName1", 1))
        objectList.Add(New MyObject("BName2", 2))
        objectList.Add(New MyObject("BName3", 3))
        objectList.Add(New MyObject("BName4", 4))
        objectList.Add(New MyObject("AName5", 5))
        objectList.Add(New MyObject("BName6", 6))


        Dim comboColumn As New GridViewComboBoxColumn("MyObject")
        comboColumn.DropDownStyle = RadDropDownStyle.DropDown
        comboColumn.DataSource = objectList
        comboColumn.DisplayMember = "Name"
        comboColumn.ValueMember = "Name"
        comboColumn.AutoCompleteMode = AutoCompleteMode.SuggestAppend

        Me.RadGridView1.Columns.Add(comboColumn)
        Me.RadGridView1.Columns.Add(New GridViewTextBoxColumn("AnotherColumn"))

        Me.RadGridView1.Rows.Add("AName1", "B1")
        Me.RadGridView1.Rows.Add("BName2", "B2")




    End Sub

End Class


Public Class MyObject
    Public Sub New()

    End Sub

    Public Sub New(ByVal name As String, ByVal number1 As Integer)
        Me.Name = name
        Me.Number1 = number1
    End Sub

    Public Property Name As String
    Public Property Number1 As Integer
End Class

Hope that helps but let me know if you need more info
Richard

[meraj]

Hello Richard..
              I have done the same thing which you sent me . but still its not working....The only difference is I m adding columns at the designer and not in the code... In Code I m adding the following lines..
       
          
           If TypeOf Column Is GridViewMultiComboboxColumn Then
            Dim comboColumn as GridViewMultiComboboxColumn = TryCast(Column ,                           GridViewMultiComboboxColumn)


        comboColumn.DropDownStyle = RadDropDownStyle.DropDown

        comboColumn.DataSource = DS

        comboColumn.DisplayMember = "AccID"

        comboColumn.ValueMember = "AccID"

        comboColumn.AutoCompleteMode = AutoCompleteMode.SuggestAppend

              End IF

[Richard Slade]

Hello,

A couple of things. Where are you adding the code below? Also, have you tried the sample that I posted earlier and did this work for you?
Look forward to hearing back from you
Richard

[meraj]

Hello Richard..

             I am adding this code in the Form Load Event... As for as your code is concerned It is working for GridViewComboBoxColumn
but I Changed your Code For GridViewMultiComboboxColumn its not working..

I am using the GridViewMultiComboboxColumn for this its not working... If I change this column to GridViewComboBoxColumn it is working..

[Richard Slade]

Hello,

Firstly, my apologies, I must be tired as I have missed that this was for a MultiColumn and not just a normal drop down.
The GridViewMultiColumnComboBox does not support AutoComplete at the moment straight out-of-the-box.

There is a feature request in the Public Issue Tracking system which you can vote for to add this feature here and there is a forum thread here that attempts to simulate AutoComplete on this column type.

Hope that helps and my apologies again for not letting you know this information the first time around.
regards,
Richard