I want to modify Datagridview column to combobox column.

See more:

VB

SQL

I have load data on my datagridview by using this command :

Public Sub loadRepairDG()
     Dim dtDGloadRepair

     conn = GetConnect()
     Try
         da = New SqlDataAdapter("SELECT * from V_RepairInv", conn)
         ds = New DataSet()
         da.Fill(ds, "V_RepairInv")
         dtDGloadRepair = ds.Tables("V_RepairInv")
         frmRepair.DataGridViewX1.DataSource = dtDGloadRepair
     Catch ex As Exception
         MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly, "Error conection!!")
     End Try
     conn.Close()
 End Sub

This above code, works fine. But then I want to modify the datagrid columns to combobox. Transform it into more dynamic grid.

Some forum I've read put code like this:

DatagridviewComboColumn.column.Add("1")

But it adds column, I want to modify current column from textbox to combobox.
How can i possibly do that. And also is it possible to link the grid combobox to other table while the grid is linked to other one?