Results 1 to 7 of 7

Thread: Anyone?? Stored Procedure Parameter Not Supplied

Threaded View

  1. Oct 20th, 2005, 03:07 PM #1
    Aspnot
    Aspnot is offline

    Thread Starter
    Fanatic Member
    Join Date
    May 2003
    Posts
    758

    Anyone?? Stored Procedure Parameter Not Supplied

    I have a typed DataSet with say 50 fields in it. On the form, I only show 40. I have a stored procedure that takes in all 50 parameters. When I call SqlDataAdapter.Update(ds.Tables(0).GetChanges(DataRowState.Modified)), I get a SQL error back that Procedure XYZ is expecting Parameter '@myParameter' which was not supplied.

    In looking at Profiler, I can see that this parameter is being passed to SQL Server as Default, not as the value that the field has in the Original DataSet.

    Any suggestions?

    - I know that I can set the Default values inside of SQL Server, but that isn't going to work for this situation.

    Thanks in advance
    Last edited by Aspnot; Oct 27th, 2005 at 09:17 AM. Reason: Change Title
    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