Query with Inner Join to Gridview (SQLite Visual Studio C#)



Query with Inner Join to Gridview (SQLite Visual Studio C#)

Query with Inner Join to Gridview (SQLite Visual Studio C#)

In this video we will cover how to add data to a gridview control using a query from a SQLite database in Visual Studio with C#.

Basic Steps:
Discuss Control DataSource and assignment to list.
Show Properties being assigned to interface method returns.
Walk through database queries:
Show data being queried in 3rd party software.
Explain nuances of the individual queries.
Emphasize nested classes.
Elaborate on details of the admin user.
Explain query reduction techniques
Caching data being queried
Reusing data from other queries

C# .NET
Windows Form Application
Visual Studio
Interface
field
Interface
Polymorphism
class objects
sqliteconnection
sqlitecommand
sqlitedatareader
SQL
SELECT
FROM
WHERE
JOIN ON
cache caching
gridview
datasource
addwithvalue