Blog

The DataGridView controls doesn't have enabled drag and drop reordering rows by default. However, here is the code that you use in the future in your projects in order to implement rows reordering with drag and drop.

{mobile_block=responsive_ad_2_300_250}

In order to make this example to work you need to have a DataGridView control added to your form with a name dataGridView1 and AllowDrop property of the DataGridView set to "true". Also, the necessary events need to be hooked up to the appropriate event handlers.

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}