I've been working on figuring this one out for a while, Figured i'd see if anyone here knows..
I dragged and dropped my connection and had it create stored procedures for all my SELECT, INSERT, UPDATE, DELETE commands for the dataadapter. I've verified the changes do exisit in the dataset prior to running .update(ds), but it fails and says:
Procedure 'IndicatorsUpdateCommand' expects parameter '@ClientID', which was not
supplied.
This is caused because in profiler i see the command being run is:
exec [IndicatorsUpdateCommand] @ClientID = default, @casenum = default, @date = default, @QID = default, @Answer = 1, @Original_id = default, @Original_Answer = default, @Original_ClientID = default, @Original_QID = default, @Original_casenum = default, @Original_date = default, @id = default
Everything is default except what changed (@answer), but it should have the values that are in the dataset.
Anyone know why it's doing this and/or howto fix it?
Thanks.
I dragged and dropped my connection and had it create stored procedures for all my SELECT, INSERT, UPDATE, DELETE commands for the dataadapter. I've verified the changes do exisit in the dataset prior to running .update(ds), but it fails and says:
Procedure 'IndicatorsUpdateCommand' expects parameter '@ClientID', which was not
supplied.
This is caused because in profiler i see the command being run is:
exec [IndicatorsUpdateCommand] @ClientID = default, @casenum = default, @date = default, @QID = default, @Answer = 1, @Original_id = default, @Original_Answer = default, @Original_ClientID = default, @Original_QID = default, @Original_casenum = default, @Original_date = default, @id = default
Everything is default except what changed (@answer), but it should have the values that are in the dataset.
Anyone know why it's doing this and/or howto fix it?
Thanks.
