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

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

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.

Code:

---

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

---

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

Code:

---

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