String or binary data would be truncated.

Abdalla Elawad

10y1.2kVisual Basic .NET

try

{

SqlCommand cmd = new SqlCommand("M_Update", Conn);

cmd.Parameters.Add("@CarNo", SqlDbType.Char).Value = (DropDownList1.SelectedValue);

cmd.Parameters.Add("@TeamNo", SqlDbType.BigInt).Value = TextBox1.Text.Trim();

cmd.Parameters.Add("@Customers", SqlDbType.NVarChar).Value = TextBox5.Text.Trim();

cmd.Parameters.Add("@DriverName", SqlDbType.NVarChar).Value = (DropDownList8.SelectedValue);

cmd.Parameters.Add("@First_Supervisor", SqlDbType.NVarChar).Value = (DropDownList9.SelectedValue);

cmd.Parameters.Add("@Second_Supervisor", SqlDbType.NVarChar).Value = (DropDownList10.SelectedValue);

cmd.Parameters.Add("@ServiceType", SqlDbType.NVarChar).Value = (DropDownList2.SelectedValue);

cmd.Parameters.Add("@BankName", SqlDbType.NVarChar).Value = (DropDownList3.SelectedValue);

cmd.Parameters.Add("@Region", SqlDbType.NVarChar).Value = (DropDownList4.SelectedValue);

cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = (DropDownList5.SelectedValue);

cmd.Parameters.Add("@PlanStartDate", SqlDbType.Date).Value = TextBox6.Text.Trim();

cmd.Parameters.Add("@Recycle_Date", SqlDbType.Date).Value = TextBox7.Text.Trim();

cmd.Parameters.Add("@Case_Option", SqlDbType.NVarChar).Value = (DropDownList6.SelectedValue);

cmd.Parameters.Add("@AbsenseName", SqlDbType.NVarChar).Value = (DropDownList7.SelectedValue);

cmd.Parameters.Add("@Responsible_1", SqlDbType.NVarChar).Value = TextBox14.Text.Trim();

cmd.Parameters.Add("@Responsible_2", SqlDbType.NVarChar).Value = TextBox15.Text.Trim();

cmd.Parameters.Add("@AlterSuper_1", SqlDbType.NVarChar).Value = TextBox12.Text.Trim();

cmd.Parameters.Add("@AlterSuper_2", SqlDbType.NVarChar).Value = TextBox13.Text.Trim();

cmd.Parameters.Add("@EmpAlterDate", SqlDbType.Date).Value = TextBox16.Text.Trim();

cmd.Parameters.Add("@NewRecycleDate", SqlDbType.Date).Value = TextBox17.Text.Trim();

cmd.Parameters.Add("@OperationDate", SqlDbType.Date).Value = TextBox6.Text.Trim();

cmd.CommandType = CommandType.StoredProcedure;

Conn.Open();

cmd.ExecuteNonQuery();

Conn.Close();

TextBox1.Text = "";

//TextBox2.Text = "";

//TextBox4.Text = "";

TextBox5.Text = "";

//TextBox3.Text = "";

TextBox6.Text = "";

TextBox7.Text = "";

TextBox12.Text = "";

TextBox13.Text = "";

TextBox14.Text = "";

TextBox15.Text = "";

TextBox16.Text = "";

TextBox17.Text = "";

Msglbl.Visible = true;

Msglbl.Text = "updated data";

}

catch

{

Msglbl.Text = " Not Update";

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karthik Elumalai10y ago
Reason for exception:
Simple,these kind of exception will occur ,when the size/datatype of the input value doesnt match with database columns
In your case,while giving the value for the parameter value ,just give the as per the size given.
if you want dig more details ,kindly take a look at the below link
https://connect.microsoft.com/SQLServer/feedback/details/339410/please-fix-the-string-or-binary-data-would-be-truncated-message-to-give-the-column-name
Kindly let me know your thoughts
thanks
ali tuncer10y ago
you are trying to insert a string with more characters than column's maximum value..
for example, if Driver'sName is more than 50 characters, you would receive this error message..
Abdalla Elawad10y ago
String or binary data would be truncated.
The statement has been terminated.
This is Stored Procedures :
USE [Cash_Plan]
GO
/****** Object: StoredProcedure [dbo].[M_Update] Script Date: 06/04/2016 10:41:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[M_Update]
(@CarNo char(10),
@DriverName nvarchar(50),
@First_Supervisor nvarchar(50),
@Second_Supervisor nvarchar(50),
@ServiceType nvarchar(10),
@BankName nvarchar(15),
@PlanStartDate date,
@Recycle_Date date,
@TeamNo bigint,
@Customers Nvarchar(30),
@Region NVARCHAR(35),
@City NVARCHAR(15),
@Responsible_1 NVARCHAR(50),
@Responsible_2 NVARCHAR(50),
@AlterSuper_1 NVARCHAR(50),
@AlterSuper_2 NVARCHAR(50),
@Case_Option NVARCHAR(50),
@AbsenseName NVARCHAR(20),
@EmpAlterDate date,
@NewRecycleDate date, @OperationDate date)

AS

BEGIN

UPDATE MplanTbl SET
CarNo=@CarNo,
DriverName=@DriverName,
First_Supervisor=@First_Supervisor,
Second_Supervisor=@Second_Supervisor,
ServiceType=@ServiceType,
BankName=@BankName,
PlanStartDate=@PlanStartDate,
TeamNo=@TeamNo,
Customers=@Customers,
Region=@Region,
City=@City,
Responsible_1=@Responsible_1,
Responsible_2=@Responsible_2,
AlterSuper_1=@AlterSuper_1,
AlterSuper_2=@AlterSuper_2,
Case_Option=@Case_Option,
EmpAlterDate=@EmpAlterDate,
NewRecycleDate=@NewRecycleDate,
AbsenseName=@AbsenseName
WHERE CarNo=@CarNo AND TeamNo=@TeamNo

UPDATE OperationPlan SET
CarNo=@CarNo,
DriverName=@DriverName,
First_Supervisor=@First_Supervisor,
Second_Supervisor=@Second_Supervisor,
ServiceType=@ServiceType,
BankName=@BankName,
PlanStartDate=@PlanStartDate,
Recycle_Date=@Recycle_Date,
TeamNo=@TeamNo,
Customers=@Customers,
Region=@Region,
City=@City,
OperationDate=@OperationDate

WHERE CarNo=@CarNo AND TeamNo=@TeamNo

END