OBOUT - ASP.NET Grid - Filter with Paged ObjectDataSource

Quick Links

ASP.NET Grid - Filter with Paged ObjectDataSource

ORDER ID

NAME

CITY

POSTAL CODE

COUNTRY


99999	ShipName_99999	ShipCity_99999	ShipPostalCode_99999	ShipCountry_99999
99998	ShipName_99998	ShipCity_99998	ShipPostalCode_99998	ShipCountry_99998
99997	ShipName_99997	ShipCity_99997	ShipPostalCode_99997	ShipCountry_99997
99996	ShipName_99996	ShipCity_99996	ShipPostalCode_99996	ShipCountry_99996
99995	ShipName_99995	ShipCity_99995	ShipPostalCode_99995	ShipCountry_99995
99994	ShipName_99994	ShipCity_99994	ShipPostalCode_99994	ShipCountry_99994
99993	ShipName_99993	ShipCity_99993	ShipPostalCode_99993	ShipCountry_99993
99992	ShipName_99992	ShipCity_99992	ShipPostalCode_99992	ShipCountry_99992
99991	ShipName_99991	ShipCity_99991	ShipPostalCode_99991	ShipCountry_99991
99990	ShipName_99990	ShipCity_99990	ShipPostalCode_99990	ShipCountry_99990

Records: 1 - 10 of 100000 - Pages:

Apply Filter | Hide Filter

To achieve the best performance you need to bind the Grid to an ObjectDataSource control that has the Paging feature enabled. By setting the EmbedFilterInSortExpression property to true, the filter expression will be passed down to the SelectMethod method of the ObjectDataSource.

See the Maximum Performance tutorial

ASP.NET

<asp:ObjectDataSource runat="server" ID="ObjectDataSource1" TypeName="OrdersDataPerformance"
SelectMethod="GetOrders" SelectCountMethod="GetOrdersCount" EnablePaging="true" SortParameterName="sortExpression" />

<obout:Grid id="grid1" runat="server" DataSourceID="ods1" EmbedFilterInSortExpression="true">
</obout:Grid>

"I must say, I'm very impressed with your controls, and your prompt support. I have told several people in the software industry here in Chicago about your products and support."

Norman Paterson

Kaplan Professional Publishing

Random testimonial All testimonials