How to make the a combobox as part of the grid i.e. when i click on that particular cell it turns into a combo box with values from the database.

Data is retrieved from database and showed in the Grid. I want to add a combobox option to every row in the grid, so the end user can click on the cell to select the row ,based on the selected rows, to update other columns with corresponding data

I have no ideas to implement it. if it won't work, what should I do to select more data from grid ?

thanks any help.