SqlException or binary data be truncated?

Guest User

6y946.NET

Hi Team

My save functionality is getting this exception, before all my form fields were saving to my table on DB.

// Controller
public ActionResult SubmitRegDetails(RegViewAndRoleViewModel eNtsaRegistration)
{
if(ModelState.IsValid)
{
eNtsaRegistration.RegForm.Id = Guid.NewGuid();
db.eNtsaRegForms.Add(eNtsaRegistration.RegForm);
db.SaveChanges(); // Throws error here each time want to save changes to DB.
return RedirectToAction("SaveRegForm");
}
// Model
public class eNtsaRegForm
{
[Key]
public Guid? Id { get; set; }
public string Title { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Position { get; set; }
public string Company { get; set; }
public string StreetAddress { get; set; }
public string StreetAddressLine { get; set; }
public string City { get; set; }
public string StateProvince { get; set; }
public int ZipCode { get; set; }
public string Country { get; set; }
[Required(ErrorMessage = " This field is required")]
[EmailAddress(ErrorMessage = "Invalid email address")]
public string Email { get; set; }
public int CellNumber { get; set; }
public string DietaryRequirements { get; set; }
}

7 Replies

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

Jenith Thakkar6y ago
Accepted answer
HI
This error is generated when passed data length is greater then field length

Thank you
Santhakumar Munuswamy6y ago
Hi Gcobani,

Can you check the column Title, FirstName, Position, and DietaryRequirement length is enough for giving input data length
Guest User6y ago
Hi Team
Here is columns for my table on DB below;
ID(uniqueidentifier not null) PK
Title nvarchar(10) not null
FirstName nvarchar(15) not null
LastName nvarchar(25) not null
Position nvarchar(15) not null
Company nvarchar(35) not null
StreetAddress nvarchar(Max)) not null
StreetAddressLine nvarchar(Max))
City nvarchar(35) not null
StateProvince nvachar(45) not null
ZipCode int not null
Country nvarchar(30) not null
Email nvarchar(30) not null
CellNumber int not null
DietaryRequirement nvarchar(10) not null
Santhakumar Munuswamy6y ago
Hi,

I think I am not able to find actual columns but you can share your table script then I will try to find the column.

or

Can you ensure the which column throwing error while running insert SQL script into your SQL server management studio?
Laxmidhar Sahoo6y ago
hi

Please fiil al the required fields like
[Required(ErrorMessage = " This field is required")]
[EmailAddress(ErrorMessage = "Invalid email address")]
public string Email { get; set; }
Email field should bind to moldel .you bind only Guid

assign all not null columns to model

Thanks and regards
Guest User6y ago
Hi Team

I think i get an understanding of the error, pls help me to reduce the size of my data types column for my table below.

// Which columns below need adjustments per each data types?
Santhakumar Munuswamy6y ago
Hi Gcobani,

you can check out the link for your reference. I hope you will get some idea or solutions for your query

https://stackoverflow.com/questions/28965462/string-or-binary-data-would-be-truncated-add-new-row-entity-framework

https://www.dotnet4techies.com/2015/03/string-or-binary-data-would-be.html

https://stackoverflow.com/questions/5591473/error-string-or-binary-data-would-be-truncated-when-trying-to-insert

I hope it will be helpful to you

Thanks