Missing operand after 'a' operator error for master/detail

[Tuan Huynh]

I am getting the error "Missing operand after 'a' operator" when I have master/detail views of RadGrid for AJAX.Net. This error happens when user attempts to drill into detail table and value of the DataKeyNames of the parent table has a single quote '.  I found one thread that someone had shared similar error. 

http://www.telerik.com/community/forums/thread/b311D-ebecm.aspx

However, he had to resort to an alternative to use two grids instead of master/detail. I'd rather use master/detail. Can you help? Thanks.

Here is my snippet of my master/detail relation. City has single quote in value

<

DetailTables><telerik:GridTableView DataKeyNames="City" Name="ITContact"  GridLines="None" Width="100%" BorderStyle="None" GroupLoadMode="Client">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="City" MasterKeyField="City" />
</ParentTableRelation>


In debugging, I have no problem in retrieving the detail table of City with single quote in value. The statements of below in DetailTableDataBind event handler executes with no error.

switch (e.DetailTableView.Name) {

case "ITContact":
string City = dataItem.GetDataKeyValue("City").ToString();
DataSet dsResult = new WorkflowParticipant().GetITContactsByCity(City);
e.DetailTableView.DataSource = dsResult;
break;

}

Stack trace shows that the error happens at System.Data.ExpressionParser.Parse()
System.Data.ExpressionParser.Parse() +442
   System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +154
   System.Data.DataExpression..ctor(DataTable table, String expression) +35
   System.Data.DataView.set_RowFilter(String value) +192

[Rosen]

Hello,

It seems that you are using both ParentTableRelation and DetailTableDataBind event? If this is the case, please remove the ParentTableRelation and use only DetailTableDataBind event.

Please give it a try and see if this helps.

Sincerely yours,
Rosen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.