Ad:

C# Discussion Thread
Marked Solved
Views: 2525

Mar 10th, 2008

insert statement problem

Expand Post »

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:

C# Syntax (Toggle Plain Text)
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
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.

Similar Threads

insert multiple rows in database in MS SQL
Insert Dataset into SQL Database. in VB.NET
Its really a problem on INSERT statement in MySQL
MySQL insert statement in MySQL
SQL problem - table names as variables in MS SQL

waterfall

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Nov 2007

Permalink

Mar 11th, 2008

Re: insert statement problem

I don't have something in which I can say that's the problem I am not sure but try to be sure from column names like 'name'.
Trace the parameters sent to this SP if it works!
Send me the error raised to help you.

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

Permalink

Mar 11th, 2008

Re: insert statement problem

I tried answering this morning, but the network connection failed. Sorry for being late

The Insert statement does not allow a Where clause.
I will assume that your Employee table has a column named "EmployeeName" or some place to put the name value. It would not make sense to place a task against an employee without also telling the database which employee the task is assigned.

I have revised the proc for you below.

Regards,
Jerry

C# Syntax (Toggle Plain Text)
create PROCEDURE [dbo].[AssignAndStore] 
	@name varchar(50),
@TaskAssigned nvarchar(50),
@TimeAssigned nvarchar(50)
AS
BEGIN
 
insert into Employee(EmployeeName,TaskAssigned,TimeAssigned)
values (@name,@TaskAssigned,@TimeAssigned)
 
END
create PROCEDURE [dbo].[AssignAndStore] 
	@name varchar(50),
@TaskAssigned nvarchar(50),
@TimeAssigned nvarchar(50)
AS
BEGIN
 
insert into Employee(EmployeeName,TaskAssigned,TimeAssigned)
values (@name,@TaskAssigned,@TimeAssigned)

END

JerryShaw

Reputation Points: 69

Solved Threads: 75

Posting Pro in Training

Offline

465 posts
since Nov 2006

Permalink

Mar 12th, 2008

Re: insert statement problem

my problem has been solved.i used update query instead of insert.

waterfall

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Need design help for commission payout system

Next Thread in C# Forum Timeline: Print in client system

DaniWeb Message

Cancel Changes

User Name
Password