RadGrid with Filtering not working! in UI for ASP.NET AJAX

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

RadGrid with Filtering not working!

27 Answers 338 Views

Grid

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

Sanjay asked on 22 Oct 2010, 10:22 AM

Hi,

I've got the following code:

default.aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="default.aspx.cs"

Inherits="default" EnableSessionState="False" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Basic Filtering</title>

</head>

<body>

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

</telerik:RadScriptManager>

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

<telerik:AjaxSetting AjaxControlID="RadGrid1">

<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Transparency="30"

BackColor="#dff3ff">

<tr>

<asp:Image ID="Image1" runat="server" ImageUrl="~/Images/AjaxLoader-0066cc-W32ByH32.gif"

Width="32" Height="32" Style="border: 0px;" />

</td>

</tr>

</table>

</telerik:RadAjaxLoadingPanel>

<telerik:RadCodeBlock runat="server" ID="radCodeBlock">

function showFilterItem() {

$find('<%=RadGrid1.ClientID %>').get_masterTableView().showFilterItem();

}

function hideFilterItem() {

$find('<%=RadGrid1.ClientID %>').get_masterTableView().hideFilterItem();

}

</script>

</telerik:RadCodeBlock>

<p>

Show filtering item

<input id="Radio1" type="radio" runat="server" name="showHideGroup" checked="true"

onclick="showFilterItem()" /><label for="Radio1">Yes</label>

<input id="Radio2" type="radio" runat="server" name="showHideGroup" onclick="hideFilterItem()" /><label

for="Radio2">No</label>

</p>

<telerik:RadGrid AutoGenerateColumns="false" ID="RadGrid1" DataSourceID="SqlDataSource1"

Width="780px" AllowFilteringByColumn="True" AllowSorting="True" PageSize="15"

ShowFooter="True" AllowPaging="True" runat="server" GridLines="None" EnableLinqExpressions="false">

<MasterTableView AutoGenerateColumns="false" EditMode="InPlace" AllowFilteringByColumn="True"

ShowFooter="True" TableLayout="Auto">

<telerik:GridNumericColumn DataField="Order Id" HeaderText="Order Id" SortExpression="Order Id"

UniqueName="Order Id" FilterControlWidth="40px" AutoPostBackOnFilter="false"

CurrentFilterFunction="equalto" ShowFilterIcon="false" />

<telerik:GridBoundColumn FilterControlWidth="150px" DataField="Ship Name" HeaderText="Ship Name"

SortExpression="Ship Name" UniqueName="Ship Name" AutoPostBackOnFilter="true"

CurrentFilterFunction="Contains" ShowFilterIcon="false" />

<telerik:GridDateTimeColumn FilterControlWidth="70px" DataField="Order Date" HeaderText="Order Date"

SortExpression="Order Date" UniqueName="Order Date" PickerType="None" DataFormatString="{0:d}" />

<telerik:GridDateTimeColumn FilterControlWidth="150px" DataField="Shipped Date" HeaderText="Shipped Date"

SortExpression="Shipped Date" UniqueName="Shipped Date" PickerType="DatePicker"

DataFormatString="{0:D}">

</telerik:GridDateTimeColumn>

<telerik:GridMaskedColumn FilterControlWidth="100px" DataField="Ship ZIP/Postal Code"

HeaderText="Ship ZIP/Postal Code" SortExpression="Ship ZIP/Postal Code" UniqueName="Ship ZIP/Postal Code"

Mask="#####">

</telerik:GridMaskedColumn>

<telerik:GridNumericColumn HeaderStyle-Width="90px" FilterControlWidth="50px" DataField="Shipping Fee"

DataType="System.Decimal" HeaderText="Shipping Fee" SortExpression="Shipping Fee"

UniqueName="Shipping Fee" Aggregate="Sum">

</telerik:GridNumericColumn>

</Columns>

</MasterTableView>

</ClientSettings>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:MicrosoftAccess_v2007_Northwind %>"

ProviderName="System.Data.OleDb" SelectCommand="SELECT * FROM Orders" runat="server">

</asp:SqlDataSource>

</form>

</body>

</html>

There's nothing in the code-behind file defaualt.aspx.cs. Problem I'm getting is that when I click on the paging or filtering, the AJAX request is served (I can see the telerik:RadAjaxLoadingPanel running), but it runs indefinitely and the data doesn't change. The data source itself is an Access 2007 file (Northwind 2007.accdb) located in the App_Data folder of the application.

I'm using "RadControls_for_ASP.NET_AJAX_2009_3_1103" on VS.Net 2010. The project where this Default.aspx page is set up is a "Telerik RadControls CSharp Web Application".

Thanks in advance for any help.

Sanjay.

27 Answers, 1 is accepted

answered on 22 Oct 2010, 04:38 PM

radgrid-filtering.zip

Hi Sanjay,

I tried to replicate the issue which you described, but to no avail. I take the provided code and put it in a simple test project attached to this message.

Please, take a look at it and let me know if there are any differences at your ends, which I may be leaving out.

Greetings,
Pavlina
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 25 Oct 2010, 08:56 AM

Hi Pavlina,

I've got another question then! Am trying to use the RadFilter, but am getting a error message on compilation saying "Unknown server tag 'telerik:RadFilter'." Am I missing a reference? I have version 2009.3.1103.35 "Telerik.Web.UI.dll" referenced in the project. and my web.config file looks like this:

<?xml version="1.0"?>

<system.web>

<pages>

</controls>

</pages>

</httpHandlers>

</httpModules>

</system.web>

<system.webServer>

</modules>

</handlers>

</system.webServer>

</configuration>

Any suggestions???

answered on 26 Oct 2010, 02:40 PM

HI,

I'm getting a javascript error when using the RadGrid:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E)

Timestamp: Tue, 26 Oct 2010 13:36:17 UTC

Message: Object doesn't support this property or method

Line: 8665

Char: 67

Code: 0

URI: http://localhost:52193/TelerikExamples/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_HiddenField&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d4.0.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a1f68db6e-ab92-4c56-8744-13e09bf43565%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2009.3.1103.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3a4552b812-caf7-4129-9b53-8f199b5bce6c%3a16e4e7cd%3aed16cbdc%3a58366029%3af7645509%3a24ee1bba%3a1e771326%3aaa288e2d

The code is as follows:

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

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

<telerik:AjaxSetting AjaxControlID="RadGrid3">

<telerik:AjaxUpdatedControl ControlID="RadGrid3" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadGrid ID="RadGrid3" DataSourceID="ObjectDataSource1" AllowPaging="True"

PageSize="5" runat="server" GridLines="None" Width="100%">

</telerik:RadGrid>

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetCurrentOrders"

TypeName="MicrosoftSqlExpress2005" />

If I have the pager to have a mode of "NextPrevAndNumeric" I get the error. If I choose one of the other modes I don't get the error. Any suggestions?

Thanks,

Sanjay.

answered on 27 Oct 2010, 03:53 PM

Here is a link to the project in zipped format:

https://www.yousendit.com/download/ZGJjY05saTFVbSt4dnc9PQ

The link expires on 3rd Nov 2010.

When you download the project, if you look at the following files, i've detailed the problems:

(1) "0001 Basic Paging.aspx": RadGrid1 and RadGrid2 are fine, RadGrid3 doesn't work though because of a different pager mode.
(2) "0002 Basic Paging With Defined Columns.aspx": This works ok, but if you change the pager mode to "NextPrevAndNumeric" it won't work.
(3) "0001 Basic Filtering.aspx": This works ok, but again changing pager mode to "NextPrevAndNumeric" it won't work.
(4) "0002 Filtering Template Columns.aspx": Trying to filter on any column doesn't work. Same for sorting and paging. With paging we have a simple mode of "NumericPages" but it still doesn't work.

Any problems Pavlina, just contact me.

Thanks for your help,

Sanjay.

answered on 02 Nov 2010, 11:36 AM

telerikexamples.zip

Hi Sanjay,

You can fix the problem by upgrading to the latest version of the RadControls for ASP.NET AJAX. I am attaching a modified demo for reference.

I hope this helps.

Best wishes,
Pavlina
the Telerik team

answered on 29 Dec 2010, 08:09 PM

Here is my code.

telerik:RadScriptManager ID="scriptManager" runat="server">

</telerik:RadScriptManager>

<telerik:RadSkinManager ID="RadSkinManager1" runat="server" Skin="Office2007" />

<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" DecoratedControls="All" />

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="dataSource" AllowPaging="True"

AllowSorting="True" GridLines="None" Width="925px" AllowAutomaticDeletes="False" AllowFilteringByColumn="true" EnableLinqExpressions="false" >

<MasterTableView CellSpacing="-1" AutoGenerateColumns="False" DataKeyNames="state_code"

DataSourceID="dataSource" Width="100%" CommandItemDisplay="Top">

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">

<ItemStyle HorizontalAlign="Center" CssClass="gridImage" />

</telerik:GridEditCommandColumn>

<telerik:GridBoundColumn DataField="State_code" HeaderText="State">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="federal_project_Number" HeaderText="Project #">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="record_status" HeaderText="Record_Status" SortExpression="record_status" >

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:LinqDataSource ID="dataSource" runat="server" ContextTypeName="TestApplication.TestDataDataContext"

TableName="Projects">

</asp:LinqDataSource>