datagridview not saving to access database
Hi guys,
My datagridview is displaying records from table in database.When I go to add a new record the 'pencil' icon does not appear so when I click on save button update to database table does not take place.
code behind save button is
BindingContext(TheatreBindingSource).EndCurrentEdit()
PatientTableAdapter.Update(TheatreDataSet)
PatientTableAdapter.Connection.Close()
i have spent all day trying to sort this ...any ideas and yes my theatrebindsource.allownew is set to true along with Enable adding, Editing, Deleting & column ordering all all ticked