Display bold letters in listview fetched from sqlite DB

Question

I have fetching data from sqlite database. What i want is to display with bold the "Name" of each of my products.

Here is the code:

    fullProductDetails = "<b>Name: </b>"+data.getString(1) + "| Price: " + data.getString(2) + "| Quantity: " + data.getString(3);

The problem is that it's displaying the "b" character instead of bold in my listview.

Update

Here is a bit more of code:

Cursor data = mDatabaseHelper.getData();
        ArrayList<String> listData = new ArrayList<>();
        while (data.moveToNext()) {
            //get the value from the database in column 1
            //then add it to the ArrayList
            totalPrice=Float.parseFloat(data.getString(2))*Float.parseFloat(data.getString(3));
            fullProductDetails = "<b>Name: </b>"+data.getString(1) + "| Price: " + data.getString(2) + "| Quantity: " + data.getString(3);
            listData.add(fullProductDetails+" <b>Total Price: </b>"+totalPrice);
        }

//create the list adapter and set the adapter
        ListAdapter adapter = new ArrayAdapter<>(this, android.R.layout.simple_list_item_1, listData);
        mListView.setAdapter(adapter);

Here is the screenshot. You can see two times "B" because i was testing something else. Ignore the second.

@Renis1235 I have made the update. Let me know if it's more clear for you! — Alex, Jun 02 '21 at 12:53
How do you add the elements to the list, can you include that one too? — Renis1235, Jun 02 '21 at 13:04

score 1 · Answer 1 · answered Jun 02 '21 at 13:05

1

HTML formatted text won't work for native non-web TextView in Android. or any other not-web-based framework/system...

you should format this text with Spans, this is recommended way with plenty of possibilities

BUT for your simple case (handling only bold <b> tag) you may use Html.fromHtml method

fullProductDetails = ...
Spanned fullProductDetailsSpanned = Html.fromHtml(fullProductDetails);
textView.setText(fullProductDetailsSpanned);

read carefully THIS (use compat method posted in answer) and THIS (only few tags are supported by this method, rest would be stripped out, but bold is on the list)

answered Jun 02 '21 at 13:05

snachmsm

17,866
3
32
74

Thank you for the answer! I don't have a textView to display these! I only have the listView! – Alex Jun 02 '21 at 13:11
`ListView` contains some list items and in your case these are `TextView`s, supplied by adapter you have set. if you have simple instance, e.g. `ArrayAdapter` then you may migrate to `ArrayAdapter` (and `ArrayList listData` also), but the best option would be to write own adapter or at least override `getView()` method – snachmsm Jun 02 '21 at 13:12

score 1 · Answer 2 · answered Jun 02 '21 at 13:06

Try this :

if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.N) {
    textView.setText(Html.fromHtml("<b>Name: </b>", Html.FROM_HTML_MODE_COMPACT));
} else { 
    textView.setText(Html.fromHtml("<b>Name: </b>"));
}

or directly:

textView.setText(Html.fromHtml("<b>Name: </b>"));

Display bold letters in listview fetched from sqlite DB

2 Answers2