title: How to insert radio button true or false to database ms.access in vb.net?
body: <p>i want if i checked radiobutton1 then field status(data type: yes/no, format: true/false) in database ms.access is true(checked), if i checked radiobutton2 then field status(data type: yes/no, format: true/false) in database ms.access is false(unchecked).</p>
  
  <p>my script is:</p>
  
  <pre><code>dim s as boolean
  if radiobutton1.checked = true then
  s = true
  elseif radiobutton2.checked = true then
  s = false
  end if
  
                  cmd = New OleDbCommand("Insert into table_petugas (name,status) Values ('" &amp; txtname.Text &amp; "','" &amp; status &amp; "' )", conn)
                  cmd.ExecuteNonQuery()
                  MsgBox("Data Saved!", MsgBoxStyle.Information, "PERHATIAN!")
  </code></pre>
  
  <p>but the script is error, saying: "data type mismatch in criteria expression"
  help me, please..
  sorry for my bad language..</p>