Well when I press the update button which has the update method I then get the following exception:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

How do I check if I have read/write permissions on the database?, because I assumed I have since I can read the data when I use the fill method.

thanks