Results 1 to 1 of 1

Thread: Problem with DataAdapter.Update [EDITED]

  1. Nov 24th, 2004, 07:23 AM #1
    Dave Bleby
    Dave Bleby is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2003
    Posts
    79

    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 ), 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
    System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
    from the line
    VB Code:
    1. 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.
    Last edited by Dave Bleby; Nov 24th, 2004 at 08:09 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width