update data from datagridview to 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

Trudy1

do you have editing enabled on the dgv in design mode? (if you click the DataGridView you will see a triangle in the top right of it)

Hi Megalith

Enable adding, Editing, Deleting & column ordering all all ticked ...any other ideas?