I've got a problem with my project... in short I've got a mysql db bond through a DataSet and BindingSource - if I'm editing like a user the gridview then all changes are commited to the db no problem...
But I need the user to responsibly change foreign keys - what I have done is: if the user doubleclicks on a foreign key cell a new form pops up with possible values, I can change the cell value to the new foreign ID by:
DataGridViewCell cell = dataGridView.CurrentCell;
cell.Value = (fk.getSelectedValue()).Value;
The grid refreshes and everything looks good but this change doesn't really go into the database... I've tried to modify the value through the DataSet but can't seem to get it right...
Any help on this one please? Or maybe somebody has a better idea how to change foreign keys?
Any suggestions appreciated.