DataGridView column type question

[newpat]

hello all,
I want to ask I have dropped the dataset and create a DataGridView, but how to change one of the specific column to combobox?
it is because something I just want user to select in combobox and update it to mysql database.

[karthikeyan]

dear friend,
please explain your need clearly, understandable. so that we can help you

[newpat]

As you can see the red pointer on pic, I want the user can select the position, but not type by himself

[karthikeyan]

dear friend,

use this code:

Private Sub DataGridView1_CellBeginEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellCancelEventArgs) Handles DataGridView1.CellBeginEdit
        If e.ColumnIndex = 3 AndAlso e.RowIndex = DataGridView1.Rows.Count - 1 Then
            e.Cancel = True
        End If
    End Sub

this works for me

[karthikeyan]

hey man,

follow this simple method:

 DataGridView1.DataSource = dt
        DataGridView1.Columns(3).ReadOnly = True

hope this helps

[newpat]

what are the different between them?

[jmcilhinney]

Neither of those code snippets are going to help you put a combo box in a DataGridview.

The thing is, you can't change the type of a column in a DataGridView. Once the column is created it is what it is. What you have to do is add a combo box column yourself. If you do it properly the grid will not create a text box column for that column from the data source.

In the designer you need to add a column to your grid and set its type appropriately. You then set its DataPropertyName property to the name of the data source column you want bound to it. In your case that's likely "Position". When you bind the data to the grid, instead of the grid creating a new column for that data it will bind it to the existing column.

Now, to populate the drop down list for each cell you need to bind a second data source directly to the column. You do that just as you do for a ComboBox control. You can either use its DataSource, DisplayMember and ValueMember properties or add directly to its Items collection.

[newpat]

I think the best way to solve the problem is that I can create a combobox outside the datagird view, when the user click on one of the "position" rows, the combobox which contain the hand-code item will automatically show out. Then the user select one of the item, the selecting rows will be changed to the selected item value.Would it be possible on VB code?

[stanav]

All you need to do is add a datagridviewcomboboxcolumn to your datagridview in design view. You then set those properties for that column:

DataSource = the datasource you want to use (i.e a bindingsource or a datatable)
DataPropertyName = the name of the column/field in your datasource you want for this column
ValueMember = the name of the column/field in your datasource that you want for selected values of the combobox.

Note that if you don't have a datasource until runtime, you'll have to set these properties in code.

[newpat]

ha, I have changed the column property from textbox to combobox, but it seem that doesn't allow me to do so. Do anyone thinks my method in #8 working?

[stanav]

Did you read post#7 and post#9?
You simply can't change the type of a datagridview column once it is created. So you have to create the column of your chosen type first, then tell it where to get the data from.

[newpat]

Did you read post#7 and post#9?
You simply can't change the type of a datagridview column once it is created. So you have to create the column of your chosen type first, then tell it where to get the data from.

I know
But I mean that there are external combobox which containing the hand code item, when the row is selected, then u select the item text in combobox, the text will auto-input into the selected row, I think this way can ignore the datatype of column because it is just a string.