we have a telerik radgrid in a usercontrol created programatically with default group by expression added programatically.
Issue we are facing is grid feature like paging, sorting, drag and drop on grouping panel doesnot work only on IE browser if default groupbyexpression added is for date field. Date field is stored in database as Datetime and we are retrieving as it is from database and formatting the column using radgrid's gridDatetimeColumn DataFormatString = "{0:MM/dd/yyyy}".
Below is the code snipped used
Dim objcolentity As New BoundColsEntity()
objcolentity = LstBoundColsEntity(LstColCount(dc.ColumnName))
If objcolentity.visiblity = True Then
Select Case objcolentity.ColumnFilterType
Case "DateSelction"
Dim datecolumn As New GridDateTimeColumn
datecolumn.DataField = dc.ColumnName
datecolumn.UniqueName = dc.ColumnName
datecolumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
datecolumn.FilterControlWidth = Unit.Pixel(120)
datecolumn.ItemStyle.Height = Unit.Pixel(40)
datecolumn.HeaderStyle.Width = Unit.Pixel(170)
datecolumn.Visible = True
datecolumn.SortExpression = dc.ColumnName
datecolumn.PickerType = GridDateTimeColumnPickerType.DatePicker
datecolumn.EnableTimeIndependentFiltering = True
datecolumn.DataFormatString = "{0:MM/dd/yyyy}"
datecolumn.FilterListOptions = GridFilterListOptions.VaryByDataType
datecolumn.Groupable = enableGrouping
RadGridList.MasterTableView.Columns.Add(datecolumn)
Case "DBvalues"
Dim ComboFilterColumn As New DBFilter(dc.ColumnName, RadGridList.DataSource)
ComboFilterColumn.DataField = dc.ColumnName
ComboFilterColumn.UniqueName = dc.ColumnName
ComboFilterColumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
ComboFilterColumn.Visible = objcolentity.visiblity
ComboFilterColumn.ItemStyle.Height = Unit.Pixel(40)
ComboFilterColumn.HeaderStyle.Width = Unit.Pixel(objcolentity.width)
ComboFilterColumn.Resizable = objcolentity.Resizable
ComboFilterColumn.Reorderable = objcolentity.Reorderable
ComboFilterColumn.AllowSorting = objcolentity.enableSorting
ComboFilterColumn.Groupable = objcolentity.enableGrouping
ComboFilterColumn.FilterListOptions = GridFilterListOptions.VaryByDataType
ComboFilterColumn.AllowFiltering = True
ComboFilterColumn.ShowFilterIcon = False
RadGridList.MasterTableView.Columns.Add(ComboFilterColumn)
Case Else
Dim boundcolumn As New GridBoundColumn()
boundcolumn.DataField = dc.ColumnName
boundcolumn.UniqueName = dc.ColumnName
boundcolumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
boundcolumn.Visible = objcolentity.visiblity
boundcolumn.ItemStyle.Height = Unit.Pixel(40)
boundcolumn.HeaderStyle.Width = Unit.Pixel(objcolentity.width)
boundcolumn.Resizable = objcolentity.Resizable
boundcolumn.Reorderable = objcolentity.Reorderable
boundcolumn.AllowSorting = objcolentity.enableSorting
boundcolumn.Groupable = objcolentity.enableGrouping
boundcolumn.FilterListOptions = GridFilterListOptions.VaryByDataType
boundcolumn.HtmlEncode = True
Select Case objcolentity.ColumnFilterType
Case "StringContains"
boundcolumn.AllowFiltering = True
boundcolumn.ShowFilterIcon = False
boundcolumn.FilterControlToolTip = "Hit enter to search"
boundcolumn.AutoPostBackOnFilter = True
Case "NoFilter"
boundcolumn.AllowFiltering = False
If Not String.IsNullOrEmpty(objcolentity.headerType) Then
boundcolumn.HeaderImageUrl = objcolentity.path
End If
Case Else
boundcolumn.ShowFilterIcon = True
End Select
RadGridList.MasterTableView.Columns.Add(boundcolumn)
End Select
If objcolentity.DefaultGrpByExp Then
Dim gridGrpByExp As New GridGroupByExpression()
Dim gridGroupByField As New GridGroupByField()
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = dc.ColumnName
gridGroupByField.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
gridGrpByExp.SelectFields.Add(gridGroupByField)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = dc.ColumnName
gridGrpByExp.GroupByFields.Add(gridGroupByField)
RadGridList.MasterTableView.GroupByExpressions.Add(gridGrpByExp)
End If
End If
Next
Issue we are facing is grid feature like paging, sorting, drag and drop on grouping panel doesnot work only on IE browser if default groupbyexpression added is for date field. Date field is stored in database as Datetime and we are retrieving as it is from database and formatting the column using radgrid's gridDatetimeColumn DataFormatString = "{0:MM/dd/yyyy}".
Below is the code snipped used
For Each dc As DataColumn In RadGridList.DataSource.ColumnsDim objcolentity As New BoundColsEntity()
objcolentity = LstBoundColsEntity(LstColCount(dc.ColumnName))
If objcolentity.visiblity = True Then
Select Case objcolentity.ColumnFilterType
Case "DateSelction"
Dim datecolumn As New GridDateTimeColumn
datecolumn.DataField = dc.ColumnName
datecolumn.UniqueName = dc.ColumnName
datecolumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
datecolumn.FilterControlWidth = Unit.Pixel(120)
datecolumn.ItemStyle.Height = Unit.Pixel(40)
datecolumn.HeaderStyle.Width = Unit.Pixel(170)
datecolumn.Visible = True
datecolumn.SortExpression = dc.ColumnName
datecolumn.PickerType = GridDateTimeColumnPickerType.DatePicker
datecolumn.EnableTimeIndependentFiltering = True
datecolumn.DataFormatString = "{0:MM/dd/yyyy}"
datecolumn.FilterListOptions = GridFilterListOptions.VaryByDataType
datecolumn.Groupable = enableGrouping
RadGridList.MasterTableView.Columns.Add(datecolumn)
Case "DBvalues"
Dim ComboFilterColumn As New DBFilter(dc.ColumnName, RadGridList.DataSource)
ComboFilterColumn.DataField = dc.ColumnName
ComboFilterColumn.UniqueName = dc.ColumnName
ComboFilterColumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
ComboFilterColumn.Visible = objcolentity.visiblity
ComboFilterColumn.ItemStyle.Height = Unit.Pixel(40)
ComboFilterColumn.HeaderStyle.Width = Unit.Pixel(objcolentity.width)
ComboFilterColumn.Resizable = objcolentity.Resizable
ComboFilterColumn.Reorderable = objcolentity.Reorderable
ComboFilterColumn.AllowSorting = objcolentity.enableSorting
ComboFilterColumn.Groupable = objcolentity.enableGrouping
ComboFilterColumn.FilterListOptions = GridFilterListOptions.VaryByDataType
ComboFilterColumn.AllowFiltering = True
ComboFilterColumn.ShowFilterIcon = False
RadGridList.MasterTableView.Columns.Add(ComboFilterColumn)
Case Else
Dim boundcolumn As New GridBoundColumn()
boundcolumn.DataField = dc.ColumnName
boundcolumn.UniqueName = dc.ColumnName
boundcolumn.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
boundcolumn.Visible = objcolentity.visiblity
boundcolumn.ItemStyle.Height = Unit.Pixel(40)
boundcolumn.HeaderStyle.Width = Unit.Pixel(objcolentity.width)
boundcolumn.Resizable = objcolentity.Resizable
boundcolumn.Reorderable = objcolentity.Reorderable
boundcolumn.AllowSorting = objcolentity.enableSorting
boundcolumn.Groupable = objcolentity.enableGrouping
boundcolumn.FilterListOptions = GridFilterListOptions.VaryByDataType
boundcolumn.HtmlEncode = True
Select Case objcolentity.ColumnFilterType
Case "StringContains"
boundcolumn.AllowFiltering = True
boundcolumn.ShowFilterIcon = False
boundcolumn.FilterControlToolTip = "Hit enter to search"
boundcolumn.AutoPostBackOnFilter = True
Case "NoFilter"
boundcolumn.AllowFiltering = False
If Not String.IsNullOrEmpty(objcolentity.headerType) Then
boundcolumn.HeaderImageUrl = objcolentity.path
End If
Case Else
boundcolumn.ShowFilterIcon = True
End Select
RadGridList.MasterTableView.Columns.Add(boundcolumn)
End Select
If objcolentity.DefaultGrpByExp Then
Dim gridGrpByExp As New GridGroupByExpression()
Dim gridGroupByField As New GridGroupByField()
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = dc.ColumnName
gridGroupByField.HeaderText = objlistCmnFncs.OrgtermReplace(objcolentity.columnDisplayName.ToString)
gridGrpByExp.SelectFields.Add(gridGroupByField)
gridGroupByField = New GridGroupByField
gridGroupByField.FieldName = dc.ColumnName
gridGrpByExp.GroupByFields.Add(gridGroupByField)
RadGridList.MasterTableView.GroupByExpressions.Add(gridGrpByExp)
End If
End If
Next
