if(c.moveToFirst())
  {
   for(int i = 0; i< c.getCount(); i++)
   {
    
    TableRow newRow = new TableRow(this);
    TextView nameCol = new TextView(this);
    TextView typeCol = new TextView(this);
    TextView pwdCol = new TextView(this);
    Button deleteButton = new Button(this);
      
    newRow.setTag(c.getInt(c.getColumnIndex(SITE._ID)));  // set the tag field on the TableRow view so we know which row to delete
    nameCol.setText(c.getString(c.getColumnIndex(SITE.SITE_NAME)));
    typeCol.setText(c.getString(c.getColumnIndex(ID.ID_TYPE_NAME)));
    pwdCol.setText(c.getString(c.getColumnIndex(PWD.PWD_TYPE_NAME)));
    
    
    deleteButton.setText("Delete");
    deleteButton.setTag(c.getInt(c.getColumnIndex(SITE._ID)));  // set the tag field on the button so we know which ID to delete
    deleteButton.setOnClickListener(new View.OnClickListener() {
     public void onClick(View v) {
      // Delete that information
      Integer id = (Integer) v.getTag();
      deleteInformation(id);
      
      // Find and destroy the row tagged with the deleted information id in the Table 
      final TableLayout managerTable = (TableLayout) findViewById(R.id.TableLayout_ManagerList);
      // This should return the TableRow as the first tagged view in the layout but it would be nice if it returned an array of views with that tag...
      View viewToDelete = managerTable.findViewWithTag(id);
      managerTable.removeView(viewToDelete);
      
      
     }
    });
    
    newRow.addView(nameCol);
    newRow.addView(typeCol);
    newRow.addView(pwdCol);
    newRow.addView(deleteButton);
    managerTable.addView(newRow);
    c.moveToNext();
   }
  }
  else
  {
   TableRow newRow = new TableRow(this);
   TextView noResults = new TextView(this);
   noResults.setText("No results to show.");
   newRow.addView(noResults);
   managerTable.addView(newRow);
  }
  c.close();
  db.close();
  
 }

한테이블에서 결과를 첫번쨰 줄 내용만 읽어옵니다..

어느부분을 고쳐야 정상 출력될까요 ㅠㅠ 도와주세요

device.png 

PWD 테이블이 두번째가 222로 나와야되는데 111로..첫번째 내용만을 불러옵니다..

DB쿼리의 경우는 물어봤는데 이상이 없는거 같다는데 .. 이부분이 문제인거 같은데 어디가 잘못된건지 ..

어디를 어떻게 고쳐야되는지좀 알려주세요 ㅠㅠㅠㅠㅠ