title: How to pass correct object value in SqlParameter for datatype bit?
body: <p>I am trying to pass a bit value only if needed (is checked).</p>
  
  <p>How do I do this correctly? I am not getting a change in my dataset. SQL Server 2008.</p>
  
  <pre><code>if (chkExpired.Checked)
      CmdGetDetails.Parameters.Add(new SqlParameter("@isExpired", 1));
  </code></pre>