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();
}