Sorting and Paging a Gridview with generated datareader

I've been looking for some examples on how to sort a gridview with custom generated datareader.

Here's how I bind gridview with datareader.

        sqlConn.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        gridBookings.DataSource = reader;
        gridBookings.DataBind();
        sqlConn.开发者_开发知识库Close();

And this is the sorted event handler of the gridview

protected void gridBookings_Sorted(object sender, EventArgs e)
{
    gridBookings.DataBind();
}

Here's the gridview markup.

<asp:GridView ID="gridBookings" runat="server"  CssClass="zebra-striped" 
        EmptyDataText="No data available, sir" ShowHeaderWhenEmpty="True" 
        ClientIDMode="Static" AutoGenerateColumns="False" AllowSorting="True" 
        onsorted="gridBookings_Sorted">
<columns>
<asp:BoundField HeaderText="BookingID" DataField="booking_id" SortExpression="booking_id"/><asp:BoundField HeaderText="CustomerID" DataField="cus_id" SortExpression="cus_id" />
<!--More bound fields-->
</columns>
</asp:GridView>

And this is the error I get when I click the link buttons in the header column.

The GridView 'gridBookings' fired event Sorting which wasn't handled.

Any ideas?

PS. On the side question, how can I show the blank gridview with empty rows when any data hasn't bind to it?

You're subscribing to the "Sorted" event... but you also need to subscribe to the "Sorting" event. You should really upgrade to a newer version of ASP.NET :)

Gridview's Sorting event occurs when the hyperlink to sort a column is clicked, but before the GridView control handles the sort operation. Sorted event occurs when the hyperlink to sort a column is clicked, but after the GridView control handles the sort operation. Generally we use gridviews sorting event for sorting items in gridview. Check out this link for a detailed example of sorting items in gridview

<asp:GridView ID="gridBookings" runat="server"  CssClass="zebra-striped" 
    EmptyDataText="No data available, sir" ShowHeaderWhenEmpty="True" 
    ClientIDMode="Static" AutoGenerateColumns="False" AllowSorting="True" 
    onsorted="gridBookings_Sorted"
    onsorting="gridBookings_Sorting">

protected void gridBookings_Sorting(object sender, GridViewSortEventArgs e)
{
    //handled onsorting
}