ADO.NET 3.5 Cookbook, 2nd Edition

8.14. Binding Data to a Windows Forms DataGridView Control

Problem

You need to bind a result set to a tabular Windows Form control.

Solution

Use the DataGridView control as shown in this solution.

Follow these steps:

1. Create a C# Windows Forms application named BindWindowsFormDataGridView.

2. Add the following control to the Form1 design surface:

   • DataGridView named contactDataGridView

   The completed layout of the Windows Form named Form1 is shown in Figure 8-27.

   

   Figure 8-27. Layout for Form1 in BindWindowsFormDataGridView solution

The C# code in Form1.cs in the project BindWindowsFormDataGridView is shown in Example 8-26. The code creates a DataTable that contains the top 50 records from the Person.Contact table in AdventureWorks and binds it to the DataGridView control named contactDataGridView by setting its DataSource property to the DataTable.

Example 8-26. File: Form1.cs for BindWindowsFormDataGridView solution

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace BindWindowsForm DataGridView { public partial class Form1 : Form { public Form1() { InitializeComponent(); // Configure the data grid view contactDataGridView.Anchor = AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Top | AnchorStyles.Bottom; contactDataGridView.ReadOnly = true; contactDataGridView.AllowUserToAddRows = false; contactDataGridView.AllowUserToDeleteRows = false; contactDataGridView.AutoSizeColumnsMode ...