DataGridView Combobox full example?

Looked all over and cannot find full examples on how to set up a column in a DataGridView to be a combo box? Vb.Net if anybody has it.

Also would like to set it up in the code behind hopefully that is possible?

Wisej Web Page

Questions

Hi Edward,

I have attached a modified version of the sample that shows how to use a DataGridViewComboBoxColumn as you described.

We have a plethora of resources, you can find more samples here: Wisej – Samples and you can always refer to our documentation here : Wisej – Documentation.

And to answer your question, you can definitely setup a DataGridView in codeand then add the ComboBoxColumn.

HTH,
Alaa

Attachment

- Edward Willis
- May 13, 2022 - 10:46 pm
So I followed your example and the combobox shows in edit mode and the dropdown shows the values, how do I display a value in non edit mode? How does the value that is in the datagridview for this column get set for combobox column I guess is what I am asking?
- Luca (ITG)
- May 13, 2022 - 11:21 pm
The values go to the cells. It’s a datagridview very similar to winforms datagridview. Can be be data bound or. not data bound. Try RowCount=10 and grid[col,row]Value=“value” or SetCellValue() or grid.Rows[r].Cells[c].Value=value. For a databound grid simply assign the DataSource property.

Hi Edward,

The doc for usage of DatagridView and DataGridViewComboBoxColumn is there : https://docs.wisej.com/docs/controls/lists/datagridview/comboboxcolumn

I attached a sample for simple usage of DataGridViewComboBoxColumn.

Best,

Kevin(ITG)

Attachment

- Edward Willis
- May 13, 2022 - 9:58 pm
Do you have a full sample with a web page this one is a window? Is it possible to setup a DataGridView in code behind and then add a combobox to a column in code behind? My code: Dim query As String query = “SELECT *” query += ” FROM [dbo].[Tournament]” Dim selectcommand As New SqlCommand(query, connection) tournamentinfoadapter.SelectCommand = selectcommand Dim mycommandbuilder1 As New SqlCommandBuilder(tournamentinfoadapter) ‘Set update command tournamentinfoadapter.UpdateCommand = mycommandbuilder1.GetUpdateCommand() tournamentinfoadapter.UpdateCommand.Connection = connection ‘ Set Delete command tournamentinfoadapter.DeleteCommand = mycommandbuilder1.GetDeleteCommand() tournamentinfoadapter.DeleteCommand.Connection = connection ‘ Set Insert Command tournamentinfoadapter.InsertCommand = mycommandbuilder1.GetInsertCommand() tournamentinfoadapter.InsertCommand.Connection = connection ‘ Fill dataset tournamentinfoadapter.Fill(dt_tournament) tourDataGridView.DataSource = dt_tournament tourDataGridView.Rows(0).Selected = True dt_tournament.PrimaryKey = New DataColumn() {dt_tournament.Columns(“tournament_id”)}

Your Answer

Please login first to submit.