Check box refresh issue in ListView with custom adaptor
<p>I'm having a list View with each item composed of a collection of Textviews and a CheckBox.
I'm storing the <strong>state of the checkbox in the DB</strong> and updating it from a on clickListener .It works fine for the controls that are visible.By default all the checkbox's are in the checked state.</p>

<p>If there are 10 items and screen can accommodate 7, then when I Uncheck the first one and scroll to the 10th item and again scroll back to the first one. The first one looses its state( it gets checked again).I checked the DB for the rows state, which is reflected correctly. But the fetch in the BindView always get me the wrong state. I'm not able to pin down where the issues is. I have attached the list adaptor along with this for review...</p>

<p>// List Adaptor code</p>

<p>public class ListAdaptor extends CursorAdapter {</p>

<pre><code>private LayoutInflater mInflater;
Cursor  dataCursor;
Context context;
ListView mLv;

private static final String TAG = "Delete";

public ListAdaptor(Context context, Cursor cursor, ListView lv) 
{
    super(context, cursor);
    this.context = context;
    mLv = lv;
    mInflater   = LayoutInflater.from(context);
}

@Override
public void bindView(View view, Context context, final Cursor cursor) {

    // Get the stored tag for the view

    CheckBox tmp_Chk    = (CheckBox)view.findViewById(R.id.chkbox);
    String selText = cursor.getString(11); 

    // Debug Message
    int val = cursor.getPosition();

    tmp_Chk.setChecked(false);

    SparseBooleanArray sba = mLv.getCheckedItemPositions();
    if(sba != null)
    if(sba.get(cursor.getPosition()))
        tmp_Chk.setChecked(true);
    }

    @Override
    public View newView(Context context, Cursor cursor, ViewGroup parent) 
    {
        View newView = mInflater.inflate(R.layout.listviewlyt, null);
        return newView;
    }

}

// Item layout

&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal"&gt;

&lt;CheckBox
    android:id="@+id/chkbox"
    android:focusable="false"
    android:clickable="false"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"&gt;

&lt;/CheckBox&gt;


&lt;TextView
    android:id="@+id/label"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="@+id/label"
    android:textSize="18sp"
    android:textColor="#000000" &gt;
&lt;/TextView&gt;



&lt;/LinearLayout&gt;

// List control code in the Main Activity

lv.setOnItemClickListener(new OnItemClickListener() {
public void onItemClick(AdapterView&lt;?&gt; parent, View view, int position, long id) {

    int lv_Pos = ListView.INVALID_POSITION;
    CheckBox tmp_Chk    = (CheckBox)view.findViewById(R.id.chkbox);
    if (lv_Pos != ListView.INVALID_POSITION) {
        if(tmp_Chk.isChecked()){
            Check_Uncheck(Integer.toString(lv_Pos + 1), 1);
    }
    else if(!tmp_Chk.isChecked()){
        Check_Uncheck(Integer.toString(lv_Pos + 1), 0);
    }   
}

public void Check_Uncheck(String deleteItem , int select)
{
    // Initialize database
    DB dbAdapters = DB.getDBAdapterInstance(TabActivity.this);
    dbAdapters.openDataBase();

    ContentValues cv_InitialValues = new ContentValues();
    cv_InitialValues.put("Selection", select);

    dbAdapters.b_UpdateRecordInDB("Items", cv_InitialValues, "_id=?", new String[] {deleteItem});
    dbAdapters.close();
}
</code></pre>

<p>});</p>

<p>// List view XML Properties in the Main activity</p>

<pre><code>&lt;ListView 
    android:id="@+id/LV_Instore_CartTab"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:textSize="2px"
    android:layout_weight="1"
    android:choiceMode="multipleChoice"/&gt;
</code></pre>
