The following code inserts "1" or "0" into my DB. I need help with regard to inserting a specific value ie. if the checkbox is checked it would insert "Eqpt Swap" and if left unchecked
the value would be NULL or "No Swap". My DB column for "MM" is currently setup as "NVarChar".
cmd.CommandText = ("INSERT into Delays VALUES (@Dates,@Ship,@Station,@GT,@Log,@Inbd,@Otbd,@Dep,@Ground,@Code,@Time,@Code1,@Time1,@Wake,@Captain,@RON,@Ck,@Hist,@Call,@MM,@RB,@Tech,@Lead,@Reason,@Comment,@ATA,@DelayReason)");
e("@MM", (MM.Checked ? 1 : 0));