Filtering : invalid column name

[Evelyne Schreiner]

Using a radgrid with AllowFilteringByColumn="true" I get this error:
“Invalid Column Name …”.

The SQL request used for data binding is :
SELECT myName AS [Another name] FROM TEST

So, I think the problem is the alias, but I don’t know how to solve it.

Could anyone help me, please?

[Tsvetoslav]

Hi Evelyne,

There should be no problem with the aliases, just make sure that the alias does not contain spaces and that the alias is assigned to the DataField property of the column bound to this field.

Hope it helps.

Greetings,
Tsvetoslav
the Telerik team

[Evelyne Schreiner]

Thank you Tsvetoslav.

Does that mean that I'm forced to set the columns of the grid ?

So far, I didn't do it and the number of columns (which change according to various conditions) is set through the select (Select column1, column2...).

[Tsvetoslav]

Hi Evelylne,

No, you don't need that - could you paste your whole mark-up and code-behind using the CODE FORMATTER tool of the ticket editor.

All the best,
Tsvetoslav
the Telerik team

[Evelyne Schreiner]

Thank you Tsvetoslav, I've finally found how to solve my problem.