C# DataGridView

Add the DataGridView control in Windows Forms. Use DataSource and CurrentCellAddress.

DataGridView. This Windows Forms control displays the contents of a data source. It uses a grid format. There are many ways to improve its default configuration. We show some improvements to usability and appearance.Controls

First, you should use DataGridView when you need to display information that is easily broken up into columns. This includes numbers, names, IDs and other attributes stored in a database (numbers and strings).

Tip: You can use the DataSource property to hook your DataGridView up to a database or an object collection.

DataSource: The code sets the DataSource property to the results of another function, GetSearchResults.

DataSource

GetSearchResults: This method performs a custom search. This is custom code that will query a database for results.

Then: It fills a new DataTable. We can use an SqlDataAdapter to fill this DataTable object. The results appear in your DataGridView.

DataTable

Example that sets DataSource: C# /// <summary> /// Used to set up the data table when the user types a query. /// </summary> void BuildDataGrid() { dataGridView1.DataSource = GetSearchResults(queryStr); } /// <summary> /// Connect to the database. /// And then use an adapter to fill a DataTable. /// </summary> DataTable GetSearchResults(string queryStr) { // // Make a new DataTable. // DataTable table = new DataTable(); // // You will want to declare a new DataAdapter, // and then call its fill method on the DataTable. // return table; }

DataAdapter. In the .NET Framework, a DataAdapter class is an object that uses internal logic to take data from a database and into an object. You will need to add the database and SQL statements. These statements depend on the database.SqlDataAdapter

Objects. Here we use a collection with an implementation of IList, which is an interface shared by Lists and arrays. One great feature is that .NET will read the property names of your collection objects automatically.

So: Simply create a new List or array of objects, and set the DataSource to this.

List

Example that uses object collection: C# /// <summary> /// The test class for our example. /// </summary> class TestObject { public int OneValue { get; set; } public int TwoValue { get; set; } } void M() { TestObject test1 = new TestObject() { OneValue = 2, TwoValue = 3 }; List<TestObject> list = new List<TestObject>(); list.Add(test1); list.Add(test2); // Not shown in code dataGridView1.DataSource = list; }

Hide row headers. You can hide row headers in the DataGridView control by using the RowHeadersVisible property. When you create a new DataGridView, there will be ugly row headers with arrows in the leftmost column.

And: These aren't useful for many kinds of applications. Disable row headers by setting RowHeadersVisible to false.

Tip: This will provide the appearance in the screenshots, which is more streamlined.

Tabbing. You can make tabbing work in your DataGridView control by modifying the StandardTab property. This property lets you make sure that when your user tabs around your window, the tabbing events don't get stuck in the DataGridView.

Tip: Use StandardTab in the designer to make the tab key move out of the DataGridView and to the next control.

Add rows. You can add rows to the DataGridView by using the instance Add method in C# code. This method adds rows to the DataGridView programmatically. There is a collection called Rows on the DataGridView.

Rows: On the rows collection, there is a method called Add. But it is usually better to modify the DataSource.

Note: The code modifies the new row. Add will give us the index of the new row, so we can modify that row in-place.

ValueType: Every cell has a ValueType. If you want to specify a DateTime column, you can change it by assigning it to a type, using typeof.

DateTime Typeof, nameof

Example that adds rows: C# /// <summary> /// Shows example usage of Add method on Rows. /// </summary> void M() { // // n is the new index. The cells must also be accessed by an index. // In this example, there are four cells in each row. // int n = dataGridView1.Rows.Add(); dataGridView1.Rows[n].Cells[0].Value = title; dataGridView1.Rows[n].Cells[1].Value = dateTimeNow; // // The second cell is a date cell, use typeof(DateTime). // dataGridView1.Rows[n].Cells[1].ValueType = typeof(DateTime); dataGridView1.Rows[n].Cells[2].Value = wordCount; }

Users can add rows. With the DataGridView control, users can add rows to your program on their own if you do not disallow it. A separate article focuses on managing user-created data in the DataGridView.DataGridView Add Rows

Configure columns. You will find that Visual Studio provides dialogs that allow you to configure the columns in your DataGridView. Columns are used as templates for how your DataGridView renders columnar data.

But: They do not actually contain the data, just the rules for rendering it to the screen.

DataGridView Columns

Locate current cell. You can locate the current cell in your DataGridView by using the CurrentCellAddress property. It returns the cell coordinates, which are also called its location or Point. You can specify X or Y or both.

Here: We only take the Y coordinate of the current cell. The current cell is also the selected cell, which usually has a blue highlight.

Example that gets current cell: C# /// <summary> /// Shows example usage of how to get the current cell. /// </summary> void M() { // // Go from Y coordinate to a selected cell's value. // DateTime is just for this example, and the Cells[1] part just // takes the second cell for this example. // int yCoord = dataGridView1.CurrentCellAddress.Y; // You can get X if you need it. DateTime thisDate = (DateTime)dataGridView1.Rows[yCoord].Cells[1].Value; }

Double-clicks. We can use the CellDoubleClick event and check RowIndex. In the event handler for CellDoubleClick, call a method that handles the item. Note that you must check for e.RowIndex equals -1.

Tip: When RowIndex is -1, it indicates that the column headers were double-clicked and not a regular cell.

Example that handles double-clicking: C# void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { // // Do something on double click, except when on the header. // if (e.RowIndex == -1) { return; } ProceedOpen(); }

Events in Visual Studio. As a reminder, click on the DataGridView in the designer. Then look at the Property pane, which is usually on the right bottom corner. Next click on the lightning bolt and scroll down to the CellDoubleClick entry.

SelectionChanged. You can update your program's buttons instantly when the user selects a cell in the DataGridView. Here we need to listen for SelectionChanged and change controls based on the selection.

CurrentCellAddress: We can check for CurrentCellAddress to figure out what was selected and where the selection moved.

SelectionChanged: This is triggered whenever the selection changes in the DataGridView. You will want to change the display when the selection is moved.

RowCount: When RowCount is zero, then nothing is selected, and our user probably can't proceed in the window.

Example that uses SelectionChanged: C# void dataGridView1_SelectionChanged(object sender, EventArgs e) { // // When our selection changes, call the function SetupButtons // to make sure "openButton" is always in a valid state. // SetupButtons(); } /// <summary> /// Custom method that sets the Enabled property of a button. /// </summary> void SetupButtons() { // // Disable openButton when there are no items shown. // openButton.Enabled = (dataGridView1.RowCount > 0); }

Selection options. The DataGridView has many options for adjusting its selection features. One option I have used often is the MultiSelect property. More details on MultiSelect are next.

MultiSelect. The MultiSelect property influences selection behavior. When you create a new DataGridView, the user can select many cells at once. This is fine for some programs, but not for all. With MultiSelect, we can disable this feature.

First: Your program should have a DataGridView control. You need to add columns and rows to this control somehow.

Next: In Visual Studio, right-click on the DataGridView and select Properties. Then locate the MultiSelect property and change it to False.

MultiSelect False. When this property is set to false, only one piece of the DataGridView can be selected by the user at once. This can mean one row, one cell, or one column is selected.

Tip: In the screenshot, only one cell is selected because MultiSelect was set to False.

Thus: MultiSelect is a useful property on the DataGridView control. Most programs I have built have it set to False.

And: This is because the programs do not mutate multiple cells at once. The programs are fairly simple.

Expand columns. You can specify that the columns in your DataGridView should expand by setting Columns.AutoSizeMode to Fill. This causes the cells to expand to fill the horizontal area. Then, in the designer, set some cells to fixed or percentage width.

Tip: Just allow one column to fill up the remainder. You will need to do a bit of manual tweaking.

Alternating colors. It is also possible to configure your DataGridView so that the row colors alternate. This is useful for reducing errors caused by rows looking too similar to the program's users. Please check out the tutorial on rows and colors.DataGridView Colors

Appearance. You can improve the appearance of DataGridView with conditional code. In Windows Vista, DataGridView looks best without a border. But in Windows XP it looks best with one. We return the appropriate border attributes based on the OS.

Example that improves Vista appearance: C# public partial class Form1 : Form { public Form1() { InitializeComponent(); dataGridView1.ColumnHeadersBorderStyle = ProperColumnHeadersBorderStyle; } /// <summary> /// Remove the column header border in the Aero theme in Vista, /// but keep it for other themes such as standard and classic. /// </summary> static DataGridViewHeaderBorderStyle ProperColumnHeadersBorderStyle { get { return (SystemFonts.MessageBoxFont.Name == "Segoe UI") ? DataGridViewHeaderBorderStyle.None : DataGridViewHeaderBorderStyle.Raised; } } }

PreviewKeyDown. When your DataGridView handles events such as KeyDown, the PreviewKeyDown event can be used to filter some of these events, preventing incorrect behavior. This solves complex problems related to key input.PreviewKeyDown

Misc. Let's look at some miscellaneous tips related to the DataGridView control. These were useful to me at some point, but are not important or may not be ideal. If something is helpful, I will try to expand it.

SortGlyphDirection: You can use this to draw that glyph array image. Remember to remove the glyph arrow in ColumnHeaderMouseClick.

BackgroundColor: Setting this to "Window" often looks best. Looks professional when you adjust this.

SelectionMode: The FullRowSelect enum value looks the best when you are displaying simple result rows.

ColumnHeaderMouseClick: This event is used to capture when a header is clicked. Can be used with ColumnIndex.

ColumnIndex: Sometimes you may need to modify the direction of the sort glyph. You can check e.ColumnIndex on the event parameter.

List. It is possible to display a List in your DataGridView, even if the List does not display properly by assigning it to the DataSource directly. You can convert the List to a DataTable, which can then be displayed in the DataGridView.Convert List, DataTable

Summary. We improved the usability and appearance of the DataGridView in a program with these methods. DataGridView is ideal in the .NET Framework and C# language for viewing information from databases or object collections.

The Dev Codes

.Net

.NET Array Dictionary List String 2D Async DataTable Dates DateTime Enum File For Foreach Format IEnumerable If IndexOf Lambda LINQ Parse Path Process Property Regex Replace Sort Split Static StringBuilder Substring Switch Tuple

Java

Core Array ArrayList HashMap String 2D Cast Character Console Deque Duplicates File For Format HashSet If IndexOf Lambda Math ParseInt Process Random Regex Replace Sort Split StringBuilder Substring Switch Vector While

TheDeveloperBlog.com

C# DataGridView

Related Links:

.Net

Java

Related Links