DataGridView Control in C#

Introduction

The DataGridView control available as a part of Windows Forms controls in Visual Studio 2008 is much more powerful than it's previous versions. This tutorial is a basic introduction of how to write a simple data driven application using Visual Studio 2008 wizards without writing a single line of code. In my next articles, I will talk about more detailed features of the DataGridView control.

The DataGridView control provides a powerful and flexible way to display data in a tabular format. You can use the DataGridView control to show read-only views of a small amount of data, or you can scale it to show editable views of very large sets of data. This control also let's you display data in a master-details view.

With the DataGridView control, you can display and edit tabular data from many different kinds of data sources. Binding data to the DataGridView control is straightforward and intuitive, and in many cases it is as simple as setting the DataSource property. When you bind to a data source that contains multiple lists or tables, set the DataMember property to a string that specifies the list or table to bind to.

The DataGridView control supports the standard Windows Forms data binding model, so it will bind to instances of classes described in the following list:

• Any class that implements the IList interface, including one-dimensional arrays.
  
• Any class that implements the IListSource interface, such as the DataTable and DataSet classes.
   
• Any class that implements the IBindingList interface, such as the BindingList<(Of <(T>)>) class.
  
• Any class that implements the IBindingListView interface, such as the BindingSource class.

OK let's get started. Follow these steps and you will see how to write a data driven application without writing a single line of code.

Step 1. Create a new Windows Forms Application project in Visual Studio 2008.



Figure 1.

Step 2. Drag and drop DataGridView control from toolbox to form window.



Figure 2.

Step 3. Now choose a data source by right clicking on the DataGridView and then click on Add Project Data Source. We will be adding a new data source to the project right now.



Figure 3.

Step 4. Now select data source type, I am choosing Database in this example.

After selecting Database, click next.



Figure 4

Step 5. Choose your data connection, if you already have a connection available select that, otherwise make new connection, and follow the steps and after that click next.



Figure 5.

Step 6. Add Connection Wizard.



Figure 6

Step 7. Choose you database objects, and click next, if you want local database caching then check enable local database caching check box and click next.

Figure 7.

Step 8. Select table for caching.



Figure 8.

Step 9. Now your data source is created, right click on DataGridView control and on the option Choose Data Source, select the data source you just created.



Figure 9.

That's all. You are all set.

• Database Table Update in a DataGridView without Writing Code 
• Bind Objects to a DataGridView Control
• Generic DataGridView
• Sorting with DataGridView using C#.
• Host a combo box column within a DataGridView control
• Creating a Context Menu on a DataGridView Mouse Click
• Import Data from Text and CSV file to DataGridView in .Net
• Printing the DataGridView
• Convert a DataGridView to a Bitmap
• How to : Add an autonumber column in a DataGridView
• Custom Time Cell in DataGridView