Searching Method

Searching Method:

C# Code

 protected void btnSearch_Click(object sender, EventArgs e)

        {

          

                showdata(" ");    // this function for show grid

    

        }

if (txtSearch.Text.ToString().Trim().Length > 0)

            {

                sqlStr += " and  concat(u.USER_SAL,' ',u.USER_FIRSTNAME,' ',u.USER_LASTNAME)                  LIKE '%" + txtSearch.Text.Trim().ToLower() + "%'";

            }

ASP.Net Code

<asp:TextBox ID="txtSearch" runat="server" class="searchbox-style" placeholder="Enter JD Name"></asp:TextBox>

       <asp:Button ID="btnSearch" runat="server" Text="Search" class="button-style" OnClick="btnSearch_Click"></asp:Button>