C# DataGridView control, if the first column and second column are drop down lists, how can the second column use the first column as a condition to get the value from the database?
In C#, you can implement your requirement by adding code to the DataSourceChanged event handler of the DataGridView control.
Here’s how to do it:
In the DataSourceChanged event handler of the DataGridView control, add code to get the values of the first and second columns. For example:
Next, you can use these values as conditions to fetch values from the database. For example, if you are using ADO.NET to access the database, you can use the following code to do so:
I hope this information has been helpful.
What is the difference between dataGrid/DataGrid/DataGridView and DataGridView in different versions of winform in C#.net
The DataGridView control is a new control that replaces the DataGrid control. The DataGridView control provides many basic and advanced features not found in the DataGrid control. In addition, the structure of the DataGridView control makes it easier to extend and customize than the DataGrid control.
DataGridView Control Features
1 Multiple Column Types
2 Multiple Ways to Display Data
The DataGrid control is limited to displaying data from an external data source. The DataGridView control can display unbound data stored in the control, data from a bound data source, or both bound and unbound data. You can also implement virtual mode in the DataGridView control to provide customized data management.
3Multiple ways to customize data display
The DataGridView control provides a number of properties and events that you can use to specify how data is formatted and displayed. For example, you can change the appearance of cells, rows, and columns based on the data they contain, or replace data of one data type with its equivalent in another.
4 Multiple Options for Changing the Appearance and Behavior of Cells, Rows, Columns, and Headers
The DataGridView control lets you work with individual grid components in a variety of ways. For example, you can freeze rows and columns to prevent them from scrolling; hide rows, columns, and headers; change how rows, columns, and headers are resized; change how users make selections; and provide tooltips and shortcut menus for individual cells, rows, and columns.