fayenot 0 Newbie Poster

hello guys,i managed to search records inside my grdiview.. however after the search,after i've seen my filtered records i want to display again all the records when i erase the words on my search txtbox.. here is my code for my search button.. please help..thanks in advance

protected void Button1_Click(object sender, EventArgs e)
    {

        SqlDataSource1.SelectCommand = "Select * FROM Client WHERE ClientName LIKE '%" + txtSearch.Text + "%' AND Status = @IsStatus AND UserId=@UserId";
        GridView1.DataSourceID = "SqlDataSource1";
        GridView1.DataBind();
    }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.