AllowFilteringByColumn="true"on the MasterTableView of the 2nd grid, I get the following exception:
WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified. 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.InvalidOperationException: WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified. 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: [InvalidOperationException: WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified.] System.Web.UI.WebControls.EntityDataSource.ValidateUpdatableConditions() +93743 System.Web.UI.WebControls.EntityDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +166 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +143 Telerik.Web.UI.GridTableView.PerformSelect() +38 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74 Telerik.Web.UI.GridTableView.DataBind() +363 Telerik.Web.UI.RadGrid.DataBind() +173 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +75 System.Web.UI.Control.EnsureChildControls() +102 System.Web.UI.Control.PreRenderRecursiveInternal() +42 System.Web.UI.Control.PreRenderRecursiveInternal() +175 System.Web.UI.Control.PreRenderRecursiveInternal() +175 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496 function getData() { var proxy = new window.LiveIdService.ILiveIdService(); proxy.set_enableJsonp(true); proxy.GetUserList(null, updateGrid);}function updateGrid(result) { var tableView = window.$find("<%= RadGrid2.ClientID %>").get_masterTableView(); tableView.set_dataSource(data.UserList); tableView.dataBind();}<telerik:RadGrid ID="RadGrid2" runat="server" GridLines="None" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" Skin="LiveID" EnableEmbeddedSkins="False" ><%-- OnItemCommand="gridUsers_ItemCommand" OnDataBound="gridUsers_DataBound"--%> <PagerStyle Mode="NextPrevAndNumeric" FirstPageToolTip="<%$ Resources: NextPreviousPagerField.FirstPageText %>" PageSizeLabelText="<%$ Resources: lblPageSize %>" LastPageTooltip="<%$ Resources:NextPreviousPagerField.LastPageText %>" PagerTextFormat="<%$ Resources: lblPagerTextFormat %>" /> <ClientSettings EnableRowHoverStyle="true" > <ClientEvents OnCommand="function(){}" OnGridCreated="FillWithData" /> </ClientSettings> <MasterTableView DataKeyNames="Id" ShowHeadersWhenNoRecords="True" EnableNoRecordsTemplate="true" PageSize="10" CommandItemDisplay="Bottom"> <CommandItemSettings AddNewRecordText="<%$ Resources: InsertButtonResource1.Text %>" ShowRefreshButton="false" /> <Columns> <telerik:GridHyperLinkColumn DataTextField="FirstName" DataNavigateUrlFields="Id" UniqueName="FirstName" HeaderText="<%$ Resources: lblFirstName.Text %>" DataNavigateUrlFormatString="~/Pages/Users/UserFile.aspx?id={0}" /> <telerik:GridHyperLinkColumn DataTextField="FirstName" DataNavigateUrlFields="Id" UniqueName="LastName" HeaderText="<%$ Resources: lblLastName.Text %>" DataNavigateUrlFormatString="~/Pages/Users/UserFile.aspx?id={0}" /> <telerik:GridBoundColumn DataField="OrganisationNames" HeaderText="<%$ Resources: lblAccounts.Text%>" DataType="System.String" /> <telerik:GridTemplateColumn DataField="OrganisationTypes" UniqueName="AccountType" HeaderStyle-Width="170" ItemStyle-VerticalAlign="Top"> <HeaderTemplate> <asp:LinkButton ID="lblAccountTypeHeader" runat="server" Text="<%$ Resources: lblAccountType.Text%>" CssClass="filter-text" CommandName="Sort" CommandArgument="AccountType" Enabled="false"></asp:LinkButton> <asp:LinkButton ID="lnkFilterAccountType" runat="server" CausesValidation="false" OnClientClick="openAccountTypeFilter(); return false;" class="action rounded filter"> <asp:Image ID="imgFilterAccountType" runat="server" ImageUrl="~/Resources/Images/funnel.png" /> </asp:LinkButton> </HeaderTemplate> <ItemTemplate><asp:Label ID="OrganisationTypes" runat="server" /></ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Actions" HeaderText="" ItemStyle-VerticalAlign="Top" HeaderStyle-Width="30"> <ItemTemplate> <asp:LinkButton ID="lnkDeleteAccount" runat="server" CommandName="Delete" CausesValidation="false" OnClientClick="openConfirmationDialogUserList(this); return false;" CommandArgument='<%# Eval("ID") %>'> <asp:Image ID="imgDeleteAccount" runat="server" ImageUrl="~/Resources/Images/delete.png" /> </asp:LinkButton> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <NoRecordsTemplate><asp:Literal ID="txtNoRecords" runat="server" Text="<%$ Resources: NoUsersLink %>"></asp:Literal></NoRecordsTemplate> <CommandItemTemplate> </CommandItemTemplate> </MasterTableView> <HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu></telerik:RadGrid><telerik:RadMenu runat="server" ID="RadMenu1" Style="z-index: 3" EnableRoundedCorners="true"
EnableShadows="true" EnableTextHTMLEncoding="true" ></telerik:RadMenu>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
FillRadMenu();
}
}
protected void FillRadMenu()
{
RadMenu1.DataSource = CreateTestTable();
RadMenu1.DataFieldID = "ID";
RadMenu1.DataFieldParentID = "ParentID";
RadMenu1.DataTextField = "Text";
RadMenu1.DataValueField = "ID";
RadMenu1.DataNavigateUrlField = "URL";
RadMenu1.DataBind();
}
private DataTable CreateTestTable()
{
DataTable table = new DataTable();
table.Columns.Add("ID");
table.Columns.Add("ParentID");
table.Columns.Add("Text");
table.Columns.Add("URL");
table.Columns.Add("Tooltip");
table.Rows.Add(new string[] { "1", null, "root 1", "root1.aspx", "root 1 tooltip" });
table.Rows.Add(new string[] { "2", null, "root 2", "root2.aspx", "root 1 tooltip" });
table.Rows.Add(new string[] { "3", "1", "child 1.1", "child11.aspx", "child 1.1 tooltip" });
table.Rows.Add(new string[] { "4", "1", "child 1.2", "child12.aspx", "child 1.2 tooltip" });
table.Rows.Add(new string[] { "5", "1", "child 1.3", "child13.aspx", "child 1.3 tooltip" });
table.Rows.Add(new string[] { "6", "5", "child 1.3.1", "child131.aspx", "child 1.3.1 tooltip" });
table.Rows.Add(new string[] { "7", "5", "child 1.3.2", "child132.aspx", "child 1.3.2 tooltip" });
table.Rows.Add(new string[] { "8", "5", "child 1.3.3", "child133.aspx", "child 1.3.3 tooltip" });
return table;
}
<EditFormSettings EditFormType="Template"> <FormTemplate> <div class="form"> <telerik:RadComboBox ID="rcbMaster" HighlightTemplatedItems="true" AutoPostBack="True" Filter="Contains" EmptyMessage="Search for Tariff Master..." OnSelectedIndexChanged="rcbMaster_SelectedIndexChanged" runat="server"> </telerik:RadComboBox> <asp:TextBox ID="txtCPICur" Enabled="false" CssClass="text_box" runat="server"></asp:TextBox> </div> </FormTemplate>
</EditFormSettings>Team
I am using rad combobox in my application for searching.
Whenever user type something in combobox it shows me related data.
I have used OnItemsRequested event for this.
I am having requirement that result drop down won’t show up until I type 3 charactors in combobox
I am using OnClientItemsRequesting event as follow to suppressed OnItemsRequested event.
function onItemsRequesting(sender, eventArgs) {
if (eventArgs.get_text().length < 3) {
sender.hideDropDown();
eventArgs.set_cancel(true);
}
else {
sender._loadingMessage = "Searching for " + eventArgs.get_text() + "...";
}
}
I am using telerik V2011.3.1115.40
Initially combo doesn’t contain any items. It is working fine first time but whenever I remove the characters & number of characters become to 2 & press another letter even then it shows me previous result for few seconds & then shows proper result. Is there any reason for this?
Can you please let me know how to remove all the items of the radcombobox in OnClientItemsRequesting event?
It might resolve the problem.
If you have any other resolution for this please let me know.