vendredi 23 avril 2021

Checkboxes to SQL in ASP.NET Core

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