Windows Application Development and ADO.NET

Vocabulary flashcards covering core concepts of Windows Forms, event handling, SDI/MDI architectures, dialog boxes, ADO.NET components, SQL Server operations, validation, and configuration.

Windows Forms (WinForms)

A graphical user interface framework provided by .NET for developing Windows desktop applications with forms, controls, event handling, menus, dialog boxes, and database connectivity.

Form

The main window or basic visual component of a Windows Forms application that acts as a container for controls such as buttons, text boxes, and labels.

Control

A graphical element or object placed on a form to accept input, display information, or perform operations.

Event Handler

A block of C# code written to execute when a specific event occurs, taking the event sender and event arguments as parameters.

Event-Driven Programming

A programming approach in which code execution is determined by actions or occurrences (such as clicks, key presses, or form loading) rather than following a predetermined sequential flow.

MenuStrip

A Windows Forms control used to create menu bars that display structured lists of commands and options, such as File, Edit, and Help.

ContextMenuStrip

A Windows Forms control that creates a shortcut menu that generally appears when the user right-clicks a control.

Form Inheritance

An object-oriented programming feature allowing a newly created derived form to inherit the properties, methods, and controls of an existing base form.

Single Document Interface (SDI)

An application architecture in which the user works with one primary document window at a time within an application window.

Multiple Document Interface (MDI)

An application architecture that allows multiple child documents or forms to be displayed and managed inside a single parent window.

Modal Dialog Box

A dialog window displayed using the ShowDialog() method that blocks user interaction with other application windows until it is responded to and closed.

Modeless Dialog Box

A dialog window displayed using the Show() method that allows the user to continue interacting with other application windows while it remains open.

ADO.NET

ActiveX Data Objects .NET; a data-access technology provided by the .NET platform for connecting applications to databases, executing commands, and managing records.

.NET Data Provider

A set of ADO.NET classes (such as SqlConnection, SqlCommand, and SqlDataReader) that enables direct communication with a specific database system.

DataSet

An in-memory data storage container in ADO.NET that holds multiple DataTables, relationships, and constraints independently of an active database connection.

Connected Architecture

An ADO.NET data access model where the application maintains an open connection to the database while reading or manipulating data, such as when using SqlDataReader.

Disconnected Architecture

An ADO.NET data access model where data is fetched into memory structures such as a DataSet or DataTable, allowing the database connection to be closed during data use and modification.

Typed DataSet

A DataSet generated with a predefined schema that provides strongly typed access to tables, rows, and columns, enabling compile-time error checking and IntelliSense support.

DataAdapter

An ADO.NET component (such as SqlDataAdapter) that acts as a bridge to transfer data between a database and a DataSet or DataTable using retrieval and update commands.

Stored Procedure

A named collection of SQL statements saved within a database management system that can be executed repeatedly with or without parameters.

ExecuteNonQuery()

An ADO.NET method of SqlCommand used to run SQL commands (such as INSERT, UPDATE, or DELETE) that do not return a result set of rows.

ExecuteScalar()

An ADO.NET method of SqlCommand that executes a query and returns only the first column of the first row of the query's result set.

Connection String

A string containing parameters such as server name, database name, authentication mode, and credentials, defining how an application connects to a database.

Exception

An error or unexpected condition occurring during program execution that disrupts normal instruction flow.

finally Block

A C# exception handling construct that guarantees execution of cleanup code regardless of whether an exception occurs or is caught.

ErrorProvider

A Windows Forms component that displays a visual indicator icon next to a control when validation rules are not satisfied.

App.config

An XML configuration file used in .NET Framework applications to store operational parameters, such as database connection strings and application settings, separately from source code.