DataGridView - Allow Editing on single column

Question

Hi All hopefully just a quick easy one here. I know there is a property on a datagridview whereby you can enable / disable editing for the whole grid. Is there a way to disable editing for the grid but still allow editing on ONE of the columns? A fairly simple fallback is to open an input box when the user clicks a cell that belongs to this column but id prefer to do it inside the grid if possible. Thanks all.

jin · Answer

foreach (DataGridViewColumn dc in dataGridViewX1.Columns) { if (dc.Index.Equals(0)) { dc.ReadOnly = false; } else { dc.ReadOnly = true; } }

Andrew · Answer

Slight amendment to my last post........ Putting the check on the mouseEnter event of a cell worked better. Thanks all.

Andrew · Answer

Hi All i have found a solution to the problem but it wouldnt be my first choice so if anyone can think of a better way im still open to sugestions. On the cellClick event of the DataGridView i check what column the cell belongs to. If its the column i want to be editable i enable the whole gridview otherwise i set the whole gridview to read only. Private Sub dgExpectedAmounts_CellContentClick( ByVal sender As System.Object ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgExpectedAmounts.CellContentClick If e.ColumnIndex = 3 Then dgExpectedAmounts.ReadOnly = False Else dgExpectedAmounts.ReadOnly = True End If End Sub

Andrew · Answer

Hi Sam thanks for your reply. I thought that may also be an option but whether i set ReadOnly on the individual columns to true or false it is overridden by the flag on the datagridview as a whole. I should have mentioned also that im populating the datagridview using sql and databind (so i tried setting each columns read-only property in code since i cant access through the usual properties window).

Sam Hobbs · Answer

Well let's see. Does the DataGridViewColumn class have a ReadOnly Property ? I see one. So it seems to me that the worst case is that you set each column to ReadOnly except one.