The ASP.NET Grid has the option to handle millions of records in less than 2 seconds.
To enable this feature, just declare a ObjectDataSource then bind it to the grid.

- The ObjectDataSource control uses reflection to call methods of a business object
to select, update, insert, and delete data.

- You set the ObjectDataSource control's TypeName property
to specify the name of the class to use as a source object.

You also need to:
- set the Serialize property of the Grid to false
- use the paging feature of the ObjectDataSource control: EnablePaging
- use a method for returning the total number of records: SelectCountMethod
- specify the SortParameterName
- the Grid needs to have the EmbedFilterInSortExpression property set to true (when filtering is used)
- format the SQL query to retrieve only the required rows in business object.

For details on how to create a source data object to be used with the ObjectDataSource control,
see Creating an ObjectDataSource Control Source Object.

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


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

	Dim ods1 As ObjectDataSource = New ObjectDataSource
	
	ods1.ID = "ods1"
	ods1.TypeName = "OrdersDataPerformance"
	ods1.SelectMethod = "GetOrders"
	ods1.SelectCountMethod = "GetOrdersCount"
	ods1.EnablePaging = "true"
	ods1.SortParameterName = "sortExpression"
	
	Page.Controls.Add(ods1)

	grid1.DataSourceID = "ods1" 
	grid1.Serialize = false
	grid1.EmbedFilterInSortExpression = True

	ObjectDataSource ods1 = new ObjectDataSource();

	ods1.ID = "ods1";
	ods1.TypeName = "OrdersDataPerformance";
	ods1.SelectMethod = "GetOrders";
	ods1.SelectCountMethod = "GetOrdersCount";
	ods1.EnablePaging = true;
	ods1.SortParameterName = "sortExpression";

	Page.Controls.Add(ods1);

	grid1.DataSourceID = "ods1";
	grid1.Serialize = false;
	grid1.EmbedFilterInSortExpression = true;

GetOrders(string sortExpression, int maximumRows, int startRowIndex)
 Method. Reads the grid data from database.

• sortExpression - the filtering conditions.
• maximumRows - the number rows per page.
• startRowIndex - the index of first row on this page.

These parameters use to build the SQL query to retrieve only the required rows.

GetOrdersCount()
 Method. Counts the number records which satisfies the filtering conditions.