SQLITE3, GtkTreeView and C problem !
Hello friends,
The below given code is not appending values to the treeview. Please help:
Code:
void
populate_list()
{
GtkTreeIter iter;
ledger_store = gtk_list_store_new (9, G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING,
G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING, G_TYPE_STRING);
exec_sql ("select * from ledgers", 10000);
while (sqlite3_step (Database.result) == SQLITE_ROW)
{
gtk_list_store_append (ledger_store, &iter);
gtk_list_store_set (ledger_store, &iter,
COL_DEMANDNO, sqlite3_column_text (Database.result, 0),
COL_CENSUSNO, sqlite3_column_text (Database.result, 1),
COL_YEAR, sqlite3_column_text (Database.result, 2),
COL_NAME, sqlite3_column_text (Database.result, 3),
COL_CASTE, sqlite3_column_text (Database.result, 4),
COL_ADDRESS, sqlite3_column_text (Database.result, 5),
COL_MOBILENO, sqlite3_column_text (Database.result, 6),
COL_STREET, sqlite3_column_text (Database.result, 7),
-1);
}
sqlite3_finalize (Database.result);
}
One more thing how can I modify this code so that it can accept large amount of data like 30000+ entries.