DataGridViewComboBoxColumn items get padded to database column size on insert

  • Thread starter Thread starter gmiller261
  • Start date Start date
G

gmiller261

Guest
I have a DataGridView with a ComboBoxColumn and three items. "MONTHLY", "WEEKLY" and "DAILY".

The Database column for that field is NVARCHAR(20)

I run the program and choose a value and then do a TableAdapter.Update().

Data is added but the ComboBoxColumn data in the database (SQL 2008) is 20 characters.

So when I try and "refill" the DataGridView the column data does not match the ComboBoxColumn items and it throws an exception.

Change/Update works fine.

Continue reading...
 
Back
Top