Problem when adding extra field

I added an extra field called "Client" to the Tasks table. I modified the InsertTask and UpdateTask stored procedures as well as the DataSetTasks class, DataLayer class and the DataSetTasks schema.
I get this error when I try to add a new task:
An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll

Additional information: System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.Data.SqlClient.SqlException: Procedure 'InsertTask' expects parameter '@Client', which was not supplied.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
at TaskVisionWS.DataService.UpdateTasks(String ticket, Int32 projectID, DataSetTasks dsTasks)
End of inner exception stack trace

Can anyone help please?

see below stored procedures -->

CREATE PROCEDURE [InsertTask]
(
@ProjectID int,
@ModifiedBy int,
@AssignedTo int,
@Client varchar(70),
@TaskSummary varchar(70),
@TaskDescription varchar(500),
@PriorityID int,
@StatusID int,
@Progress int,
@DateDue datetime
)
AS
SET NOCOUNT OFF;
INSERT INTO Tasks (ProjectID, ModifiedBy, AssignedTo, Client, TaskSummary, TaskDescription, PriorityID, StatusID, Progress, DateDue)
VALUES (@ProjectID, @ModifiedBy, @AssignedTo, @Client, @TaskSummary, @TaskDescription, @PriorityID, @StatusID, @Progress, @DateDue)
SELECT TaskID, ProjectID, ModifiedBy, AssignedTo, Client, TaskSummary, TaskDescription, PriorityID, StatusID, Progress, IsDeleted, DateDue, DateModified, DateCreated FROM Tasks WHERE (TaskID = @@IDENTITY)
GO

CREATE PROCEDURE [UpdateTask]
(
@TaskID int,
@ProjectID int,
@ModifiedBy int,
@AssignedTo int,
@Client varchar(70),
@TaskSummary varchar(70),
@TaskDescription varchar(500),
@PriorityID int,
@StatusID int,
@Progress int,
@IsDeleted bit,
@DateDue datetime,
@DateModified datetime,
@DateCreated datetime,
@Original_ProjectID int,
@Original_ModifiedBy int,
@Original_AssignedTo int,
@Original_Client varchar(70),
@Original_TaskSummary varchar(70),
@Original_TaskDescription varchar(500),
@Original_PriorityID int,
@Original_StatusID int,
@Original_Progress int,
@Original_IsDeleted bit,
@Original_DateDue datetime,
@Original_DateModified datetime,
@Original_DateCreated datetime
)
AS
SET NOCOUNT OFF;
--note we are using convert to varchar on the date comparison so that the pocket pc app can use this sp.
--the pocket pc app stores offline data in Sql CE which only supports a 4 byte datetime.
UPDATE Tasks
SET ProjectID = @ProjectID, ModifiedBy = @ModifiedBy, AssignedTo = @AssignedTo, Client = @Client, TaskSummary = @TaskSummary, TaskDescription = @TaskDescription, PriorityID = @PriorityID, StatusID = @StatusID, Progress = @Progress, IsDeleted = @IsDeleted, DateDue = @DateDue, DateModified = @DateModified
WHERE (TaskID = @TaskID) AND (ProjectID = @Original_ProjectID) AND (ModifiedBy = @Original_ModifiedBy) AND (AssignedTo = @Original_AssignedTo) AND (Client = @Original_Client) AND (TaskSummary = @Original_TaskSummary) AND (TaskDescription = @Original_TaskDescription) AND (ProjectID = @Original_ProjectID) AND (StatusID = @Original_StatusID) AND (Progress = @Original_Progress) AND (IsDeleted = @Original_IsDeleted) AND (convert(varchar(20), DateDue) = convert(varchar(20), @Original_DateDue)) AND (convert(varchar(20), DateModified) = convert(varchar(20), @Original_DateModified)) AND (convert(varchar(20), DateCreated) = convert(varchar(20), @Original_DateCreated)) AND (PriorityID = @Original_PriorityID);
SELECT TaskID, ProjectID, ModifiedBy, AssignedTo, Client, TaskSummary, TaskDescription, PriorityID, StatusID, Progress, IsDeleted, DateDue, DateModified, DateCreated FROM Tasks WHERE (TaskID = @TaskID)
GO

[4064 byte] By [codefund.com] at [2008-2-15]
# 1
The SP looks fine. Did you try a SQL Trace just to be sure? Also, in the webconfig for TaskVisionWS, try turing on traceenable to "true" (Case Sensitive) and then point you browser to

"http://<server>/TaskVisionWS/Trace.axd" and see if that gives you any more info. You might have to recomplile the project, but I'm not 100% sure.

Let me know how it turns out.

-MM

codefund.com at 2007-9-8 > top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...
# 2
I am also having the same problem with DataSetTasks.
Let me know if you get it working.

Also an open question. What tool is used to autogenerate the DataSetTasks.vb

If you look at the head of the file it reads:
'
' <autogenerated>
' This code was generated by a tool.
' Runtime Version: 1.0.3705.0
'
' Changes to this file may cause incorrect behavior and will be lost if
' the code is regenerated.
' </autogenerated>
'

thanks

codefund.com at 2007-9-8 > top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...
# 3
What about DataSetTasks.vb in the TaskVisionWS? Did you add a column and column type for that. Also you need to update the Web Reference in the TaskVision app (just right click on DataWS and choose 'update'.

I did this and I updated everything myself, even the .xsd file.

codefund.com at 2007-9-8 > top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...
# 4
See the strain "TaskVisionWS DataSet(xxx).vb", DrFooMod has supplied an answer to the question regarding the autogenerated code.
codefund.com at 2007-9-8 > top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...