-1

I am a new guy for Android.

I create a SQLite database with one table.

That table fields are CheckList_Name(TEXT),CheckList_Image(Image),CheckList_STATUS(Int).

I can able to store all values into database as well as retrieve all data using query.

now my problem was i want to display all table values into one listview.

like...

enter image description here

It's possible. Please help me.

Thanks in advance.

selvam
  • 1,183
  • 3
  • 18
  • 39

2 Answers2

1

If you can store and retrieve all the data then this shouldn't be a problem. Have a look at this post. What you need to do is store your images as a blob. Then when you retrieve your image you just convert the blob to a bitmap and display that in your ListView.

I don't know how you're displaying your ListView but you would access your database and retrive the data you need in your Adapter. This would then be used to set values for the list items as they are retrieved.

Community
  • 1
  • 1
Rarw
  • 7,565
  • 3
  • 27
  • 45
  • I want to display all table values in listview with multiple column. – selvam Oct 22 '13 at 13:22
  • You can layout the individual list items how ever you want. Each item could be a row of your table. What are you having difficulty with. – Rarw Oct 22 '13 at 17:15
0

By default, in Android you don't have the Listview in the way you've described it; you should probably implement a custom adapter for a DataGridView. Another thing - it is better to keep your images on the flash disk and only have their names in the database. Also, you may want to take into consideration that loading those images in the DataGrid/ListView needs to be done in a separate thread, otherwise when scrolling you'll get the "lag" effect.

Marius M
  • 496
  • 8
  • 15