[Solved] Problem using GroupByExpressions

[Andrew]

Hi,

My Datasource (datatable) has columns with spaces in them. Can you please show me how to group by a field when they have spaces in them. The following below does not work for me. Please advise.

Dim expression1 As New GridGroupByExpression

 

Dim field1 As New GridGroupByField

 

 

field1 = New GridGroupByField

 

 

field1.FieldName = "Filing Country"

 

 

field1.FieldAlias = "[My Filing Country]"
expression1.SelectFields.Add(field1)

 

 

.MasterTableView.GroupByExpressions.Add(expression1)

Thanks!

 

[Princy]

Hello Andrew,

RadGrid does not support empty spaces, although the DB is able to store these values when wrapped in square brackets. Instead you can replace the empty space using an underscore '_' character, in the datatable directly or in the select command. 

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/Nwind.mdb"
SelectCommand="SELECT [Category ID] AS Category_ID, [CategoryName], [Description] FROM [Categories]">
</asp:AccessDataSource>

<asp:SqlDataSource ID="SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [Category ID] AS Category_ID, [CategoryName], [Description] FROM [Categories]"
runat="server">
</asp:SqlDataSource>

Thanks
Princy.