Save data in a SQLite database with the original format and view those data again with that form format

by

This is not an answer as I’m not going to give you the prewritten code for a copy/paste.
You should figure it out on your own but I’ll give you an overview of what you have to do.

  1. Search how to create SQL database and learn it through youtube tutorials. Some videos.
  2. Learn SQL (some basics) to understand what are columns and rows and
    how to use them for storing data. See here.

  3. This way you’ll learn how to store database and retrieve some data from it.

  4. After learning(some basics, just 1-2 days), you’ll know how to insert data into listviews using adapters and in textviews.

Just an example – suppose you’ve populated the listview using your SQL database and you click on a list item named “Kash”, then you can transition to a new activity which will have the same layout of current activity( the layout you’ve posted here, just change every edittext to textview) and set text to every textview by using this example –

  • you should execute this raw query for every textview.
    suppose you want to take the name from the database where invoice name = “kash” then "select Name from table_name where invoice_name = "Kash";". Save the selected text to a string(ex -namestring) value or cursor and show this in textview of name as textviewName.setText(namestring);
  • Or you can use the same query for every textview as
    create an if condition where every condition compares to a textview and set a separate columnName for every separate textview.
    then the query can be "select "+ columnName +" from tableName where invoice_name = "+ listitemClicked;" and set this retrieved value to every respective textview.

This way you’ll have what you need. But as No-one on StackOverflow wants to serve you the code for no efforts or less efforts at all.

Remember, what you want is not a hard thing but you should do it on your own.

This information is more than enough to proceed.
I could’ve downvoted you and left but downvoting isn’t the solution.

More Related Contents:

  1. CursorOutofBoundsException Index -1 requested with size of 0
  2. Retrieve database or any other file from the Internal Storage using run-as
  3. Android column ‘_id’ does not exist?
  4. Custom filtering in Android using ArrayAdapter
  5. Recommended way / order to read data from a webservice, parse that data and insert it in a SQLite db
  6. Android ListView Divider
  7. How to implement getfilter() with custom adapter that extends baseadapter
  8. Xamarin.Forms ListView: Set the highlight color of a tapped item
  9. Replace one Fragment with another in ViewPager
  10. how to customize listview row android
  11. How can I insert image in a sqlite database
  12. Android Alternate row Colors in ListView
  13. Android – ListView – performItemClick
  14. ListView items are not clickable. why?
  15. android attaching multiple adapters to one adapter
  16. Listview itemclick not work
  17. Android save Checkbox State in ListView with Cursor Adapter
  18. Passing a List from one Activity to another
  19. Layout_width of a ListView
  20. Logcat error: “addView(View, LayoutParams) is not supported in AdapterView” in a ListView
  21. Sort listview with array adapter
  22. How to Overlap items in LinearLayoutManager – RecyclerView (like stacking cards)
  23. How to check database on not rooted android device
  24. Android ListView with delete button
  25. Remove the bottom divider of an android ListView
  26. Placing ViewPager as a row in ListView
  27. How to get selected list items from a Listview with checkBox and Custom Adapter?
  28. Recycling views in a listview, worth it?
  29. Android Click on listItem checks wrong checkbox
  30. Using custom simpleCursorAdapter

Leave a Comment