protected void txtSearch_TextChanged(object sender, EventArgs e) { RiverTableAdapter RiverTableAdapter = new RiverTableAdapter(); DataSet ds = RiverTableAdapter.GetSearchByRiver(txtSearch.Text, "ACTIVE"); if (ds.Tables[0].Rows.Count > 0) { Session["dt"] = ds.Tables[0]; PagingDataBind((DataTable)Session["dt"]); } }