Gridview Cinema Seating Arrangement uSing Sqlite In Android

Please note that i have developing a Cinema Seating Arrangement Application using Sqlite Database. Once user select the Seat it will update in Database. When the same person trying to relogin that app, then the previously clicked seat should be show as Red Color. so here it should be check the condition in databse to reflect. Please Help me out thank you in advance

` public View getView(final int position, View convertView, ViewGroup parent) { View row = convertView;

if (row == null) {

        LayoutInflater inflater = ((Activity) context).getLayoutInflater();
        row = inflater.inflate(R.layout.grid_row, parent, false);
        row.getTag(position);
    //  TextView textViewTitle = (TextView) row.findViewById(R.id.textView);
        final ImageView imageViewIte = (ImageView) row.findViewById(R.id.imageView);
        for(int h=0;h<=position;h++)
        {
        //  String checkred="red";
        //  Cursor c=dbobj.retrivedata(checkred);
            Cursor c=dbobj.retrivedata();
            ArrayList<String> chktb = new ArrayList<String>();
            chktb.clear();
                try
                {
            if (c.moveToFirst()) 
                {
                    while ( !c.isAfterLast() ) 
                    {                                       
                        chktb.add(c.getString(0));
                        chktb.add(c.getString(1));
                        chktb.add(c.getString(2));
                        chktb.add(c.getString(3));
                        Log.v("","Table :"+c.getString(0)+"");
                        Log.v("","Table :"+c.getString(2)+"");
                        c.moveToNext();
                    }
                }
                }
                catch(Exception e)
                {
                    Log.v("Exception",""+e);
                }
                String rd=chktb.get(1);
                int r = Integer.parseInt(rd);

                if(r==0)
                {
                imageViewIte.setImageResource(R.drawable.red);
                }

                else
                {

                    imageViewIte.setImageResource(R.drawable.green);
            }

    }
        imageViewIte.setOnClickListener(new View.OnClickListener() 
            {                   
                boolean showingFirst = true;
                String selectedItem;
                public void onClick(View v) 
                {
                if(showingFirst == true)
                {
                    imageViewIte.setImageResource(R.drawable.yellow);
                    flagpass=flag+1;
                    int mPosition = position;  
                    Toast.makeText(context, "current valusess.. "+mPosition,Toast.LENGTH_SHORT).show();
                    showingFirst = false;
                    selectedItem="You Blocked This Seat";
                  }
                else
                {
                    imageViewIte.setImageResource(R.drawable.green);
                    int mPosition1 = position;  
                    showingFirst = true;
                    selectedItem="You unBlocked This Seat";
                }

                 Toast.makeText(context, "Selected Item: "+selectedItem,Toast.LENGTH_SHORT).show();

                }

        }); 
            }

return row;
}`