I have an existing MS SQL table with data and need to add a new column that should store the value from a checkbox field in a form using ASP.NET Core 5 and razorpages
here are my questions
- What data type should I use in SQL for this checkbox column?
- What data type should I use in the Model?
- What values should be stored in SQL, "false/true", 0/1, -1,0 ?
as a side note I can say I have tried many differrent options but I endup all the time getting some kind of type missmatch error when I submit my form, or when I try to bind the value to the checkbox in an "editform"
thanks
Aucun commentaire:
Enregistrer un commentaire