C# DataGridViewAdd 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.
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.
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.
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.
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; }
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.
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; }
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.
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; }
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(); }
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); }
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
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.
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
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.
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.
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.
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.
© 2007-2022 sam allen.
see site info on the changelog.