Create dynamic filter on GridView to search multiple columns in ASP.Net

i've created a filter textbox for searching my data in gridview..

ex: i've 3 columns in gridview : ID, NAME, DATE

I ask, how to create a dynamic search for 3 columns in gridview using a textbox?

without writing a query repeatedly :(ID like '%" + search + "%') OR  (NAME like '%" + search + "%') OR  (DATE like '%" + search + "%')

 protected void btnCariConnStrSubmit_Click(object sender, EventArgs e)
    {
        string search = ((TextBox)GridView1.HeaderRow.FindControl("txtCariConnStr")).Text;
        string sql = "select * from report where (ID like '%" + search + "%') OR  (NAME like '%" + search + "%') OR  (DATE like '%" + search + "%')  ";
        reader = mda.GetData(sql, connStr).CreateDataReader();
        if (reader.Read()) { dt = mda.GetData(sql, connStr).Tables[0]; BindGridView(dt); lblRecordNotFound.Visible = false; }
        else { Bindemptydt(); lblRecordNotFound.Visible = true; }
        ((TextBox)GridView1.HeaderRow.FindControl("txtCariConnStr")).Text = search;
    }