0

I have a RecyclerView with CardView. I can create Card and I can insert data from that card to my database. Now I can delete this CardView. How can I delete that CardView from my database?

Thanks! And sorry for my bad English :)

Fragment of CardViewAdapter

public void onBindViewHolder(final ViewHolder holder, final int position) {
    CardViewDebt card = mDataset.get(position);
    holder.mWho.setText(card.getWho());
    holder.mWhom.setText(card.getWhom());
    holder.mWhat.setText(card.getTarget());
    holder.mStart.setText(card.getStartYear() + "/" + (card.getStartMonth() + 1) + "/" + card.getStartDay());
    holder.mEnd.setText(card.getEndYear() + "/" + (card.getEndMonth() + 1) + "/" + card.getEndDay());
    holder.checkbox.setChecked(false);
    holder.checkbox.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener(){
        @Override
        public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {
            if(isChecked) {
                DBHelper DataBase = new DBHelper(holder.mContext);
                SQLiteDatabase db = DataBase.getWritableDatabase();
                Log.d("Delete row in Database", "--- Delete from mytable: ---");
                db.delete("debt", "id = " + position, null);  <----Thats wrong
                mDataset.remove(position);
                notifyItemRemoved(position);
                notifyItemRangeChanged(position, mDataset.size());
            }
        }
    });
}

0 Answers0