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());
}
}
});
}