StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to assign from object to a cell in TableView?
text
Body
copied!<p>In my iphon app , I'm reading from sqlite db into NSMutableArray *sales and I want to assign the data in sales into a cell in TableView. How can I do it?</p> <p>Here is my code: In Controller:</p> <pre><code>- (UITableViewCell *) tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{ UITableViewCell *result = nil; if ([tableView isEqual:self.myTableView]){ static NSString *TableViewCellIdentifier = @"MyCells"; result = [tableView dequeueReusableCellWithIdentifier:TableViewCellIdentifier]; if (result == nil){ result = [[UITableViewCell alloc] initWithStyle: UITableViewCellStyleSubtitle reuseIdentifier:TableViewCellIdentifier]; } AppDelegate *appDelegate = ( AppDelegate *)[[UIApplication sharedApplication] delegate]; [appDelegate readSalesFromDatabase]; // ***here is where I'm trying to retrive the data*** // when I run the simulator, at this point I receive 'SIGABRT' =====> result = [sales objectAtIndex:indexPath.row]; } return result; } </code></pre> <p>In Delegate:</p> <pre><code>-(void) readSalesFromDatabase { if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) { // Setup the SQL Statement and compile it for faster access const char *sqlStatement = "select us.userID from UsersSale us order by us.saleID"; sqlite3_stmt *compiledStatement; if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) { // Loop through the results and add them to the feeds array while(sqlite3_step(compiledStatement) == SQLITE_ROW) { // Read the data from the result row NSInteger auserID = sqlite3_column_int(compiledStatement, 0); // Create a new Sale object with the data from the database SelectFromList *sfl = [[SelectFromList alloc] initWithName:auser]; // ***here is where I'm inserting the data to NSMutableArray *sales ** [selectFromListController.sales insertObject:sfl atIndex:count]; [sfl release]; } } // Release the compiled statement from memory sqlite3_finalize(compiledStatement); } sqlite3_close(database); </code></pre> <p>} @end</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload