|
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 |
index > Windows Forms Sample Applications > Problem when adding extra field