how to show the NSData value in UIImage View while retrieving the database

Vote count:

0

Added the images as NSData in database successfully. But while i'm retrieving back NSData to UIImage its not working. The following codings that i used for retrieving the database any error please suggest me.

Here i used primary key to fetch correct image presented in particular record:

-(void)ShowImagesinImageView{

    NSLog(@"Loaded in productlist");
    NSLog(@"Primary Key of Expenses ID=%@",primarykeyID);

    proID      = [[NSMutableArray alloc] init];
    NSInteger proeditid = [primarykeyID integerValue];
    int len = 0;

    NSString *queryStr = [NSString stringWithFormat:@"select image from selection_tbl where expenses_id=?"];
    Dataware *dbsql    = [[Dataware alloc] initDataware];
    sqlite3_stmt *sqlStmt=[dbsql OpenSQL:[queryStr UTF8String]];

    Dataware *DB = [[Dataware alloc]initDataware];
    sqlite3_stmt *stmt=[DB OpenSQL:[queryStr UTF8String]];
    if(sqlStmt != nil)
        while(sqlite3_step(sqlStmt) == SQLITE_ROW)
        {
            len = sqlite3_column_bytes(stmt, 0);
            NSData *imagData = [[NSData alloc] initWithBytes: sqlite3_column_blob(stmt, 0) length: len];

            sqlite3_bind_int(stmt,1, (int)proeditid);

            UIImage *img = [[UIImage alloc] initWithData:imagData];
            imageView.image = img;

        }
    [dbsql CloseSQL];

    [tblview reloadData];

}

asked 47 secs ago

Karthik Pandian

10

how to show the NSData value in UIImage View while retrieving the database