title: how to insert bit datatype column value
body: <p>I have a drop down list box,It content 'Yes' and 'No'.
  I insert this value into the database table data type of column is a bit how can I insert this value into vb.net</p>
  
  <pre><code>cmd.CommandText = "INSERT INTO application_main(obligations_is) VALUES( '" + convertBit(dropdownlist1.text) + "' )"
  
  cmd.ExecuteNonQuery()
  
        Public Function convertBit(ByVal dropdownlist As String)
      Dim value As Integer
  
  
      If dropdownlist = "Yes" Then
          value = 1
      Else
          value = 0
      End If
  
      Return value
  End Function
  </code></pre>