Query Data from Oracle Database with Visual Basic.NET

Abstract

This chapter provides a detailed description and discussion in how to use Visual Studio.NET 2019 tools and wizards to build simple but efficient database applications without touching complicated coding. It presents a deeper digging in how to develop advanced database applications using runtime objects and focuses only on the data query applications. A data query will be executed via a dynamic Oracle statement that is built during the configuration of each TableAdapter in the Data Source wizard. When building a Windows Forms App (.NET Framework) application that needs to interface to database, a powerful and simple way is to use the design tools and wizards provided by Visual Studio.NET. The chapter illustrates how to utilize design tools and wizards to build a data‐driven application using our project SelectWizard Project. The Language Integrated Query LINQ To DataSet method is an updated method provided by .NET Framework.