title: how would i display multiple data from an sqlite database in android
body: <p>i cant seem to display multiple  data from my database. only one  data from my database gets printed.  </p>
  
  <p>DatabaseHelper:</p>
  
  <pre><code>    public Cursor returnData2(String text, String look){
      String data;
      String where = "_column LIKE '"+look+"%'";
  
  
      Cursor c = myDataBase.query("translate_metadata", null, where, null, null, null, null);
  
      c.moveToFirst();
      while(!c.isAfterLast()){
  
         c.moveToNext();
      }
      return c;
  
  }
  </code></pre>
  
  <p>activity:</p>
  
  <pre><code>    String inputtext = ((EditText) findViewById(R.id.inputKey)).getText().toString();
              String lowerinput = inputtext.toLowerCase();
              data = myDbHelper.returnData2("databasename",lowerinput);
               if(data.moveToFirst()){
                   rdata = data.getString(1);
                   ((TextView) findViewById(R.id.keyList)).setText(""+rdata.toString()+"\n");
  
               }
  
              myDbHelper.close(); 
          }
  </code></pre>
  
  <p>sorry if  its confusing. but i need the help. any suggestion will do. thanks       </p>