Selecting mutiple rows in Gridview using text box (find button)

Question

Dear All

             I had developed an application which consists of one Textbox and a gridview, whenever i search rows in gridview i may able to search only single  row at once , but my intension is if i search for second row in the textbox the first row should be checked .

Below is my search code :

if(txtsearch.text!="")
{
    Empcode=txtsearch.text;

    da=new sqladapter("select Empcode,Name FROM Employee where                                               empcode='" + empcode + "' OR Name LIKE '" +                                             empcode + "'+'%' order by empcode", conn);

da.Fill(ds);
 Gridview.DataSource = ds;
Gridview.DataBind();
}


thanks in advance


Regards

Sandeep Kodepaka