Stuck with datagridview and combo box column

I have a typical requirement.

I have a datagridview with a combobox column(items loaded at design time). When a user selects an item from com开发者_运维技巧bobox, remaining rows gets updated in database based on the selectedItem and dgv gets refreshed.

Problem is the combo box will lose its current selection and goes to unselected state. I want to retain the selected item even after dgv refreshed.

Could anyone help me out

Thanks in advance

---

Do you mean that you're using an unbound comboboxcolumn? If so, the value can't automatically be persisted when refreshing the datasource. You need to store the selected value before updating and setting it in code after refresh.

If your column is actually databound, the selected value is either not stored in the database or you have some data type problem.

Is the combobox there to let the user select a value for the field or do you use it as a way to execute a command on the record?

Do you have any code you can post?

---

Datagrid Combo-Box value will retain the string value but will refresh any integer values automatically.

Here is what you need to do :

-When populating Combo-Box value to just convert its value to toString(). -Also if you are setting a default select value also set it with string type.

-Your Combo-box will automatically retain the value selected even after refreshing.

:)

---

have a combobox in ur datagridview. Assign values to it using a bindingsource. then write an eventhandler for the datagridviews "EditingControlShowing" event. in that, remove had handler if any exists for the comboboxes Selectedindexchanged event. then add an event handler for the selectedIndexChanged event say "ComboBoxValueChanged"

in that "ComboBoxValueChanged", DirectCast the sender to System.Windows.Forms.DataGridViewComboBoxEditingControl and get the selected value of it. Now use it to compute any value you want.

you may wana refer to this http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcomboboxeditingcontrol.aspx