Previous article: Implementing UISearchBar in Table View 


We will continue where we finish our previous project, here we will implement code in CountryListViewController class to display country list. For the country list we are using sqlite database. We have a COUNTRY table in sqlite database, that we use to display country name with its country Code.

In CountryListViewController.h file we will import 'sqlite3.h' file. this file is responsible for creating SQLite database instance that we use in our application. 

Follow the steps:

1.    Select 'CountryListViewController' and implement following code into 'viewDidLoad' method(will will focus on important codes that we will use in our code):

// using this code we are checking, if the file is available on the selected databasePath then the condition will be true.

if([filemgr fileExistsAtPath: databasePath ] == YES)

// in this code countryDB is the reference of sqlite database. 'sqlite3_open' will open the database connection

if (sqlite3_open([databasePath UTF8String], & countryDB) == SQLITE_OK)


 // 'sqlite3_prepare_v2' is responsible for executing query in the sqlite database.   

if(sqlite3_prepare_v2(countryDB, select_stmt, -1,& stmt, NULL)==SQLITE_OK)


  // this while loop executes according to the no of rows in the selected table.

while(sqlite3_step(stmt) == SQLITE_ROW)

// this code is used to build the path to the database file         

databasePath = [[NSString alloc]initWithString:[docsDir stringByAppendingPathComponent: @"country.db"]


  // this code will fetch the second column value form the database table.

NSString *Name = [[NSString alloc] initWithUTF8String: (const char *) sqlite3_column_text(stmt,1)];

 // this will close the connection of sqlite database.


 2.    now, implement the 'numberOfSectionsInTableView:' delegate method of table view return value 1. because at this time we need only one section in our table view.

3.    now, implement the 'numberOfRowsInSection:' delegate method of table view, return the total rows needed in the table view, return like this:

return [countryRecords count];

4. now, implement the 'cellForRowAtIndexPath:' delegate method of table view, is responsible for creating cell and displaying data in each cell. In this method we will define a static identifier for each cell that is used to differentiate each cell from other section's cell. 


That's it,

our code implementation for displaying countries name is completed.

Now, click the 'Run' button of Xcode to run the application, after that click on 'Continue' button, next click on 'Search Country' button, now our 'CountryListViewController' will be open with the country list data that we are currently modified.(it will look like this):

Implementing Country List in TableView


Here is the source code:

CountryListViewController.h file

#import <UIKit/UIKit.h>

#import "sqlite3.h"


@interface CountryListViewController : UIViewController<UITableViewDataSource, UITableViewDelegate, UISearchDisplayDelegate, UISearchBarDelegate>


sqlite3 *countryDB;

sqlite3_stmt *stmt;

NSString *databasePath;

NSString *docsDir;

NSArray *dirPaths;

NSMutableArray *countryRecords;


@property (nonatomic,strong) NSArray *sectionTitles;

@property(nonatomic,strong) NSString *databasePath;

@property(nonatomic,strong) NSString *docsDir;

@property(nonatomic,strong) NSArray *dirPaths;

@property(nonatomic, retain) IBOutlet UITableView *tableView;

@property (nonatomic, retain) NSMutableArray *searchResults;



CountryListViewController.m file

#import "CountryListViewController.h"

#import "CountryListController.h"


@interface CountryListViewController ()<UISearchBarDelegate>



@implementation CountryListViewController

@synthesize databasePath,docsDir,dirPaths,sectionTitles;

@synthesize searchResults;


static NSString * const reuseIdentifier = @"Cell";


- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil


self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];

if (self) {

// Custom initialization


return self;



- (void)viewDidLoad


[super viewDidLoad];

// Do any additional setup after loading the view.



countryRecords = [[NSMutableArray alloc]init];

dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,

NSUserDomainMask, YES);

docsDir = [dirPaths objectAtIndex:0];


// Build the path to the database file

databasePath = [[NSString alloc]initWithString:

[docsDir stringByAppendingPathComponent: @"country.db"]];

NSFileManager *filemgr = [NSFileManager defaultManager];

if([filemgr fileExistsAtPath: databasePath ] == YES)


if (sqlite3_open([databasePath UTF8String],& countryDB) == SQLITE_OK)


NSString *selectSQL = [NSString stringWithFormat:


const char *select_stmt = [selectSQL UTF8String];

if(sqlite3_prepare_v2(countryDB, select_stmt, -1,& stmt, NULL)==SQLITE_OK)


while(sqlite3_step(stmt) == SQLITE_ROW)


long Id = sqlite3_column_int64(stmt, 0);

NSString *Name = [[NSString alloc] initWithUTF8String: (const char *)


NSString *Code = [[NSString alloc] initWithUTF8String: (const char *)


CountryListController *countryObj = [[CountryListController alloc] init];

[countryObj setCountryNameAndCode:Id andName:Name andCode:Code];

[countryRecords addObject:countryObj];






} else {

NSLog(@"File not Exist");


[self fetchSectionTitle];



- (void)fetchSectionTitle{

NSMutableSet *set = [[NSMutableSet alloc]init];

for(CountryListController *obj in countryRecords)


 [set addObject:[[obj CountryName] substringToIndex:1]];



sectionTitles = [[set allObjects] sortedArrayUsingSelector:




// table delegate method used to count not of rows for each section

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section


return [countryRecords count];



// table delegate method used to set cell in each row with its values

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath


static NSString *simpleTableIdentifier = @"Cell";

UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:simpleTableIdentifier];

CountryListController *countryObj = [countryRecords objectAtIndex:indexPath.row];

cell.textLabel.text = countryObj.CountryName;

cell.detailTextLabel.text = countryObj.Code;

return cell;





[super viewWillAppear:animated];



- (void)didReceiveMemoryWarning


[super didReceiveMemoryWarning];

// Dispose of any resources that can be recreated.





Next we will learn how to create sections for displaying country name in ascending order in the table view: Implementing Sections in Country List in TableView

  Modified On Dec-14-2017 02:21:34 AM

Leave Comment