I want to filter a gridview that was already bind from the sql command and from the textchanged of the textbox the gridview will filter but it will never execute again the sql command it will filter all the rows that was already on the gridview.
heres my snippet:
in code behind:
protected void Page_Load(object sender, EventArgs e)
{
string query = "exec sp_GetCustomer_Info 'MOTHER','" + plant.ToString() + "','" + so.ToString() + "','" + chain.ToString() + "','" + channel.ToString().Replace("'", "") + "'," + "''" + "";
List
gridCustomer.DataSource = zone;
gridCustomer.DataBind();
gridCustomer.Visible = false;
}
then in textchanged:
protected void txtCustomer_TextChanged(object sender, EventArgs e)
{
gridCustomer.Visible = true;
??//don't know whats next
}
DESIGN PAGE:
Please help :(

SaiRojaPosted Nov 28, 2014, 5:47 AM
http://aspdotnet-kishore.blogspot.in/2014/10/search-gridview-records-data-on-textbox.html