Data Controls :: Create Dynamic Filter On GridView To Search Multiple Columns

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;
}