views:

38

answers:

0

i am using this

  -(void) Data

  {
   databaseName = @"List.sqlite";

  NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,     
      NSUserDomainMask, YES);
  NSString *documentsDir = [documentPaths objectAtIndex:0];
  databasePath =[documentsDir stringByAppendingPathComponent:databaseName];

  [self checkAndCreateDatabase];


  sqlite3 *database;
  if (sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
  {
    if(detailStmt == nil)
    {
        const char *sql = "Select item from list";          
        if(sqlite3_prepare_v2(database, sql, -1, &detailStmt, NULL) == SQLITE_OK)
        {               
            NSLog(@"Hiiiiiii");

            while(sqlite3_step(detailStmt) == SQLITE_ROW) 
            {
                NSLog(@"Helllloooooo");
                NSString *item= [NSString stringWithUTF8String:(char *)sqlite3_column_text(detailStmt, 0)];

                //item1=item;
                NSLog(@"%@",item);


            }
            sqlite3_reset(detailStmt);
        }
        sqlite3_finalize(detailStmt);
        sqlite3_clear_bindings(detailStmt);
    }
}
detailStmt = nil;
sqlite3_close(database);
}