The UITableViewDataSource protocol has two required methods. This section implements one of those methods, namely, the tableView:numberOfRowsInSection: method. The table view has a single section: a list of names. Therefore, this method simply returns the count of the rows in the database. Use the following SQL statement:

    SELECT COUNT (*) FROM Names;

Add the following method to the DataAccess.mm implementation file to get the count:

- (NSInteger)tableView:(UITableView *)tableView 
 numberOfRowsInSection:(NSInteger)section {
    const char *            COUNT = "SELECT COUNT (*) FROM Names";
    ULPreparedStatement *    prepStmt = connection->PrepareStatement(COUNT);
    
    if (prepStmt) {
        ULResultSet    *resultSet = prepStmt->ExecuteQuery();
        int            numberOfNames;
        
        resultSet->First();
        numberOfNames = resultSet->GetInt(1);
        resultSet->Close();
        prepStmt->Close();
        return numberOfNames;
    } else {
        NSLog(@"Couldn't prepare COUNT.");
    }
    
    return 0;
}

The second required method in the protocol is the tableView:cellForRowAtIndexPath: method. This method is responsible for creating the actual cell objects that the table view displays. The RootViewController defines a good template to reuse cells. Table cells are usually recycled using the pattern in the template to save memory and allow for fast scrolling. The only identifier the table view provides is a 0-based integer index. However, the database does not normally keep an ordered list of the names. To simulate an ordered list, the database uses an ordered index on the names and the application uses a SELECT statement with a row limitation and an ORDER BY clause to select a given index. Although this method doesn't require the FOR UPDATE clause, this same query is used to delete names in Lesson 5: Deleting data from the database.

Add the following code to DataAccess.mm implementation file just below the import statements:

#define SELECT_STMT @"SELECT TOP 1 START AT %d name FROM Names ORDER BY name FOR UPDATE"

To use this query in the method, add the following to the DataAccess.mm implementation file.

- (UITableViewCell *)tableView:(UITableView *)tableView 
         cellForRowAtIndexPath:(NSIndexPath *)indexPath {
    static NSString *        CellIdentifier = @"Cell";
    UITableViewCell *        cell = 
     [tableView dequeueReusableCellWithIdentifier: CellIdentifier];
    ULPreparedStatement *    prepStmt;
    
    if (cell == nil) {
        cell = [[[UITableViewCell alloc] 
                 initWithStyle:UITableViewCellStyleDefault 
                 reuseIdentifier:CellIdentifier] 
                 autorelease];
    }
    
    // Make it so the cell cannot be selected. 
    cell.selectionStyle = UITableViewCellSelectionStyleNone;
    
    // +1 to the index since the DB uses a 1-based index rather than 0-based 
    prepStmt = connection->PrepareStatement(
        [[NSString stringWithFormat:SELECT_STMT, indexPath.row + 1] UTF8String]);
    if (prepStmt) {
        ULResultSet *    resultSet = prepStmt->ExecuteQuery();
        char            name[255];
        
        resultSet->First();
        resultSet->GetString("name", name, 255);
        resultSet->Close();
        prepStmt->Close();
        cell.textLabel.text = [NSString stringWithUTF8String:name];
    } else {
        NSLog(@"Couldn't prepare SELECT with index.");
    }
    
    return cell;
}

Now that the DataAccess object is configured as a data source, you need to set the data source of the table. To do this, add the following at the end of the viewDidLoad method of the RootViewController class (in RootViewController.m):

    // Set the data source. 
    [self.tableView setDataSource:[DataAccess sharedInstance]];    

You also need to uncomment the viewWillAppear method and add the following statement (otherwise changes are not picked up until the rows scroll out of view and back in again):

    [self.tableView reloadData];

At this point you should build the application to test that it builds without errors. From the Build menu, click Build and run. The application is now able to display names from the database, and the user is able to add new names using a custom view.