I have one checkbox control in my web application.And i Connected with the sql server.I declared checkbox datatype as bit. when i am checked the checkbox control it needs to pass bit value.I already execute by following method.
int active;
if (chkboxActive.Checked)
{ active = 1; }
else
{ active = 0; }
cmd.Parameters.Add("@active", SqlDbType.Bit).Value = active;
It executes well.But i felt it is not a efficient one. Give any other easiest code in short line.
cmd.Parameters.Add("@active", SqlDbType.Bit).Value = chkboxActive.Checked;
!chkboxActive.Checked for that.
If you are using Object Relational Mapping, you will be using a property to pass the value:
public bool Active {get; set;}
When you want to save your data to SQL database table for the BIT data type that will be passed from a checkbox you must set the parameters of the sql command to accept bool as bit data and convert it to 1 if true or 0 if false like this:
SqlCommand cmd = new SqlCommand(SqlString, SqlConnection);
cmd.Parameters.Add("@Active", SqlDbType.Bit, Active ? 1:0).Value = Active;
So when the boolean value is passed from the checkbox to the 'Sql Variable` it will be converted to 1 or 0 based on the checkbox.checked property.
xData.Active = CheckBox.Checked;
cmd.Parameters.Add("@active", SqlDbType.Bit).Value = chkboxActive.Checked;Checked.