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

Having problem in creating grid programmatically

4 Answers 96 Views

General Discussions

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

Muhammad Farjad asked on 07 Apr 2010, 07:35 AM

(I am posting this thread here because I didn't get any reply in GRID setion of forum yet)

Hi,

I need to create hierarchical rad grid programatically using DataTable, but I'm having a problem in settng the data source for level 1 hierarchy. When I try to expand the child table, an exception is thrown as

"Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing operand before 'Is' operator."

Kindly help me out regarding this issue. I have attached my code and exception trace. Thanks

Regards
Muhammad Farjad

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

<body>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

</Scripts>
</telerik:RadScriptManager>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

</telerik:RadAjaxManager>

<div>

<telerik:RadGrid ID="RadGrid1" runat="server" ondetailtabledatabind="RadGrid1_DetailTableDataBind">

</telerik:RadGrid>

</div>

</form>

</body>

---------------------------------------------------- Code Behind File ----------------------------------------------------------------------------

using System;

---------------------------------------------------- Code Behind File ----------------------------------------------------------------------------

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Configuration;

using System.Web.Security;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using Telerik.Web.UI;

public partial class Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)

{

//Add grand father table

DataTable grandFatherTable = CreateDataTable("GrandFather");

AddDataToTable("usman", "Usman", "Mansur", grandFatherTable);

AddDataToTable("adnan", "Adnan", "Ahmad", grandFatherTable);

AddDataToTable("nabeel", "Nabeel", "Ahmed", grandFatherTable);

RadGrid1.DataSource = grandFatherTable;

RadGrid1.MasterTableView.DataKeyNames = new string[] { "username" };

RadGrid1.Width = Unit.Percentage(98);

RadGrid1.PageSize = 5;

RadGrid1.AllowPaging = true;

//RadGrid1.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric;

RadGrid1.AutoGenerateColumns = false;

RadGrid1.Skin = "Web20";

RadGrid1.MasterTableView.PageSize = 15;

RadGrid1.MasterTableView.Width = Unit.Percentage(100);

GridBoundColumn boundColumn;

boundColumn = new GridBoundColumn();

RadGrid1.MasterTableView.Columns.Add(boundColumn);

boundColumn.DataField = "username";

boundColumn.HeaderText = "User Name";

boundColumn = new GridBoundColumn();

RadGrid1.MasterTableView.Columns.Add(boundColumn);

boundColumn.DataField = "firstname";

boundColumn.HeaderText = "First Name";

boundColumn = new GridBoundColumn();

RadGrid1.MasterTableView.Columns.Add(boundColumn);

boundColumn.DataField = "lastname";

boundColumn.HeaderText = "Last Name";

//Add Father table

DataTable fatherTable = CreateDataTable("Father");

AddDataToTable("usman", "u1", "u2", fatherTable);

AddDataToTable("adnan", "a1", "a2", fatherTable);

AddDataToTable("nabeel", "n1", "n2", fatherTable);

GridTableView tableViewFather = new GridTableView(RadGrid1);

tableViewFather.Width = Unit.Percentage(100);

tableViewFather.DataSource = fatherTable;

tableViewFather.DataKeyNames = new string[] { "username" };

GridRelationFields relationFields = new GridRelationFields();

relationFields.MasterKeyField = "username";

relationFields.DetailKeyField = "username";

tableViewFather.ParentTableRelation.Add(relationFields);

RadGrid1.MasterTableView.DetailTables.Add(tableViewFather);

boundColumn = new GridBoundColumn();

tableViewFather.Columns.Add(boundColumn);

boundColumn.DataField = "username";

boundColumn.HeaderText = "User Name";

boundColumn = new GridBoundColumn();

tableViewFather.Columns.Add(boundColumn);

boundColumn.DataField = "firstname";

boundColumn.HeaderText = "First Name";

boundColumn = new GridBoundColumn();

tableViewFather.Columns.Add(boundColumn);

boundColumn.DataField = "lastname";

boundColumn.HeaderText ="Last Name";

}
}

private DataTable CreateDataTable(string tableName)

{

DataTable myDataTable = new DataTable(tableName);

DataColumn myDataColumn;

myDataColumn = new DataColumn();

myDataColumn.DataType = Type.GetType("System.String");

myDataColumn.ColumnName = "username";

myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();

myDataColumn.DataType = Type.GetType("System.String");

myDataColumn.ColumnName = "firstname";

myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();

myDataColumn.DataType = Type.GetType("System.String");

myDataColumn.ColumnName = "lastname";

myDataTable.Columns.Add(myDataColumn);

return myDataTable;

}

private void AddDataToTable(string username, string firstname, string lastname, DataTable myTable)

{

DataRow row;

row = myTable.NewRow();

//row["id"] = Guid.NewGuid().ToString();

row["username"] = username;

row["firstname"] = firstname;

row["lastname"] = lastname;

myTable.Rows.Add(row);

}

protected void RadGrid1_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e)

{

DataTable fatherTable = CreateDataTable("Father");

AddDataToTable("usman", "u1", "u2", fatherTable);

AddDataToTable("adnan", "a1", "a2", fatherTable);

AddDataToTable("nabeel", "n1", "n2", fatherTable);

e.DetailTableView.DataSource = fatherTable;

}

---------------------------------------------------------- exception ------------------------------------------------------------------------

Server Error in '/RadHierarchicalGrid' Application.
--------------------------------------------------------------------------------

Syntax error: Missing operand before 'Is' operator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing operand before 'Is' operator.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SyntaxErrorException: Syntax error: Missing operand before 'Is' operator.]
   System.Data.ExpressionParser.Parse() +4824040
   System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +121
   System.Data.DataView.set_RowFilter(String value) +153
   System.Data.LinqDataView.set_RowFilter(String value) +53
   Telerik.Web.UI.GridEnumerableFromDataView.PerformTransformation() +375
   Telerik.Web.UI.GridEnumerableFromDataView.TransformEnumerable() +21
   Telerik.Web.UI.GridTableView.GetEnumerator(Boolean useDataSource, GridEnumerableBase resolvedDataSource, ArrayList dataKeysArray) +105
   Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource) +432
   Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +500
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +57
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +114
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +31
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
   Telerik.Web.UI.GridTableView.PerformSelect() +4
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   Telerik.Web.UI.GridTableView.DataBind() +224
   Telerik.Web.UI.GridDataItem.OnExpand() +272
   Telerik.Web.UI.GridItem.set_Expanded(Boolean value) +109
   Telerik.Web.UI.GridExpandCommandEventArgs.ExecuteCommand(Object source) +34
   Telerik.Web.UI.RadGrid.OnBubbleEvent(Object source, EventArgs e) +134
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +115
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927

4 Answers, 1 is accepted

Accepted

answered on 12 Jun 2013, 10:31 AM

Hello Pavlina,
I updated my telerik dll from 2012.3.1016.35 to 2013.1.417.40
After convert latest version I got

Syntax error: Missing operand before '=' operator.

error. Lets submit my code of aspx and aspx.cs page

<telerik:RadGrid ID="rdgPermissionList" runat="server" AllowFilteringByColumn="false"

AllowPaging="false" BackColor="White" AllowSorting="True" GridLines="Both" AutoGenerateColumns="false"

Skin="MyCustomSkin" EnableEmbeddedSkins="false" ShowGroupPanel="false" AllowMultiRowSelection="true"

OnColumnCreated="rdgPermissionList_ColumnCreated" OnNeedDataSource="rdgPermissionList_NeedDataSource"

OnItemDataBound="rdgPermissionList_ItemDataBound" OnItemCreated="rdgPermissionList_ItemCreated"

OnItemCommand="rdgPermissionList_ItemCommand" Width="99.5%" EnableLinqExpressions="false" >

<PagerStyle Mode="NextPrevAndNumeric" PrevPageToolTip="Previous" NextPagesToolTip="Next"

AlwaysVisible="true" />

<MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="intFieldPermissionID,intModuleID,intModuleParentID,strRefLabel"

ItemStyle-HorizontalAlign="Left" AlternatingItemStyle-HorizontalAlign="Left"

HierarchyDefaultExpanded="false" HierarchyLoadMode="Client" AllowSorting="true"

EnableNoRecordsTemplate="false" AllowPaging="true" Name="Master" Width="100%">

<FilterItemStyle HorizontalAlign="Left" />

<ItemStyle HorizontalAlign="Left"></ItemStyle>

<AlternatingItemStyle HorizontalAlign="Left"></AlternatingItemStyle>

<SelfHierarchySettings ParentKeyName="" KeyName="intModuleID" />

<Columns>

<telerik:GridBoundColumn DataField="strRefLabel" HeaderText="Modules" SortExpression="strRefLabel"

UniqueName="strRefLabel" HeaderStyle-Width="60px" ItemStyle-HorizontalAlign="Left">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Enable" HeaderStyle-Width="40px" UniqueName="Enable">

<ItemTemplate>

<asp:CheckBox ID="chkEnable" runat="server" Checked='<%# Eval("ysnEnable").ToString().ToLower()=="1"?true:false %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<RowIndicatorColumn Visible="True">

</RowIndicatorColumn>

<CommandItemTemplate>

<table width="100%">

<tr>

<td id="tdSave" runat="server" style="width: 4%" align="left" valign="top">

<asp:ImageButton ImageUrl="~/images/tick.gif" ID="btnSave" runat="server" CommandName="Update">

</asp:ImageButton>

</td>

<td style="width: 96%" align="left">

<asp:ImageButton ImageUrl="~/images/Cancel.gif" ID="btnCancel" CausesValidation="False"

runat="server" CommandName="Cancel"></asp:ImageButton>

</td>

</tr>

</table>

</CommandItemTemplate>

</MasterTableView>

<HeaderStyle Width="50px" Height="25px" />

<ClientSettings AllowColumnsReorder="True" AllowKeyboardNavigation="true" AllowAutoScrollOnDragDrop="true" EnableRowHoverStyle="true"

ReorderColumnsOnClient="true" AllowDragToGroup="True" AllowExpandCollapse="true">

<ClientMessages DragToGroupOrReorder="Select All" />

<Resizing AllowColumnResize="true" EnableRealTimeResize="true" />

</ClientSettings>

<FilterMenu EnableEmbeddedSkins="false">

</FilterMenu>

</telerik:RadGrid>

And .cs file code is

using System;

using System.Linq;

using System.Data;

using System.Reflection;

using System.Web.UI;

using System.Web.UI.WebControls;

using A1_A1Tracker_CNetWeb.Components.DataAccess;

using A1_A1Tracker_CNetWeb.Components.Security;

using Telerik.Web.UI;

namespace A1_A1Tracker_CNetWeb.Modules.System

{

public partial class FieldPermissionDetails : A1_A1Tracker_CNetWeb.Components.Web.UI.Page

{

UserPermission UserPerms;

int groupId = 0;

protected void Page_Init(object sender, EventArgs e)

{

UserPerms = new UserPermission();

}

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

if (!(UserPerms.CheckPerms(A1_A1Tracker_CNetWeb.Components.Security.Module.Security, PermissionLevel.ReadOnly)))

Response.Redirect("~/Modules/UserAuthentication/ErrorPage.aspx?NoPerms=true");

}

groupId = Convert.ToInt32(Request.QueryString["groupId"]);

if (Assembly.GetAssembly(typeof(ScriptManager)).FullName.IndexOf("4.0") != -1)

{

rdgPermissionList.MasterTableView.FilterExpression = @"it[""intModuleParentID""] = Convert.DBNull";

}

else

{

rdgPermissionList.MasterTableView.FilterExpression = "intModuleParentID IS NULL";

}

RadDockPermissionDetail.Title = "<a href='Permission.aspx' style='color:black; cursor:hand; text-decoration:none;'> Permission </a> >> " + "Field Permission Details for " + Convert.ToString(Request.QueryString["groupname"]);

}

protected void rdgPermissionList_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

DataAccessHelper objDataAccess = new DataAccessHelper();

DataTable dtPermissionList = objDataAccess.GetFieldPermission(groupId);

objDataAccess = null;

if (dtPermissionList.Rows.Count != 0)

{

//if (rdgPermissionList.MasterTableView.FilterExpression.Length > 0)

//{

//    var newTable = dtPermissionList.AsEnumerable().AsQueryable().Where(@"it[""intModuleParentID""] = Convert.DBNull").CopyToDataTable();

//}

//if (rdgPermissionList.MasterTableView.FilterExpression.Length > 0)

//{

//    var tempTable = dtPermissionList.AsEnumerable().AsQueryable().Where(rdgPermissionList.MasterTableView.FilterExpression);

// if (tempTable.Count() > 0)

// {

// dsCopy.Load(tempTable.CopyToDataTable().CreateDataReader(),

// LoadOption.OverwriteChanges, strTables);

// }

//}

rdgPermissionList.DataSource = dtPermissionList.DefaultView;

}

protected void rdgPermissionList_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.UpdateCommandName)

{

string fieldsXML = "<root>";

foreach (GridDataItem item in rdgPermissionList.Items)

{

string test = item.OwnerTableView.Name;

String moduleId = item.GetDataKeyValue("intModuleID").ToString();

String permissionId = item.GetDataKeyValue("intFieldPermissionID").ToString();

CheckBox enable = item["Enable"].FindControl("chkEnable") as CheckBox;

fieldsXML += "<FIELDS>";

fieldsXML += "<ModuleId>" + moduleId + "</ModuleId>" + "\n";

fieldsXML += "<FieldPermissionID>" + permissionId + "</FieldPermissionID>" + "\n";

fieldsXML += "<Enable>" + enable.Checked + "</Enable>" + "\n";

fieldsXML += "</FIELDS>";

}

fieldsXML += "</root>";

DataAccessHelper objDataAccess = new DataAccessHelper();

objDataAccess.SaveFieldPermission(groupId, fieldsXML);

objDataAccess = null;

this.lblMsg.Text = "Field Permission updated successfully.";

}

else if (e.CommandName == RadGrid.CancelCommandName)

{

Response.Redirect("Permission.aspx");

}

protected void rdgPermissionList_ColumnCreated(object sender, GridColumnCreatedEventArgs e)

{

GridBoundColumn boundColumn = e.Column as GridBoundColumn;

switch (e.Column.UniqueName)

{

case "strRefLabel":

break;

case "ysnEnable":

break;

default:

e.Column.Visible = false;

break;

}

protected void rdgPermissionList_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item is GridCommandItem)

{

//Apply Permission for Add and Delete

GridCommandItem commandItem = e.Item as GridCommandItem;

if (!(UserPerms.CheckPerms(A1_A1Tracker_CNetWeb.Components.Security.Module.Security, PermissionLevel.Add, PermissionLevel.Edit, PermissionLevel.Delete)))

(commandItem.FindControl("btnSave") as ImageButton).Parent.Visible = false;

}

CreateExpandCollapseButton(e.Item, "strRefLabel");

if ((e.Item is GridHeaderItem || e.Item is GridCommandItem || e.Item is GridPagerItem) && e.Item.OwnerTableView != rdgPermissionList.MasterTableView)

{

e.Item.Style["display"] = "none";

}

if (e.Item is GridNestedViewItem)

{

e.Item.Cells[0].Visible = false;

}

protected void Page_PreRender(object sender, EventArgs e)

{

HideExpandColumnRecursive(rdgPermissionList.MasterTableView);

}

public void HideExpandColumnRecursive(GridTableView tableView)

{

GridItem[] nestedViewItems = tableView.GetItems(GridItemType.NestedView);

foreach (GridNestedViewItem nestedViewItem in nestedViewItems)

{

foreach (GridTableView nestedView in nestedViewItem.NestedTableViews)

{

nestedView.Style["border"] = "0";

Button MyExpandCollapseButton = (Button)nestedView.ParentItem.FindControl("MyExpandCollapseButton");

if (nestedView.Items.Count == 0)

{

if (MyExpandCollapseButton != null)

{

MyExpandCollapseButton.Style["visibility"] = "hidden";

}

nestedViewItem.Visible = false;

}

else

{

if (MyExpandCollapseButton != null)

{

MyExpandCollapseButton.Style.Remove("visibility");

}

if (nestedView.HasDetailTables)

{

HideExpandColumnRecursive(nestedView);

}

protected void rdgPermissionList_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

GridDataItem item = (GridDataItem)e.Item;

string parentId = item.GetDataKeyValue("intModuleParentID").ToString();

if (string.IsNullOrEmpty(parentId))

{

if (item.OwnerTableView.HasDetailTables)

{

CheckBox chkReadOnly = (CheckBox)item["Enable"].Controls[1];

if (chkReadOnly != null)

chkReadOnly.Attributes.Add("onclick", "MasterCheckBoxClick(this,'" + item.ItemIndex + "','chkEnable');");

}

CreateExpandCollapseButton(e.Item, "strRefLabel");

}

public void CreateExpandCollapseButton(GridItem item, string columnUniqueName)

{

if (item is GridDataItem)

{

if (item.FindControl("MyExpandCollapseButton") == null)

{

Button button = new Button();

button.Click += new EventHandler(button_Click);

button.CommandName = "ExpandCollapse";

button.CssClass = (item.Expanded) ? "rgCollapse" : "rgExpand";

button.ID = "MyExpandCollapseButton";

if (item.OwnerTableView.HierarchyLoadMode == GridChildLoadMode.Client)

{

string script = String.Format(@"$find(""{0}"")._toggleExpand(this, event); return false;", item.Parent.Parent.ClientID);

button.OnClientClick = script;

}

int level = item.ItemIndexHierarchical.Split(':').Length;

if (level > 1)

{

button.Style["margin-left"] = level + 9 + "px";

}

TableCell cell = ((GridDataItem)item)[columnUniqueName];

cell.Controls.Add(button);

cell.Controls.Add(new LiteralControl(" "));

cell.Controls.Add(new LiteralControl(((GridDataItem)item).GetDataKeyValue(columnUniqueName).ToString()));

}

void button_Click(object sender, EventArgs e)

{

((Button)sender).CssClass = (((Button)sender).CssClass == "rgExpand") ? "rgCollapse" : "rgExpand";

}

Now please help me as I spend lots of time to find solution of this

answered on 16 Jun 2013, 10:12 PM

Hi,

It is really strange that you received this error after you updated the Telerik dll. The provided code looks correct, also EnableLinqExpressions property of grid is set to false as it should be. Therefore to be able to assist you further, I will ask you to open a support ticket and send us a sample project where the issue can be observed. We will test it locally and will advice you further. You can also download the latest version of RadControls - Q2 2013 and see if you still receive the error.

Regards,
Pavlina
Telerik

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.