Hi All,
Is there a way to specify display value and actual (data) value for a DataGridViewComboBoxColumn
For example, my database table has a column account_type of type NCHAR(1), which is used to store either 'C' for Credit or 'D' for debit. When the data records are retrieved from the table and displayed on a DataGridViewComboBoxColumn cell, I want it to be displayed as "Credit" or "Debit" respectively. Vise-versa, when users add a new record, they should be able to select Credit or Debit from the combo box, but the actual data to be saved should be 'C' or 'D' respectively.
Thanks in advance