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

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