String or binary data would be truncated. The statement has been terminated

Question

0.00/5 (No votes)

See more:

C#

Alter Procedure approve   
(    
@leaveid int,    
@status int,
@userid int  
 )    
AS    
begin     
update leaves set status=@status where contentid=@leaveid    
  
declare    @applydate varchar(50), @applyiedby varchar(50), @isrmapproved varchar(50), @rmapproveddate varchar(50),@rmapprovedby varchar(50),@approvedby varchar(50),@ismanagerapproved varchar(50) ,@approvedate varchar(50) ,@iscancelled  varchar(20), @modifieddate varchar(50) , @modifiedby varchar(50)  
insert into reportingperosnreport    
(empid,leaveid,status,applydate,applyiedby,isrmapproved,rmapproveddate,rmapprovedby,ismanagerapproved,approvedate,  
approvedby,iscancelled,modifieddate,modifiedby)  
values   
('select employeeid from leaves where contentid=@leaveid' ,   
'@leaveid',  
'select status from leaves where contentid=@leaveid',  
'select createdate from leaves where content_id=@leaveid',  
'select Contentid from leaves where content_id=@leaveid',  
'select employee_id from Employee where =@userid',   
'getdate()',  
'select content_id from employee where content_id=@leaveid',  
'select status from leaves where contentid=@leaveid',  
'getdate()',  
'select employeeid from leaves where content_id=@userid',  
'select employeeid from leaves where content_id=@userid',  
'getdate()',  
'select employeename from employee where content_id=@userid')  
end

and i am not able to insert the data insert the table

C#

public int getdashboardapprove(int contentid ,int status,int leaveid)
    {
        openconnection();
        _com.CommandType = CommandType.StoredProcedure;
        _com.CommandTimeout = 2;
        _com.CommandText = "approve";
        _com.Parameters.AddWithValue("@status", status);
        _com.Parameters.AddWithValue("@leaveid", leaveid);
        _com.Parameters.AddWithValue("@userid", contentid);
        int result= com.ExecuteNonQuery(); ----->there is the error coming 
        con.Close();
        return result;
        }

tell me what to do now

Posted 18-Sep-13 23:53pm

sonuods

Updated 19-Sep-13 0:58am

ridoy

v3

Add a Solution

Comments

Dholakiya Ankit 19-Sep-13 5:55am

line no of error pls

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Love 2 code · Answer 1 · 2013-09-19T00:06:00

Solution 1

Hi,
delete the ' around your selects, now you are trying to insert the string 'select employeename from employee where content_id=@userid' into the column modifiedby, and that column can't take the 61 character.
Have a nice day

Hi, use an Insert with a Select:

SQL

Alter Procedure approve   
(    
@leaveid int,    
@status int,
@userid int  
 )    
AS    
begin     
update leaves set status=@status where contentid=@leaveid    


insert into reportingperosnreport    
(empid,leaveid,status,applydate,applyiedby,isrmapproved,rmapproveddate,rmapprovedby,ismanagerapproved,approvedate,  
approvedby,iscancelled,modifieddate,modifiedby)  
SELECT 
ll.employeeid, @leaveid, ll.status,...,e.employeename
FROM leaves ll, leaves lu, Employee e
WHERE ll.contentid=@leaveid AND lu.content_id=@userid AND e.content_id=@leaveid

END

Posted 19-Sep-13 0:06am

Love 2 code

Updated 19-Sep-13 1:41am

v2

Comments

[no name] 19-Sep-13 7:19am

where to do

[no name] 19-Sep-13 11:38am

please let me know the complete answer so that it will be very help to me

Love 2 code 19-Sep-13 11:45am

So you just have to fill in the corresponding column names in the Select

SELECT
ll.employeeid, @leaveid, ll.status,(use columns from tables ll, lu and e or getdate()),e.employeename

[no name] 20-Sep-13 3:38am

it is not working so i have define it as repeating of insert into statements

Love 2 code 20-Sep-13 5:39am

Ok, what is not working, what insert statement did you try?

[no name] 20-Sep-13 7:41am

the statement which u have written

Love 2 code 23-Sep-13 5:13am

The statement I had written had the three dots ... in it, so naturally, it wouldn't work. For it to work, you got to replace the dots with the right columns!
Peace

[no name] 25-Sep-13 11:41am

i have try another method also
first i have declare all and then define it

[no name] 20-Sep-13 7:50am

so i have try this code

CREATE Procedure approve --72,1,21
(
@leaveid int,
@status int,
@userid int

)
AS
begin
update leaves set status=@status where contentid=@leaveid

--Declare @applydate datetime, @applyiedby varchar(100), @isrmapproved varchar(50), @rmapproveddate datetime ,@rmapprovedby varchar(50),
--@approvedby varchar(50),@ismanagerapproved varchar(100) ,@approvedate datetime , @modifieddate datetime , @modifiedby varchar(100)

insert into reportingperosnreport (empid)
select content_id from employee where content_id=@userid

insert into reportingperosnreport (leaveid)
values (@leaveid)
insert into reportingperosnreport (status)
select top 1 status from leaves where contentid=@leaveid

insert into reportingperosnreport (applydate)
select top 1 createddate from leaves where contentid=@leaveid

insert into reportingperosnreport (applyiedby)
select top 1 Contentid from leaves where contentid=@leaveid

insert into reportingperosnreport (rmapproveddate)
values (getdate()) -- rmapproveddate

insert into reportingperosnreport (rmapprovedby)
select top 1 content_id from employee where content_id=@userid

insert into reportingperosnreport (approvedate)
values (getdate()) -- approvedate

insert into reportingperosnreport (approvedby)
values( @userid) --approvedby

insert into reportingperosnreport (modifieddate)
values (getdate()) --modifieddate

insert into reportingperosnreport (modifiedby)
select content_id from employee where content_id=@userid

end