How to delete particular cell and row from sqlite in ios sdk

Question

Here is what I've implemented cellforRowAtIndexPath method

    - (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath;
{
    static NSString *cellIdentifier=@"myCell";
    CustomTableCell *cell=[tableView dequeueReusableCellWithIdentifier:cellIdentifier];
    if (cell==nil)
    {
        cell=[[CustomTableCell alloc]initWithStyle:UITableViewCellStyleDefault reuseIdentifier:cellIdentifier];
    }
        DBObjectClass * info=[StudentInformationArr objectAtIndex:indexPath.row];
    cell.studIdLbl.text=[NSString stringWithFormat:@"%d",info.StudIDs];
    cell.studNameLbl.text=info.StudentName;
    cell.studEmailLbl.text=info.StudentEmail;
    cell.StudcontactLbl.text=[NSString stringWithFormat:@"%d",info.StudentContact];


    return cell;

}

where DBObjectClass is NSOBject Class model Class

Here is how I'm displaying my data in TableView

-(NSMutableArray*)StudentInformation;
{
    NSMutableArray *DBArray=[[NSMutableArray alloc]init];
    NSString *query=@"SELECT * FROM StudInfo ORDER BY studid";
    NSLog(@"Query is:%s",[query UTF8String]);
    sqlite3_stmt *statement;
    if (sqlite3_prepare_v2(_database, [query UTF8String], -1, &statement, nil)==SQLITE_OK)
    {
        while (sqlite3_step(statement)==SQLITE_ROW)
        {
            int  studID=sqlite3_column_int(statement, 0);
            char *studName=(char*)sqlite3_column_text(statement, 1);
            char *studEmail=(char*)sqlite3_column_text(statement, 2);
            int studContact= sqlite3_column_int(statement, 3);

            NSString *name=[[NSString alloc]initWithUTF8String:studName];
            NSString *email=[[NSString alloc]initWithUTF8String:studEmail];
            DBObjectClass *DbObj=[[DBObjectClass alloc]initWithSID:studID SName:name SEmail:email SContact:studContact];
            [DBArray addObject:DbObj];

        }
        sqlite3_finalize(statement);
    }
    sqlite3_close(_database);
    return DBArray;
}

and I'm trying to implement delete query here

- (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath

How to get this work?Any help will be aprreciated

Use deleteObject method of NSManagedobjectContext. – Puneet Sharma Oct 03 '13 at 06:24 — Puneet Sharma, Oct 03 '13 at 06:24
Are you using Sqlite or core data? – Ganapathy Oct 03 '13 at 06:25 — Ganapathy, Oct 03 '13 at 06:25
Thanks Puneet I'm using Sqlite Database – Vibhs Oct 03 '13 at 07:54 — Vibhs, Oct 03 '13 at 07:54

wesley · Answer 1 · 2013-10-03T06:35:57.043

Try like this.

- (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath 
 {
    if (editingStyle == UITableViewCellEditingStyleDelete)
         {
         NSManagedObject * managedObject = [StudentInformationArr objectAtIndex:indexPath.row];

         NSError *error;   
            [[self getManagedObjectContext] deleteObject: managedObject];
            [[self getManagedObjectContext] save:&error];
        }
//before reload your tableView you have to fetch the data from your core data again. So that StudentInformationArr will get updated. Use something like 

    StudentInformationArr =[self fetchStudentInformationArray];

        [self.myTableView reloadData];
}

How to delete particular cell and row from sqlite in ios sdk

1 Answers1