Невозможно разыграть объект типа 'System.int32' при попытке обновить данные через форму [дублировать] ⇐ C#

[Anonymous]

Я в настоящее время следую урок по созданию основного приложения ASP.NET с формами бритвы, я следил за «обновлением» частью учебника, в котором они дают инструкции о том, как настроить форму для редактирования выбранных данных. 'System.int32' to type 'System.string' < /p>
< /blockquote>
Я понятия не имею, какой из них вызвал ошибку. < /P>
Код для метода: < /p>
public int Update(ProductModel product)
{
int newIdNumber = -1;

string sqlStatement = "UPDATE dbo.ProductComplete SET Name = @Name, Price = @Price, Description = @Description WHERE Id = @Id";
//string sqlStatement = "UPDATE dbo.ProductComplete SET Name = @Name, Price = @Price, Description = @Description, Color = @Color, ChassisCode = @ChassisCode, Maker = @Maker, Year = @Year, Drivetrain = @Drivetrain WHERE Id = @Id";

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(sqlStatement, connection);
command.Parameters.AddWithValue("@Name", product.Name);
command.Parameters.AddWithValue("@Price", product.Price);
command.Parameters.AddWithValue("@Description", product.Description);
command.Parameters.AddWithValue("@Id", product.Id);
//command.Parameters.AddWithValue("@Color", product.Color);
//command.Parameters.AddWithValue("@ChassisCode", product.ChassisCode);
//command.Parameters.AddWithValue("@Maker", product.Maker);
//command.Parameters.AddWithValue("@Year", product.Year);
//command.Parameters.AddWithValue("@Drivetrain", product.Drivetrain);

try
{
connection.Open();
//newIdNumber = (int)command.ExecuteScalar();
newIdNumber = Convert.ToInt32(command.ExecuteScalar());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}

return newIdNumber;
}
< /code>
Таблица и его столбцы: < /p>
CREATE TABLE [dbo].[ProductComplete]
(
[ID] INT IDENTITY (1, 1) NOT NULL,
[Name] VARCHAR(512) NOT NULL,
[Price] DECIMAL(18) NOT NULL,
[Description] NCHAR(50) NULL,
[Color] VARCHAR(512) NOT NULL,
[Chassis] VARCHAR(512) NOT NULL,
[Maker] VARCHAR(512) NOT NULL,
[Year] INT NOT NULL,
[Train] VARCHAR(512) NOT NULL,
[Drive] VARCHAR(512) NOT NULL,
[Engine] VARCHAR(512) NULL,
[Power] INT NULL,
[Condition] VARCHAR(512) NULL,

CONSTRAINT [PK_tableName]
PRIMARY KEY CLUSTERED ([ID] ASC)
);
< /code>
Трассировка стека ошибок: < /p>
System.InvalidCastException: Unable to cast object of type 'System.Int32' to type 'System.String'.
at System.ComponentModel.DataAnnotations.StringLengthAttribute.IsValid(Object value)
at System.ComponentModel.DataAnnotations.ValidationAttribute.IsValid(Object value, ValidationContext validationContext)
at System.ComponentModel.DataAnnotations.ValidationAttribute.GetValidationResult(Object value, ValidationContext validationContext)
at Microsoft.AspNetCore.Mvc.DataAnnotations.DataAnnotationsModelValidator.Validate(ModelValidationContext validationContext)
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.ValidateNode()
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.VisitImplementation(ModelMetadata& metadata, String& key, Object model)
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.Visit(ModelMetadata metadata, String key, Object model)
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.VisitChildren(IValidationStrategy strategy)
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.VisitComplexType(IValidationStrategy defaultStrategy)
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.VisitImplementation(ModelMetadata& metadata, String& key, Object model)
at Microsoft.AspNetCore.Mvc.ModelBinding.Validation.ValidationVisitor.Visit(ModelMetadata metadata, String key, Object model)
at Microsoft.AspNetCore.Mvc.ModelBinding.ObjectModelValidator.Validate(ActionContext actionContext, ValidationStateDictionary validationState, String prefix, Object model, ModelMetadata metadata, Object container)
at Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder.EnforceBindRequiredAndValidate(ObjectModelValidator baseObjectValidator, ActionContext actionContext, ParameterDescriptor parameter, ModelMetadata metadata, ModelBindingContext modelBindingContext, ModelBindingResult modelBindingResult, Object container)
at Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder.BindModelAsync(ActionContext actionContext, IModelBinder modelBinder, IValueProvider valueProvider, ParameterDescriptor parameter, ModelMetadata metadata, Object value, Object container)
at Microsoft.AspNetCore.Mvc.Controllers.ControllerBinderDelegateProvider.c__DisplayClass0_0.d.MoveNext()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
--- End of stack trace from previous location ---
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)
< /code>
Обновление - Код контроллера: < /p>
public IActionResult Edit(int id)
{
ProductsDAO products = new ProductsDAO();
ProductModel foundProduct = products.GetProductById(id);
return View("ShowEdit",foundProduct);
}
public IActionResult ProcessEdit(ProductModel product)
{
ProductsDAO products = new ProductsDAO();
products.Update(product);
return View("Index", products.GetAllProducts());
}
< /code>
Модель продукта: < /p>
public class ProductModel
{
public int Id { get; set; }

[DisplayName("Product")]
public string Name { get; set; }

[DisplayName("Price")]
[DisplayFormat(DataFormatString = "CR {0:#,###0.00}")]
public decimal Price { get; set; }

public string Description { get; set; }

public string Color { get; set; }

public string ChassisCode { get; set; }

public string Maker { get; set; }

/*[DataType(DataType.Date)]
public DateTime Year { get; set; }*/

[StringLength(4)]
public int Year { get; set; }

[StringLength(3,MinimumLength =2)]
public string Drivetrain { get; set; }

}


Подробнее здесь: https://stackoverflow.com/questions/797 ... ta-through