hi, im using VS.net 2005 for developing a web application.im using stored procedure for inserting records into database.i want to insert time and task for a selcetd employee but its not working. kindly help me.her's my stored procedure:
create PROCEDURE [dbo].[AssignAndStore] -- Add the parameters for the stored procedure here @name varchar(50), @TaskAssigned nvarchar(50), @TimeAssigned nvarchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; --insert query insert into Employee(TaskAssigned,TimeAssigned) values (@TaskAssigned,@TimeAssigned) WHERE name = @name --im getting error with where clause END
im using dropdwn list for task and name and textbox for time.