[2008] How to make column 3 of datagridview that is bound to a datatable a combobox

[Nitesh]

Hi Guys,

I have a column that is either Incoming or Outgoing. How can I make those 2 choices available from a combobox in my bound datagridview. Please help me

[Nitesh]

Guys, I've gotten this far: I add another column and assign it the two values it can have, but how do I link it to my datatable value for CallType. Please help me.

 Dim comboboxcol As New DataGridViewComboBoxColumn

        Try
            Using con As New MySqlConnection(myConnStr)

                adapter = New MySqlDataAdapter("SELECT CallId,CallDate,UserComment,CallType FROM tblcall WHERE ifkpeopleid = " & Pid & ";", con)

                calltable.Clear()
                adapter.Fill(calltable)

                dgvCalls.DataSource = calltable
                comboboxcol.HeaderText = "Call Type"
                comboboxcol.Items.Add("Incoming")
                comboboxcol.Items.Add("Outgoing")
                dgvCalls.Columns.Add(comboboxcol)
                
            End Using

        Catch ex As Exception
            MsgBox(ex)


        End Try

[Nitesh]

yipee, I've added this code after adding my comboboxcolumn:

 comboboxcol.DataPropertyName = "CallType"

and it works. But I now have one column with calltype which is not a combo and 1 column which is a combo. How can I make column 3 the combo1