I have a RadGridView with a GridViewMultiComboBoxColumn in it.
The GridView that pops up is working properly, and I have the columns I want to display, however, the ValueMember is set to a property that is a Guid type. The entire column is bound to a Guid value, and the comboboxes are displaying a different value. So far so good.
The problem comes when I want to filter the grid by this Guid value. I get various ParserExceptions, and they differ from Guid to Guid, based on the actual Guid. One example is the following:
"Missing operator before c0aee operand."
This is happening on a Guid whose value is 986c0aee-4987-4384-b8e6-551b2fb7a41e.
I've pasted the stack trace below, and at it's root, it appears to be trying to set an expression that looks like this:
AssetID = 986c0aee-4987-4384-b8e6-551b2fb7a41e
Obviously, the parser is viewing the Guid as an arithmetic expression. How can I fix this so that it will add the single quote properly? I've been working on this for a while, and it's driving me nuts.
I'm adding the columns within the GridView using the following solution: http://www.telerik.com/help/winforms/gridviewmulticomboboxcolumn.html
The GridView that pops up is working properly, and I have the columns I want to display, however, the ValueMember is set to a property that is a Guid type. The entire column is bound to a Guid value, and the comboboxes are displaying a different value. So far so good.
The problem comes when I want to filter the grid by this Guid value. I get various ParserExceptions, and they differ from Guid to Guid, based on the actual Guid. One example is the following:
"Missing operator before c0aee operand."
This is happening on a Guid whose value is 986c0aee-4987-4384-b8e6-551b2fb7a41e.
I've pasted the stack trace below, and at it's root, it appears to be trying to set an expression that looks like this:
AssetID = 986c0aee-4987-4384-b8e6-551b2fb7a41e
Obviously, the parser is viewing the Guid as an arithmetic expression. How can I fix this so that it will add the single quote properly? I've been working on this for a while, and it's driving me nuts.
I'm adding the columns within the GridView using the following solution: http://www.telerik.com/help/winforms/gridviewmulticomboboxcolumn.html
1 Answer, 1 is accepted
0
Hello David,
Notice that setting the filter by the context menu of filtering row is not working for GUID values.
Regards,
Svett
the Telerik team
Presently, we do not support out of the box filtering by GUID values. Nevertheless, RadGridView allows you to extend and customize the filtering programmatically by using the Custom Filtering feature. You have to subscribe to the CustomFiltering event. In addition, you need to set the EnableFiltering and CustomDataOperation properties of the column as it shown in the following code snippet:
private void radGridView1_CustomFiltering(object sender, Telerik.WinControls.UI.GridViewCustomFilteringEventArgs e){ Guid id = new Guid(Convert.ToString(e.RowInfo.Cells["GUID"].Value)); e.Visible = id != Guid.Empty;}protected override void OnLoad(EventArgs e){ base.OnLoad(e); DataTable table = new DataTable("table"); table.Columns.Add("GUID", typeof(Guid)); table.Columns.Add("Name", typeof(string)); table.Rows.Add(Guid.NewGuid(), "Telerik"); table.Rows.Add(Guid.NewGuid(), "Microsoft"); this.radGridView1.EnableFiltering = true; this.radGridView1.DataSource = table; this.radGridView1.Columns["GUID"].CustomDataOperation = Telerik.WinControls.UI.CustomDataOperation.Filtering;}Notice that setting the filter by the context menu of filtering row is not working for GUID values.
Regards,
Svett
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items