Dots in column name

[Frederic Latour]

Hi the Telerik Team,

If I have a column name which contains a dot (e.g. Suppliers.Title), no data is displayed for this column in the RadGridView.

For your information:

• I use the version 2009.9.729
• I bind a DataTable to the RadGridView
• My DataTable is created from an SQL Query (which explains the Suppliers.Title)
• I have ensured that the column contains data
• If I rename my column to "Suppliers_Title", it returns the data (e.g. in my sql query : SELECT Suppliers.Title AS Suppliers_Title, ...)
• If I execute this statement ((DataRowView)((BindingSource)resultsRadGridView.DataSource)[0])["Suppliers.Title"], the data is returned too

Thank you for your help,

Regards,

[Julian Benkov]

Hello Frederic Latour,

RadGridView supports "sub properties data mapping" when there is a data source. For this reason, it tries to resolve your "Suppliers.Title" to sub object contained in your DataTable. For this scenario when you load flat data to a DataTable object you can use syntax like: 'Suppliers_Title' to avoid this error. More detailed information to sub properties binding you can find in our Examples -> GridView -> Populating with data -> Sub Objects section.

Greetings,
Julian Benkov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.