This is the aspx code

<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:Conn %>" 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="GridView3" runat="server" class="table table-bordered table-striped" AutoGenerateColumns="False" DataSourceID="SqlDataSource3" AllowPaging="true" PageSize="10" OnSelectedIndexChanged="GridView3_SelectedIndexChanged"> <Columns> <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>

this is the aspx.cs

`protected void SearchButton1_Click(object sender, EventArgs e)
{

        if (SearchTextBox1.Text != "" || SearchTextBox1.Text != null) {

            try
            {

                SqlConnection Conn = new SqlConnection(strcon);

                if (Conn.State == ConnectionState.Closed)
                {

                    Conn.Open();

                }

                SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM User_tbl WHERE (user_name LIKE'%" + SearchTextBox1.Text.Trim() + "%' or user_fullname LIKE'%" + SearchTextBox1.Text.Trim() + "%' or user_branch LIKE'%" + SearchTextBox1.Text.Trim() + "%')", Conn);

                DataSet ds = new DataSet();

                da.Fill(ds);

                GridView1.DataSourceID = "";

                GridView1.DataSource = ds;

                GridView1.DataBind();

                Conn.Close();

            }

            catch (Exception ex)
            {

                Response.Write("<script>alert('" + ex.Message + "');</script>");

            }

        }

        else {

            Response.Write("<script>alert('من فضلك ادخل كلمة للبحث');</script>");

        }

    }`

the code is working for two pages where the data entries are few and there is no pagination.

Please advise