We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GridGroupingControl filtering og SQLdatasource

Thread ID:





55132 Jan 24,2007 10:32 AM UTC Jan 29,2007 10:21 AM UTC ASP.NET Web Forms (Classic) 3
Tags: GridGroupingControl
Tina Christiansen
Asked On January 24, 2007 10:32 AM UTC

I'm totaly new at this control.
I have attached an sql datasourge to a grid and the data is read in fine and i can sort the colmns. But when i try and filter on a column then the application freeses and it just says Refreshing... in the status bar.

this is my markup:

DataMember="DefaultView" DataSourceID="SqlDataSource1" Width="793px" EnableCallbacks="true" PageSize="0">

SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle] FROM [Customers]">

and in the page load i have:


Tina Christiansen
Replied On January 24, 2007 12:01 PM UTC

Hummm that wendt wrong trying again:

My markup:

ID="GridGroupingControl1" runat="server" ClientObjectID="" DataMember="DefaultView" DataSourceID="SqlDataSource1" Width="793px" EnableCallbacks="true" PageSize="0">

Tina Christiansen
Replied On January 24, 2007 12:06 PM UTC

Don't know why but it wil not show the markup. I have attached it as a gif in a zip file.


Administrator [Syncfusion]
Replied On January 29, 2007 10:21 AM UTC

Hi Tina,

Sorry for the delay in getting back to you.

Attached is the sample which allows the filtering operation when the Grid Grouping control is binded with the SqlDataSource.


Before starting working with the sample remove the SqlDataSource in this sample.Make necessary configuration to your SQL server. Create SqlDataSource1 using NorthWind.mdb from the 'Customers' table with the following fields CustomerID,CompanyName,ContactName,ContactTitle,
Address and City.

To get filtering to work you have set the AllowFilter property to 'True' for the Gird Grouping columns as in the above attached sample. While setting 'AllowFilter' property to true, you will get a design time issue which has been forwarded to our Essential Grid Development Team. Due to this the Grid Grouping functionalities will not get affected, and will work fine.

An Online demo for 'Filtering Options' can be obtained in the link http://www2.syncfusion.com/syncfusion/infrastructure/samplebrowserasp/samples.aspx?version=2_0 , here visit [Grid.Grouping.Web/Filtering/FilterBar Demo].

Please let us know if you have any further queries.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon