I have a dataset witha datatable which contains a field called "PersonID" which is type UInt32. I want to duplicate the filter example in your demo application so amended the code to suit my fields, as shown below. I also set the DisplayMember to "PersonID".
GridViewTextBoxColumn column = new GridViewTextBoxColumn("PersonID");
column.HeaderText = "Person";
column.IsPinned = true;
multiColumnComboElement.Columns.Add(column);
I added your filter code
FilterExpression filter = new FilterExpression(this.radMultiColumnComboBoxFind.DisplayMember,
FilterExpression.BinaryOperation.AND,
GridKnownFunction.StartsWith, GridFilterCellElement.ParameterName);
filter.Parameters.Add(GridFilterCellElement.ParameterName, string.Empty);
this.radMultiColumnComboBoxFind.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filter);
this.radMultiColumnComboBoxFind.MultiColumnComboBoxElement.AutoCompleteMode = AutoCompleteMode.None;
this.radMultiColumnComboBoxFind.DropDownStyle = RadDropDownStyle.DropDown;
I keep getting the error "Cannot perform 'Like' operation on System.UInt32 and System.String.". I guess it's something to do with the column being string and the underlying data Unit32. I don't want to change the datatype in the datatable to a string. Is there anyway to get this working. Many thanks in advance.
Alex
GridViewTextBoxColumn column = new GridViewTextBoxColumn("PersonID");
column.HeaderText = "Person";
column.IsPinned = true;
multiColumnComboElement.Columns.Add(column);
I added your filter code
FilterExpression filter = new FilterExpression(this.radMultiColumnComboBoxFind.DisplayMember,
FilterExpression.BinaryOperation.AND,
GridKnownFunction.StartsWith, GridFilterCellElement.ParameterName);
filter.Parameters.Add(GridFilterCellElement.ParameterName, string.Empty);
this.radMultiColumnComboBoxFind.EditorControl.MasterGridViewTemplate.FilterExpressions.Add(filter);
this.radMultiColumnComboBoxFind.MultiColumnComboBoxElement.AutoCompleteMode = AutoCompleteMode.None;
this.radMultiColumnComboBoxFind.DropDownStyle = RadDropDownStyle.DropDown;
I keep getting the error "Cannot perform 'Like' operation on System.UInt32 and System.String.". I guess it's something to do with the column being string and the underlying data Unit32. I don't want to change the datatype in the datatable to a string. Is there anyway to get this working. Many thanks in advance.
Alex