olga kelly

olga kelly

  • NA
  • 1
  • 0

datagridview not saving to access database

Feb 10 2010 5:17 AM
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

Answers (1)