Updating a datagridview with the value selected in a combo box
-
:)Hi. I have a form with various textboxes, comboboxes and a datagridview. The datagridview and textboxes are bound to the same datasource and if i enter information into either the textboxes or the datagridview the information is updated to the database correctly. The datatable that they are bound to is called "song". the problem I have is that I want the user to only be allowed to select specific "genres" that are stored in a "genre" table. so i want the combobox to display the values from this "genre" table and when he selects a value the datagridview "genre" field is updated for the "song" table. then later on i want the user to be able to select a genre(on a different form) and all songs per genre are listed. can anyone help me with this? Simple solution? thanks in advance Mr Oizo