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

Question

0.00/5 (No votes)

See more:

HAVE THIS ERROR.

Pls assist to correct

C#

//connection to the database
              //
              //
              string str;
              str = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
              SqlConnection sqlcon = new SqlConnection(str);

              string intno;

              //Get the intno
              intno = GridView1.SelectedRow.Cells[1].Text;

              //call the stored procedure
              SqlCommand SqlCmd = new SqlCommand("sp_GetDisbursed", sqlcon);
              SqlCmd.CommandType = System.Data.CommandType.StoredProcedure;

              //Supply the User_id parameter
              SqlCmd.Parameters.AddWithValue("@ZAPPRAISAL", intno);

              //Create and supply the output parameters
              SqlCmd.Parameters.Add("@ZACCT1", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZACCT1"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZACCT2", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZACCT2"].Direction = System.Data.ParameterDirection.Output;


              //SqlCmd.Parameters.Add("@ZACTUAL_DISB", System.Data.SqlDbType.VarChar, 50);
              //SqlCmd.Parameters["@ZACTUAL_DISB"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZACTUAL_DISB", System.Data.SqlDbType.Money);
              SqlCmd.Parameters["@ZACTUAL_DISB"].Direction = System.Data.ParameterDirection.Output;



              SqlCmd.Parameters.Add("@ZAMT_APPRVED", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZAMT_APPRVED"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZBANK1", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZBANK1"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZBANK2", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZBANK2"].Direction = System.Data.ParameterDirection.Output;


              SqlCmd.Parameters.Add("@ZBENEFICIARY", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZBENEFICIARY"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZBRANCH_CODE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZBRANCH_CODE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZBRANCH_NAME", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZBRANCH_NAME"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZCREDIT_OFFICER", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZCREDIT_OFFICER"].Direction = System.Data.ParameterDirection.Output;


              SqlCmd.Parameters.Add("@ZCURRENCY", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZCURRENCY"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZDATE_DISB", System.Data.SqlDbType.DateTime);
              SqlCmd.Parameters["@ZDATE_DISB"].Direction = System.Data.ParameterDirection.Output;


              SqlCmd.Parameters.Add("@ZDFI_CODE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZDFI_CODE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZDFI_NAME", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZDFI_NAME"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZDIR1", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZDIR1"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZDIR2", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZDIR2"].Direction = System.Data.ParameterDirection.Output;


              SqlCmd.Parameters.Add("@ZDISB_ROUTINE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZDISB_ROUTINE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZESTABLISH", System.Data.SqlDbType.DateTime);
              SqlCmd.Parameters["@ZESTABLISH"].Direction = System.Data.ParameterDirection.Output;

              //SqlCmd.Parameters.Add("@ZEXPECT_AMT", System.Data.SqlDbType.VarChar, 50);
              //SqlCmd.Parameters["@ZEXPECT_AMT"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZEXPECT_AMT", System.Data.SqlDbType.Money);
              SqlCmd.Parameters["@ZEXPECT_AMT"].Direction = System.Data.ParameterDirection.Output;



              SqlCmd.Parameters.Add("@ZFACILITY_TYPE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZFACILITY_TYPE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZMANAGING", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZMANAGING"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZMORAT_MTHS", System.Data.SqlDbType.SmallInt);
              SqlCmd.Parameters["@ZMORAT_MTHS"].Direction = System.Data.ParameterDirection.Output;


              SqlCmd.Parameters.Add("@ZOFFICE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZOFFICE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZPROJECT_TYPE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZPROJECT_TYPE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZREGISTERED", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZREGISTERED"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZSECT_NAME", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZSECT_NAME"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZSECT_NO", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZSECT_NO"].Direction = System.Data.ParameterDirection.Output;

              //SqlCmd.Parameters.Add("@ZTRANCHE", System.Data.SqlDbType.VarChar, 50);
              //SqlCmd.Parameters["@ZTRANCHE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZTRANCHE", System.Data.SqlDbType.Money);
              SqlCmd.Parameters["@ZTRANCHE"].Direction = System.Data.ParameterDirection.Output;



              SqlCmd.Parameters.Add("@ZDISBURSE_TYPE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZDISBURSE_TYPE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZINTEREST_TYPE", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZINTEREST_TYPE"].Direction = System.Data.ParameterDirection.Output;

              SqlCmd.Parameters.Add("@ZMORATORIUM", System.Data.SqlDbType.VarChar, 50);
              SqlCmd.Parameters["@ZMORATORIUM"].Direction = System.Data.ParameterDirection.Output;

SQL

ALTER Procedure [dbo].[sp_GetDisbursed]
(
	            @ZAPPRAISAL               VarChar( 50) OUTPUT,
                @ZACCT1                   VarChar( 50) OUTPUT,
                @ZACCT2                   VarChar( 50) OUTPUT,
                @ZACTUAL_DISB             MONEY        OUTPUT,
                @ZAMT_APPRVED             MONEY  OUTPUT,
                @ZBANK1                   VarChar( 50) OUTPUT,
                @ZBANK2                   VarChar( 50) OUTPUT,
                @ZBENEFICIARY             VarChar( 50) OUTPUT,
                @ZBRANCH_CODE             VarChar( 50) OUTPUT,
                @ZBRANCH_NAME             VarChar( 50) OUTPUT,
                @ZCREDIT_OFFICER          VarChar( 50) OUTPUT,
                @ZCURRENCY                VarChar( 50) OUTPUT,
                @ZDATE_DISB               DateTime    OUTPUT,
                @ZDFI_CODE                VarChar( 50) OUTPUT,
                @ZDFI_NAME                VarChar( 50) OUTPUT,
                @ZDIR1                    VarChar( 50) OUTPUT,
                @ZDIR2                    VarChar( 50) OUTPUT,   
                @ZDISB_ROUTINE            VarChar( 50) OUTPUT,
                @ZESTABLISH               DateTime   OUTPUT,
                @ZEXPECT_AMT              MONEY OUTPUT,
                @ZFACILITY_TYPE           VarChar( 50) OUTPUT,
                @ZMANAGING                VarChar( 50) OUTPUT,
                @ZMORAT_MTHS              SmallInt    OUTPUT,
                @ZOFFICE                  VarChar( 50) OUTPUT,
                @ZPROJECT_TYPE            VarChar( 50) OUTPUT,
                @ZREGISTERED              VarChar( 50) OUTPUT,
                @ZSECT_NAME               VarChar( 50) OUTPUT,
                @ZSECT_NO                 VarChar( 50) OUTPUT,
                @ZTRANCHE                 MONEY OUTPUT,
                @ZDISBURSE_TYPE           VarChar( 50) OUTPUT,
                @ZINTEREST_TYPE           VarChar( 50) OUTPUT,
                @ZMORATORIUM              VarChar( 50) OUTPUT
				 --  @RETURN VARCHAR(4) OUTPUT
 )

Posted 22-Jan-15 14:53pm

Member 10744248

Updated 22-Jan-15 15:55pm

DamithSL

v2

Add a Solution

Comments

DamithSL 22-Jan-15 22:12pm

ZAPPRAISAL parameter need to be set as output parameter as per the stored procedure, but you haven't define it correctly in your code and the size also not given. this error says you have value exceeding the maximum size of a column so you better debug and check which value is exceeding.

2 solutions

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)

PTG.Jake · Answer 1 · 2015-01-22T15:22:00

Solution 1

it seems that intno = GridView1.SelectedRow.Cells[1].Text; exceeds the 50 char limit for ZAPPRAISAL VarChar( 50)

Posted 22-Jan-15 15:22pm

PTG.Jake

Zubairk1990 · Answer 2 · 2015-01-22T20:46:00

Solution 2

The issue comes when you pass the Overlimit data to the Storeprocedure.

For Testing you can set the VarChar(max) for all out put parameters.

Posted 22-Jan-15 20:46pm

Zubairk1990