How to show data in CollectionView from SQLite database in xamarin?

Question

I want to get url and some text from database to collection view and show picture with that label. How can i connect database data with CollectionView and show it?

There is my Model

public class Airplane
{
    [PrimaryKey]
    public int Id { get; set; }
    public string Plane { get; set; }
    public string Airline { get; set; }
    public string Livery { get; set; }
    public string Registration { get; set; }
    public string Airport { get; set; }
    public string Date { get; set; }
    public string Comment { get; set; }
    public string Url { get; set; }        
}

and there is XAML code

<Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="*"/>
        </Grid.RowDefinitions>
        <CollectionView>
            <CollectionView.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="100"/>
                            <ColumnDefinition Width="*"/>
                        </Grid.ColumnDefinitions>

                        <Image Source=""
                               HeightRequest="200"
                               Grid.Column="0"/>
                        <Label Text=""
                               Grid.Column="1"/>
                    </Grid>
                </DataTemplate>
            </CollectionView.ItemTemplate>
        </CollectionView>
    </Grid>

query the data from your db into an IEnumerable and use that as the ItemsSource for the CollectionView. There are numerous examples of how to do this. — Jason
– Jason, Commented Jan 8, 2021 at 14:37

Jason · Accepted Answer · 2021-01-08 14:52:23Z

1

get your data

var data = db.Table<Airplane>().ToList();

assign it to ItemsSource

myCollectionView.ItemsSource = data;

add binding expressions to your template

<Image Source="{Binding Url}" ... />
<Label Text="{Binding Plane}" ... />

answered Jan 8, 2021 at 14:52

Jason

89.5k15 gold badges137 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lukas Planespotter Over a year ago

I was searching for solution like this but i cant find it or i have asked badly, thanks @Jason

Collectives™ on Stack Overflow

How to show data in CollectionView from SQLite database in xamarin?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related