"Search by" after import an Excel file
<p>I am developing a project which consists on importing a file from an external storage and then my goal it's "Search by".</p>

<p>I have to public classes, one of them will controll the database and the second one is the MainActivity.</p>

<p>My output after importing the .csv file is:
<a href="http://i.stack.imgur.com/bNL0d.png" rel="nofollow">enter image description here</a></p>

<p>That EditText field is where I want to for example right "Apple" and my select query will show me just the Apple products by Company.</p>

<p><div class="snippet" data-lang="js" data-hide="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>EditText etSearch = (EditText)findViewById(R.id.etSearch);

        etSearch.addTextChangedListener(new TextWatcher() {
            @Override
            public void beforeTextChanged(CharSequence s, int start, int count, int after) {

            }

            @Override
            public void onTextChanged(CharSequence s, int start, int before, int count) {
                controller = new DBController(getApplicationContext());
                SQLiteDatabase db = controller.getWritableDatabase();
                String tableName = "proinfo";
                db.execSQL("SELECT Company FROM " + tableName);
            }

            @Override
            public void afterTextChanged(Editable s) {

            }
        });</code></pre>
</div>
</div>
</p>