title: Show two columns from SQLite as same string in a listview in android
body: <p>Hi I am developing an android in which I am loading data from database and showing it in a List View.
  My code is as follows</p>
  
  <pre><code>public class rel extends ListActivity {
  @Override
  public void onCreate(Bundle savedInstanceState){
      super.onCreate(savedInstanceState);
      setContentView(R.layout.refill);
      //Creating an object called mydbhelper
      Dbms mydbhelper = new Dbms(this);
      //Loading the database in writable format
      SQLiteDatabase db=mydbhelper.getWritableDatabase();
      String[] id= new String[]{"_id","medicine","hs"};
      //Cursor
      Cursor c = db.query("medicines",id,null,null,null, null,null);
      startManagingCursor(c);
      String[] from = new String[]{"medicine"};
      int[] to = new int[] { R.id.textlist1};
       // Now creating an array adapter and set it to display using my row
      SimpleCursorAdapter notes =new SimpleCursorAdapter(this, R.layout.notes_row, c, from, to);
      setListAdapter(notes);
  
  
  
  }
  </code></pre>
  
  <p>What i want to achieve is show a list view as "Medicine-hs" in which medicine is from one column and hs is from an another column of database. For example as 
  XYZ-HS1
  ABC-HS2
  as the listview contents</p>
  
  <p>How to achieve this?
  Right now I am able to get only Medicine</p>
  
  <p>Please give your kind suggestions</p>
  
  <p>}</p>