how to add data from sqlite in UITableView?

Question

hai guys,

I new to the Objective C tech. i need solution for my issue. i have one table in sqlite, in the sqlite table one record ("aaa","bbb","ccc") i want to display this record in one cell of the tableView. can any one help me please....

thanks in advance

Answer 1

Although I don't like to point people somewhere else than SO, go read here. You could start reading from the point where a sample cocoa touch app. is created and you have also some code, that helps you follow the steps.

As an alternative (again with source code) you can do also this other tutorial.

If you happen to like paper books I'd like to suggest this one. Chapter 26 contains exactly what you're are searching for (of course don't read the chapter alone if you're a beginner iOs developer). You can download the code for the book to explore that chapter, application: "Nayshunz".

Answer 2

for example you have the method for saving database in ur app +(nsmutablearray*)getalldata {

}

in ur tableviewfile add that array to some array as newarray=[database getalldata];

and in the cell of table view just write the code

cell.textlabel.text=[[newaaray objectatindex:indexpath.row]valueforkey@"abc"];

here you all set. now it depends upon you how u are accessing the array using the keys of dictionary Hope it would help you,if so please vote for me. thanks