textbox and button

hai 2 all

I have an option of search on my web page

ontextchanged="txtSearch_TextChanged">

---------------------------------------------------------------------
code
---------------------------------------------------------------------
protected void txtSearch_TextChanged(object sender, EventArgs e)
        {
           this.txtsearching();
       }

protected void btnSearch_Click(object sender, EventArgs e)
        {
            this.txtsearching();
        }

private void txtsearching()
        {
            string strSQL = "";
            if (txtSearch.Text.Trim() == "")
            {
             strSQL = "select * from customers where flag=1 ORDER BY customer_code";
            }
            else
            {
                strSQL = "select * from customers where flag=1 and (customer_code like '%" + txtSearch.Text.Trim() + "%' or customer_organization_name like '%" + txtSearch.Text.Trim() + "%')";

            }
            SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["constring"].ToString());
            SqlDataAdapter sda = new SqlDataAdapter(strSQL, con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            gvKenyacustomers.DataSource = dt;
            gvKenyacustomers.DataBind();
            sda.Dispose();
            con.Dispose();
            dt.Dispose();
            txtSearch.Text = "";

        }
-------------------------------------------------------------------
1)my problem is when ever i am entering sme text in textbox txtSearch_TextChanged is fireing..twice
2) after entering the text in textbox and onclicking the search button btnSearch_Click is not fireing. txtSearch_TextChanged is fireing again

what is the solution for this...
when entering the text in textbox and hit the enter then txtSearch_TextChanged has to fire only once
and when we enter the text in textbox and if hit the search button...
btnSearch_Click has to fire..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

shashi reddy15y ago
hai suthish

okay
0
Suthish Nair15y ago
you need to read more about how TextBox event TextChanged works.
0
Vulpes15y ago
I think your problem is that you have circular method calls. txtSearch_TextChanged is calling txtSearching but, in the last line of that method, you're setting txtSearch.Text to an empty string which is triggering textSearch_TextChanged again!

This may fix it:

protected void txtSearch_TextChanged(object sender, EventArgs e)
{
if (txtSearch.Text != "") this.txtsearching();
}
0