Problem with DataAdapter.Update [EDITED]

Hello all,
I have a problem with an ASP.NET page (my first so no surprise I've got problems :bigyello: ), basically it displays a list of products in a datagrid from which the user can change the quantity that they want to order. The problem comes when I try to update the SQL server table, all I get is

Quote:

---

System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

---

from the line

VB Code:

SqlDataAdapter1.Update(DsCat1)

.
As far as I am aware there are sufficient permissions on the database.

[EDIT]
The table I am trying to update has a trigger on it and I think this is what is causing the problem, if I remove the trigger the update works.
I am still stumped though, could it be something to do with timeouts?
[EDIT]

Does any one have any ideas?

Many thanks,

Dave.