This is a migrated thread and some comments may be shown as answers.

The expression contains invalid date constant '# = 1438680))'.

1 Answer 187 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 05 Dec 2008, 10:18 PM
Greetings,

I'm using the RadGrid in a Sharepoint web part. I'm building the grid programatically. I'm trying a hieracal grid and have run into a problem. 

I get the master table displayed ok, however when I try to expand the a master record I get the SyntaxErrorException:The expression contains invalid date constant '# = 1438680))'.  (The number is the order key)

The primary key for both result sets have a # in the field name. Is that going to be an issue?

Here is how the grid id built:

 myRadGrid = New RadGrid 
            myRadGrid.ID = "RADMan" 
            myRadGrid.MasterTableView.DataKeyNames = New String() {"WHORD#""WHLSUF"
            myRadGrid.Skin = "Office2007" 
            myRadGrid.Width = Unit.Percentage(100) 
 
            myRadGrid.AllowPaging = True 
            myRadGrid.AutoGenerateColumns = False 
            'Master table - Customers (I in hierarchy level) 
            myRadGrid.MasterTableView.PageSize = 15 
            'Add columnsn 
            Dim boundColumn As GridBoundColumn 
            boundColumn = New GridBoundColumn() 
            boundColumn.DataField = "WHORD#" 
            boundColumn.HeaderText = "Order#" 
            myRadGrid.MasterTableView.Columns.Add(boundColumn) 
            boundColumn = New GridBoundColumn() 
            boundColumn.DataField = "WHLSUF" 
            boundColumn.HeaderText = "Suffix" 
            myRadGrid.MasterTableView.Columns.Add(boundColumn) 
            boundColumn = New GridBoundColumn() 
            boundColumn.DataField = "WHSPO#" 
            boundColumn.HeaderText = "PO #" 
            myRadGrid.MasterTableView.Columns.Add(boundColumn) 
            boundColumn = New GridBoundColumn() 
            boundColumn.DataField = "WHOTYP" 
            boundColumn.HeaderText = "Type" 
            myRadGrid.MasterTableView.Columns.Add(boundColumn) 
            'chr 
            'Detail table - Orders (II in hierarchy level) 
            ' 
            Dim tableViewOrders As New GridTableView(myRadGrid) 
            tableViewOrders.Name = "OrderDetails" 
            tableViewOrders.DataKeyNames = New String() {"W6ORD#"
            Dim relationFields As GridRelationFields = New GridRelationFields() 
            relationFields.MasterKeyField = "WHORD#" 
            relationFields.DetailKeyField = "W6ORD#" 
            tableViewOrders.ParentTableRelation.Add(relationFields) 
            myRadGrid.MasterTableView.DetailTables.Add(tableViewOrders) 
            ''Add columns 
            boundColumn = New GridBoundColumn 
            boundColumn.DataField = "W6ORD#" 
            boundColumn.HeaderText = "W6ORD#" 
            tableViewOrders.Columns.Add(boundColumn) 
            boundColumn = New GridBoundColumn 
            boundColumn.DataField = "WDPNS" 
            boundColumn.HeaderText = "WDPNS" 
            tableViewOrders.Columns.Add(boundColumn) 
            boundColumn = New GridBoundColumn 
            boundColumn.DataField = "WMDESC" 
            boundColumn.HeaderText = "WMDESC" 
            tableViewOrders.Columns.Add(boundColumn) 
            boundColumn = New GridBoundColumn 
            boundColumn.DataField = "W6SUFX" 
            boundColumn.HeaderText = "W6SUFX" 
            tableViewOrders.Columns.Add(boundColumn) 

Here are the event handlers:

        Protected Sub MyRadGrid_NeedDataSource(ByVal [source] As ObjectByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles myRadGrid.NeedDataSource 
            If Not e.IsFromDetailTable Then 
                myRadGrid.DataSource = GetOrderHeader() 'GetHeaderDetails("1446551", "00") 
            End If 
        End Sub 
 
    Private Sub myRadGrid_DetailTableDataBind(ByVal source As ObjectByVal e As GridDetailTableDataBindEventArgs) Handles myRadGrid.DetailTableDataBind 
            Dim dataItem As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem) 
            Select e.DetailTableView.Name 
                Case "OrderDetails" 
                    Dim OrderID As String = dataItem.GetDataKeyValue("WHORD#").ToString 
                    Dim Suffix As String = dataItem.GetDataKeyValue("WHLSUF").ToString 
                    e.DetailTableView.DataSource = GetHeaderDetails(OrderID, Suffix) 
                Case "ItemDetails" 
            End Select 
        End Sub 
 

And then here is the spewer from Sharepoint:

[SyntaxErrorException: The expression contains invalid date constant '# = 1438680))'.] 
   System.Data.ExpressionParser.ScanDate() +2881845 
   System.Data.ExpressionParser.Scan() +212 
   System.Data.ExpressionParser.Parse() +88 
   System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +154 
   System.Data.DataView.set_RowFilter(String value) +188 
   System.Data.LinqDataView.set_RowFilter(String value) +63 
   Telerik.Web.UI.GridEnumerableFromDataView.PerformTransformation() +3816 
   Telerik.Web.UI.GridEnumerableFromDataView.TransformEnumerable() +24 
   Telerik.Web.UI.GridTableView.GetEnumerator(Boolean useDataSource, GridEnumerableBase resolvedDataSource, ArrayList dataKeysArray) +164 
   Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource) +229 
   Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +672 
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +72 
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +147 
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +261 
   Telerik.Web.UI.GridTableView.PerformSelect() +9 
   Telerik.Web.UI.GridTableView.DataBind() +363 
   Telerik.Web.UI.GridDataItem.OnExpand() +462 
   Telerik.Web.UI.RadGrid.OnBubbleEvent(Object source, EventArgs e) +185 
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +70 
   Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +142 
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +70 
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29 
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981 
 
 

Anyone have any idea what could be causing this exception? I'm so darn close to getting this to work.

Thanks for any help.

-Matt

1 Answer, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 08 Dec 2008, 10:37 AM
Hi Matthew,

Unfortunately the grid will not able to handle properly fields with such names. Possible workaround is to prepare new calculated field without "#" for your data source.

Best wishes,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
Matthew
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Share this question
or