Add GridViewComboBoxColumn to exisiting column

[Won]

Hi! 

I am trying to implement GridViewComboBoxColumn on gridview for existing"DEPARTMENT_ID"

colum.

I tried below and it works fine, but it is adding another column on the gridview instead of replacing existing "DEPARTMENT_ID" column.

1. What should I change?

2. What property will remove a scroll bar on GridViewComboBoxColumn?

 

 With Me.rgvEmployee

            .Columns("EMP_ID").HeaderText = "EMP ID"

            Dim deptComboboxColumn As GridViewComboBoxColumn = New GridViewComboBoxColumn

            With deptComboboxColumn

                .UniqueName = "DeptColumn"

                .HeaderText = "Dept"

                .DataSource = From q In db.MST_DEPARTMENT _

                              Select q.DEPARTMENT_ID, q.DEPARTMENT_NM

                .ValueMember = "DEPARTMENT_ID"

                .DisplayMember = "DEPARTMENT_NM"

                .FieldName = "DEPARTMENT_ID"

                .Width = 200

            End With

            Me.rgvEmployee.Columns.Add(deptComboboxColumn)

        End With

[Emanuel Varga]

Hello Won,

1. The behavior you are describing is the normal behavior, you should just call .IsVisible = false; on the "old" "DEPARTMENT_ID" column, on the DataBindingComplete event;

2. Scroll bar in the combo's dropdown? or in the grid itself?

Hope this helps, if you have any more questions please do not hesitate to say so,

Best Regards,
Emanuel Varga

[Won]

Emanuel. 

1. The behavior you are describing is the normal behavior, you should just call .IsVisible = false; on the "old" "DEPARTMENT_ID" column, on the DataBindingComplete event;
--> I knew that way, but the reason that I ask you is the added GridViewComboBoxColumn always goes to last. How do I move it to certain column? Let's say I want it to be 2nd column. 

2. Scroll bar in the combo's dropdown? or in the grid itself?
--> It worked with "Read only" property.

Lastly, I always appreciate for your answers.
Thanks.

[Emanuel Varga]

Hello Won,

On the DataBindingComplete, just use:
C#

radGridView1.Columns.Move(radGridView1.Columns["ColumnToMove"].Index, newIndex);

or vb, i think:

radGridView1.Columns.Move(radGridView1.Columns("ColumnToMove").Index, newIndex)

Glad to help in any way i can.

Best Regards,
Emanuel Varga

[Won]

Thanks. That works great.