using (OracleConnection conn = new  OracleConnection(stringConn))
        {
            string sql = "select BookID, ISBN, Title, PublishedDate, Edition, Publisher, DepartmentName from Books where Title like '%Title%'";
            OracleDataAdapter adap = new OracleDataAdapter(sql, conn);
            adap.SelectCommand.Parameters.Add("Title", OracleType.VarChar).Equals(txtSearch.Text);
            adap.SelectCommand.Connection.Open();
            adap.Fill(dt);
        }
        DataGrid1.DataSource = dt;
        DataGrid1.DataMember = "Books";
        DataGrid1.DataBind();
    }

           string cnstr = "data source=abc;user id=hr;password=hr";
 
           // append pattern mach character
            textBox1.Text = textBox1.Text + "%";  
           // Use & - prefix with parametername
            string sql = "select * from employees where first_name like 
                                 &test";
           // No need to set reference of connecton object.
            OracleDataAdapter adp = new OracleDataAdapter(sql, 
                                          cnstr);
            adp.SelectCommand.Parameters.Add("&test", 
                                                               OracleType.VarChar );
            adp.SelectCommand.Parameters[0].Value = textBox1.Text;
 
            DataTable dt = new DataTable();
            // Fill method automatically opens & close the connection
            adp.Fill(dt);
            DataGrid1.DataSource = dt;    
            DataGrid1.DataBind();