Data Access in Client and Middle-Tier Programming

Displaying Data on Forms in Windows Applications

Display data to users by dragging items from the Data Sources Window [ http://msdn.microsoft.com/en-us/library/6ckyxa83(VS.80).aspx ] onto Windows Forms, or by selecting a new or existing data source from the smart tag on certain controls, such as the DataGridView [ http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview(VS.80).aspx ] and ComboBox [ http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox(VS.80).aspx ] . The following topics describe the processes and tasks related to presenting data to users in data-bound controls on Windows Forms.

In This Section

Displaying Data Overview [ http://msdn.microsoft.com/en-us/library/2b4be09b(VS.80).aspx ]: Describes the process of displaying data on Windows Forms.

Data Sources Window [ http://msdn.microsoft.com/en-us/library/6ckyxa83(VS.80).aspx ]: Describes how to create data-bound forms by dragging items from the Data Sources window.

How to: Bind Data to Existing Controls [ http://msdn.microsoft.com/en-us/library/13ae95wb(VS.80).aspx ]: Describes how to bind an existing control to a specific field of data.

How to: Create Lookup Tables [ http://msdn.microsoft.com/en-us/library/ms233685(VS.80).aspx ]: Describes how to display data from one table based on the data selected in another table.

How to: Customize How Visual Studio Creates Captions for Data-bound Controls [ http://msdn.microsoft.com/en-us/library/ms233769(VS.80).aspx ]: Describes how to control the behavior of the smart-captioning feature in the Data Sources window.

How to: Display Data in a Windows Forms DataGridView Control [ http://msdn.microsoft.com/en-us/library/071hftc7(VS.80).aspx ]: Describes how to present data in a DataGridView on a Windows Form.

How to: Display Data in Individual Windows Forms Controls [ http://msdn.microsoft.com/en-us/library/63h88ca4(VS.80).aspx ]: Describes how to present data in individual controls on a Windows Form.

How to: Display Related Data in a Windows Application [ http://msdn.microsoft.com/en-us/library/57tx3hhe(VS.80).aspx ]: Describes how to present data from related tables in a dataset on a Windows Form.

How to: Add a Parameterized Query to a Form in a Windows Application [ http://msdn.microsoft.com/en-us/library/aeez5k4f(VS.80).aspx ]: Describes how to modify an existing Windows Form to include controls to input parameters and execute a query.

How to: Display Pictures from a Database in Windows Forms [ http://msdn.microsoft.com/en-us/library/ms233764(VS.80).aspx ]: Describes how to set a column to use an image control to display images in a database.

How to: Set the Control to be Created when Dragging from the Data Sources Window [ http://msdn.microsoft.com/en-us/library/31ct733b(VS.80).aspx ]: Describes how to set the control that will be created when dragging items from the Data Sources window onto a Windows Form.

How to: Add Custom Controls to the Data Sources Window [ http://msdn.microsoft.com/en-us/library/5554bf3a(VS.80).aspx ]: Describes how to modify the list of controls available for items in the Data Sources window, and how to add custom controls to the list.

How to: Open the Data Sources Window [ http://msdn.microsoft.com/en-us/library/yft2c9ad(VS.80).aspx ]: Describes how to open the Data Sources window in the Visual Studio IDE.

Walkthrough: Displaying Data on a Form in a Windows Application [ http://msdn.microsoft.com/en-us/library/wwh8ka92(VS.80).aspx ]: Provides step-by-step details on querying data from a database and displaying the data on a Windows Form.

Walkthrough: Displaying Related Data on a Form in a Windows Application [ http://msdn.microsoft.com/en-us/library/803kw7az(VS.80).aspx ]: Provides step-by-step details on displaying data from two related tables and displaying the data on a Windows Form.

Walkthrough: Creating a Form to Search Data in a Windows Application [ http://msdn.microsoft.com/en-us/library/hbsty6z7(VS.80).aspx ]: Provides step-by-step details on creating a Windows Form that searches for records in a database based on values input by a user.

Walkthrough: Creating a Lookup Table [ http://msdn.microsoft.com/en-us/library/ms171924(VS.80).aspx ]: Provides step-by-step details on displaying data from one table based on the data selected in another table.

Walkthrough: Passing Data Between Forms in a Windows Application [ http://msdn.microsoft.com/en-us/library/ms171925(VS.80).aspx ]: Provides step-by-step details on passing values from one form to a second form in an application.

Walkthrough: Creating a User Control that Supports Simple Data Binding [ http://msdn.microsoft.com/en-us/library/ms171926(VS.80).aspx ]: Provides step-by-step details on creating a custom control that can be used in the Data Sources window.

Walkthrough: Creating a User Control that Supports Complex Data Binding [ http://msdn.microsoft.com/en-us/library/ms233813(VS.80).aspx ]: Provides step-by-step details on creating a custom control that can be used in the Data Sources window.

Walkthrough: Creating a User Control that Supports Lookup Databinding [ http://msdn.microsoft.com/en-us/library/ms233787(VS.80).aspx ]: Provides step-by-step details on creating a custom control that can be used in the Data Sources window.

Reference

BindingSource [ http://msdn.microsoft.com/en-us/library/system.windows.forms.bindingsource(VS.80).aspx ]: A BindingSource object provides methods for accessing an underlying data source.

BindingNavigator [ http://msdn.microsoft.com/en-us/library/system.windows.forms.bindingnavigator(VS.80).aspx ]: The BindingNavigator control represents a standardized way to navigate and manipulate data on a form.

DataGridView: The DataGridView control provides a customizable table for displaying data.

ADO.NET [ http://msdn.microsoft.com/en-us/library/e80y5yhx(VS.80).aspx ]: Describes the ADO.NET classes, which expose data-access services to the .NET programmer.

System.Data [ http://msdn.microsoft.com/en-us/library/system.data(VS.80).aspx ]: Describes the ADO.NET classes, which expose data-access services to the .NET programmer.

System.Transactions [ http://msdn.microsoft.com/en-us/library/system.transactions(VS.80).aspx ]: The System.Transactions namespace contains classes that allow you to write your own transactional application and resource manager.

Related Sections

BindingSource Component [ http://msdn.microsoft.com/en-us/library/h974h4y2(VS.80).aspx ]: Provides links to topics that explain and demonstrate how to use a BindingSource object.

BindingNavigator Control (Windows Forms) [ http://msdn.microsoft.com/en-us/library/b9y7cz6d(VS.80).aspx ]: Provides links to topics that explain and demonstrate how to use a BindingNavigator control.

Windows Forms Data Binding [ http://msdn.microsoft.com/en-us/library/ef2xyb33(VS.80).aspx ]: Provides links to topics that explain the concepts and tasks associated with manipulating data on Windows Forms.

Getting Started with Data Access [ http://msdn.microsoft.com/en-us/library/ms171883(VS.80).aspx ]: Provides links to topics on creating applications that work with data, using Visual Studio.

Connecting to Data in Visual Studio [ http://msdn.microsoft.com/en-us/library/ms171886(VS.80).aspx ]: Provides links to topics on connecting your application to data with design time tools, and ADO.NET connection objects, using Visual Studio.

Preparing Your Application to Receive Data [ http://msdn.microsoft.com/en-us/library/ms171895(VS.80).aspx ]: Provides links to topics explaining what datasets are, how to create new datasets, and how to create and edit the individual objects they are made of.

Fetching Data into Your Application [ http://msdn.microsoft.com/en-us/library/ms171918(VS.80).aspx ]: Provides links to topics describing how to load data into datasets, and how to execute SQL statements and stored procedures.

Editing Data in Your Application [ http://msdn.microsoft.com/en-us/library/ms171928(VS.80).aspx ]: Provides links to topics describing how to manipulate the data in the data tables of a dataset.

Validating Data [ http://msdn.microsoft.com/en-us/library/t3b36awf(VS.80).aspx ]: Provides links to topics describing how to add validation to a dataset during column and row changes.

Saving Data [ http://msdn.microsoft.com/en-us/library/ms171932(VS.80).aspx ]: Provides links to topics explaining how to send updated data from an application to the database.

Data Resources [ http://msdn.microsoft.com/en-us/library/ms171939(VS.80).aspx ]: Provides links to additional data related sections, including dialog boxes and data adapters.