update data from datagridview to database

[TRUDY1]

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

[Megalith]

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)

[TRUDY1]

Hi Megalith

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