How to paint an image and a label with a database record?

ABloxity

I have a record in a table

and I want to paint the I like that I bring from that register with the idmegusta

LandLu

Do you use ListView or CollectionView to present these data?
Try to define a model class to access the table from the database. Maybe like:

public class Model
{
    public string idmegusta { set; get; }
    // ...
}

Then deserialize the records to a list of model. Binding the label's text to these properties will make it work.

ABloxity

@LandLu
If so I have my data model.
I am occupying an ObservableCollection.

ABloxity

@LandLu
Get the id, and I want to buy it so that the image of like and the text turns blue

LandLu

What do you mean about "so that the image of like and the text turns blue".
You want to change the text color when the user selected the item or these images couldn't be rendered correctly as you expected?

ABloxity

@LandLu
Yes, I want to load my list of publications, with the record I have of the likes with a publication the blue icon and the text in blue are loaded

LandLu

It seems you could load text and images successfully from the database. What's your question now?

ABloxity

@LandLu
how to do it, I bring the idmegusta record, to compare it and thus automatically paint the image and text

LandLu

I saw you had a Publicaciones model to access the records from the database. Then we could retrieve a list of this model for display. Bind your list's items source to this list then each item could use binding to display the information. Which part are you confused about?
If you want to know more about the construct of listview this documentation could be helpful:
https://docs.microsoft.com/en-us/xamarin/xamarin-forms/user-interface/listview/