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
Re: update data from datagridview to database
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)
Re: update data from datagridview to database
Hi Megalith
Enable adding, Editing, Deleting & column ordering all all ticked ...any other ideas?