this is the code

<asp:SqlDataSource ID=”SqlDataSource2″ runat=”server” ConnectionString=”<%$ ConnectionStrings:con %>” SelectCommand=”SELECT [Client_tbl].[client_fullname],[Ticket_tbl].[client_phone],[Client_tbl].[client_email],[Client_tbl].[client_company],[Client_tbl].[client_id_num],[Client_tbl].[client_tax_num],[Ticket_tbl].[ticket_category],[Ticket_tbl].[ticket_shortdetails],[Ticket_tbl].[ticket_details],[Ticket_tbl].[user_fullname],[Ticket_tbl].[user_branch],[ticket_date] FROM [Ticket_tbl] INNER JOIN [Client_tbl] ON [Ticket_tbl].[client_phone] = [Client_tbl].[client_phone] ORDER BY [Ticket_tbl].[ticket_id] DESC”></asp:SqlDataSource>
<asp:GridView ID=”GridView1″ runat=”server” class=”table table-bordered table-striped” AutoGenerateColumns=”False” DataSourceID=”SqlDataSource2″ OnSelectedIndexChanged=”GridView1_SelectedIndexChanged”>

<asp:CommandField ShowSelectButton=”True” />
<asp:BoundField DataField=”client_fullname” HeaderText=”اسم العميل” SortExpression=”client_fullname” />
<asp:BoundField DataField=”client_phone” HeaderText=”التليفون” SortExpression=”client_phone” />
<asp:BoundField DataField=”client_email” HeaderText=”الإيميل” SortExpression=”client_email” ItemStyle-CssClass=”hidden” HeaderStyle-CssClass=”hidden” />
<asp:BoundField DataField=”client_company” HeaderText=”الشركة” SortExpression=”client_company” />
<asp:BoundField DataField=”client_id_num” HeaderText=”رقم البطاقة” SortExpression=”client_id_num” ItemStyle-CssClass=”hidden” HeaderStyle-CssClass=”hidden” />
<asp:BoundField DataField=”client_tax_num” HeaderText=”رقم التسجيل الضريبى” SortExpression=”client_tax_num” ItemStyle-CssClass=”hidden” HeaderStyle-CssClass=”hidden” />
<asp:BoundField DataField=”ticket_category” HeaderText=”القسم” SortExpression=”ticket_category” />
<asp:BoundField DataField=”ticket_shortdetails” HeaderText=”مختصر التفاصيل” SortExpression=”ticket_shortdetails” />
<asp:BoundField DataField=”ticket_details” HeaderText=”التفاصيل” SortExpression=”ticket_details” ItemStyle-CssClass=”hidden” HeaderStyle-CssClass=”hidden” />
<asp:BoundField DataField=”user_fullname” HeaderText=”المستخدم” SortExpression=”user_fullname” />
<asp:BoundField DataField=”user_branch” HeaderText=”الفرع” SortExpression=”user_branch” />
<asp:BoundField DataField=”ticket_date” HeaderText=”التاريخ” SortExpression=”ticket_date” />

                </Columns>
            </asp:GridView>

used gridview to display the sql data from database, but my problem is that the sqldatasource select all the database entries which will cause page load so much slower.

please tell me how to create a better code to handle data display and pagination.

Many Thanks