how to populate data into UItableView by fetching data from database in ios

Question

Untill now I have used arrays to insert data into the tables in IOS, now I want to use a database(sqlite), from that database I need to fetch the data and insert that data into table. please help me.

Thanks in advance.

look for tutorials using Core Data and NSFetchedResultsController — Calin Chitu, Oct 24 '13 at 09:58
thank you..can you help with simple code for fetching and inserting dat into tableview — rakesh, Oct 24 '13 at 10:02
i serched in google but dint find related posts anywhere for fetching and inserting data into tableview please helpme — rakesh, Oct 24 '13 at 10:03
just read apple's documentation - Core Data Programming Guide — Jing, Oct 24 '13 at 10:04
all the answers are useful to me in someway...but your answer is exact to my question — rakesh, Oct 24 '13 at 10:43

score 5 · Accepted Answer · edited May 23 '17 at 12:32

If you are beginner for sqlite and want to learn it then go to below links.

1)Database in IOS Sqlite3 and db

2)http://www.apptite.be/tutorial_ios_sqlite.php

3)http://maniacdev.com/2011/11/tutorial-easy-ios-databases-with-sqlite-and-fmdb

I also suggest you to learn FMDB (wrapper for sqlite).

EDIT:

Suppose you have database which stores the data of students then first of all fetch those data in the corresponding arrays like,

sqlite3_stmt *statement;

NSString *selectSQL = @"SELECT * FROM student";

const char *insert_stmt = [selectSQL UTF8String];
if(sqlite3_prepare_v2(studentData, insert_stmt,  -1, &statement, NULL) == SQLITE_OK)
{
    while(sqlite3_step(statement) == SQLITE_ROW)
    {

        [arrFirstName addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(statement, 0)]];

        [arrMiddleName addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(statement, 1)]];

        [arrLastName addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(statement, 2)]];

        [arrContactNo addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(statement, 3)]];

    }

}
[tblStudent reloadData];
}

Suppose You have table named "tblStudent" then your data source methods will look like this

  -(NSInteger)numberOfSectionsInTableView:(UITableView *)tableView
  {
      return 1;
  }

  -(NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
  {
        return [arrFirstName count];
  }

  -(UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath
  {
         UITableViewCell *cell = [[UITableViewCell alloc]initWithStyle:UITableViewCellStyleDefault reuseIdentifier:@"myCell"];
         cell.textLabel.text = [NSString stringWithFormat:@"%@ %@",[arrFirstName  objectAtIndex:indexPath.row],[arrLastName objectAtIndex:indexPath.row]];
         cell.accessoryType = UITableViewCellAccessoryDisclosureIndicator;
         return cell;
  }

how to populate data into UItableView by fetching data from database in ios

1 Answers1