7
Answers

SqlException or binary data be truncated?

Guest User

Guest User
4y
681
1
Hi Team
 
My save functionality is getting this exception, before all my form fields were saving to my table on DB. 
  1. // Controller  
  2.   
  3.         public ActionResult SubmitRegDetails(RegViewAndRoleViewModel eNtsaRegistration)  
  4.         {  
  5.              
  6.   
  7.             if(ModelState.IsValid)  
  8.             {  
  9.                 eNtsaRegistration.RegForm.Id = Guid.NewGuid();  
  10.                 db.eNtsaRegForms.Add(eNtsaRegistration.RegForm);  
  11.                 db.SaveChanges();  // Throws error here each time want to save changes to DB.
  12.                 return RedirectToAction("SaveRegForm");  
  13.             }  
  14.   
  15. // Model  
  16. public class eNtsaRegForm  
  17.     {  
  18.         [Key]  
  19.         public Guid? Id { get; set; }  
  20.         public string Title { get; set; }  
  21.         public string FirstName { get; set; }  
  22.         public string LastName { get; set; }  
  23.         public string Position { get; set; }  
  24.         public string Company { get; set; }  
  25.         public string StreetAddress { get; set; }  
  26.         public string StreetAddressLine { get; set; }  
  27.         public string City { get; set; }  
  28.         public string StateProvince { get; set; }  
  29.         public int ZipCode { get; set; }  
  30.         public string Country { get; set; }  
  31.   
  32.         [Required(ErrorMessage = " This field is required")]  
  33.         [EmailAddress(ErrorMessage = "Invalid email address")]  
  34.         public string Email { get; set; }  
  35.           
  36.         public int CellNumber { get; set; }  
  37.         public string DietaryRequirements { get; set; }  
  38.   
  39.   
  40.     }  
 
Answers (7)
Next Recommended Forum