DataType Bit in Sql

I have IsActive = Bit type in Sql . In input form i have below code

IsActive

On Controller it gives message - [0] = "The value 'Y' is not valid for IsActive."

[HttpPost]
public ActionResult CreateEdit(Product objProduct)
{
if (ModelState.IsValid)
{
dbProduct.Add(objProduct);
}
else
{
var query = from state in ModelState.Values
from error in state.Errors
select error.ErrorMessage;
var errors = query.ToArray();
}
return RedirectToAction("Index");
}

*********************************************************

[Required]
[Range(minimum: 1, maximum: 1)]
public bool IsActive { get; set; }

Thanks

If it is a bit then why are you taking yes/no, for the user's perspective too it is not good instead use the checkbox.

IsActive

You can use checkbox instead of text box as

"checkbox" id="txtIsActive" Name="IsActive" placeholder="Active">

Hi,

Firstly, remove the range validation in bool datatype.

And use input type check box to bind with bool.

<input type="checkbox" id="txtIsActive" Name="IsActive" placeholder="Active">

Model:

[Required]
public bool IsActive { get; set; }