1

In a .Net 5.0 WinForms project I have connected a DataGridView to an SQL Server table by the following objects:

SQL Server table
SQLDataAdapter
SQLCommandBuilder
DataTable
BindingSource
DataGridView

This setting allows reading and writing.

Now I would like to use this DataGridView for SQLite, too. But Microsoft.Data.Sqlite doesn't contain a DataAdapter (link), and System.Data.SQLite (link) seems not to be available for .NET 5.0.

Is this a fact that I have to accept or am I missing anything (hopefully)? Or is there another way to connect a DataGridView to SQLite for reading and writing without me spending months studying the underlying technologies? I'm a beginner, that's why I'm asking.

I've seen this post but the links refer to quite old stuff.

Thank you for any hints.

Stringeater
  • 170
  • 1
  • 9

0 Answers0