How to populate SfDataGrid using a sqlite database that already existed in the Windows file system?

In this article, we will show you how to populate .NET MAUI DataGrid using a sqlite database that already existed in the Windows file system.

Xaml

<ContentPage.BindingContext>
    <local:ProductsViewModel x:Name="viewModel" />
</ContentPage.BindingContext>

<syncfusion:SfDataGrid ItemsSource="{Binding Products}"
                       ColumnWidthMode="Auto"
                       GridLinesVisibility="Both"
                       HeaderGridLinesVisibility="Both" />

DatabaseService.cs file

The below code demonstrates how to handle database operations in a .NET MAUI application using SQLite asynchronously.

public class DatabaseService
{
    private readonly SQLiteAsyncConnection _database;
    private readonly string _dbPath;

    public DatabaseService()
    {
         // NOTE: Don't forget to update the database path to match your machine's directory.
        _dbPath = @"D:\Support\MarchSupport\703516\products.db";

        // Check if file exists before connecting
        if (!File.Exists(_dbPath))
        {
            throw new FileNotFoundException($"Database file not found at {_dbPath}");
        }

        _database = new SQLiteAsyncConnection(_dbPath);
    }

    public async Task<List<Products>> GetProductsAsync()
    {
        return await _database.Table<Products>().ToListAsync();
    }
}

ProductViewModel.cs file

This ProductsViewModel class is responsible for managing and displaying product data in a UI using the MVVM pattern.

public class ProductsViewModel
{
    public ObservableCollection<Products> Products { get; set; } = new();

    private readonly DatabaseService _databaseService;

    public ProductsViewModel()
    {
        _databaseService = new DatabaseService();
        LoadData();
    }

    private async void LoadData()
    {
        var items = await _databaseService.GetProductsAsync();
        foreach (var item in items)
        {
            Products.Add(item);
        }
    }
}

View sample in GitHub

Take a moment to explore this documentation, where you can find more information about Syncfusion .NET MAUI DataGrid (SfDataGrid) with code examples. Please refer to this link to learn about the essential features of Syncfusion .NET MAUI DataGrid (SfDataGrid).

Conclusion

I hope you enjoyed learning about how to populate SfDataGrid using a sqlite database that already existed in the Windows file system.

You can refer to our .NET MAUI DataGrid’s feature tour page to learn about its other groundbreaking feature representations. You can also explore our .NET MAUI DataGrid Documentation to understand how to present and manipulate data.
For current customers, you can check out our .NET MAUI components on the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to explore our .NET MAUI DataGrid and other .NET MAUI components.

If you have any queries or require clarifications, please let us know in the comments below. You can also contact us through our support forums, Direct-Trac or feedback portal, or the feedback portal. We are always happy to assist you!