CODING

One of requests you could get to implement in an application is to know when a user selects an item in the Combobox editing control in a DataGridView.

{mobile_block=responsive_ad_2_300_250}

ComboBox control on the from has the SelectedIndexChanged event. However, in the DataGridViewComboBox there is the DataGridView.EditingControlShowing event.

Here is the code example that demonstrates how to achieve this. Consider also, that this example shows you how to prevent firing multiple SelectedIndexChanged events.

Microsoft SQL Server provides two methods for obtaining meta data: system stored procedures or information schema views.

Here are the SQL snippets for getting meta information about a database table in SQL Server. These queries could provide answer to the following requests:

{mobile_block=responsive_ad_2_300_250}

There are situations when you need to handle some events that are provided by a cell's editing cotrol in a DataGridView.

This can be done in the following way:

- Handle the DataGridView.EditingControlShowing event

- Access the DataGridViewEditingControlShowingEventArgs.Control property in order to get the editing control for the cell. If the event you are interested is not based on the Control class, maybe you need to perform casting the control to a specific control type.

By default, text box columns in the DataGridView control have automatic sorting, in contrary to other column types that don't use automatically sorting.

In order to change default sorting behavior of a column in the DataGridView control you can use the SortMode property.

This property determines a column's sorting behavior so you are able easily to change it.

{mobile_block=responsive_ad_2_300_250}

There are situation when you would like to show only some of the columns that are available in a DataGridView on your form. E.g. a DataGridView could display contact information to system administrators, but for every other user else these information would be hidden.

{mobile_block=responsive_ad_728_90}

How to hide a column programmatically

The Visible property of the column in the DataGridView control determines if the column can be displayed or not.

In order to hide a column in the designer following the steps below: