title: How to replace textbox column to checkbox column in datagridview with mysql query
body: <p>I have this problem where I want to convert textbox column to checkbox in vb.net. The data is from mysql and I want one column to be displayed as checkbox column.</p>
  
  <p>Here is my code so far:</p>
  
  <pre><code>Private Sub data_load()
  
       Dim mycommand As New MySqlCommand
       Dim myadapter As New MySqlDataAdapter
       Dim mydata As New DataTable
  
       conn = New MySqlConnection
       conn.ConnectionString = connstr
  
       conn.Open()
  
       mycommand.Connection = conn
       mycommand.CommandText = "SELECT locator_id, name AS 'NAME', date AS 'DATE', destination AS 'DESTINATION', time_leave AS 'TIME LEAVE', time_return AS 'TIME RETURN', isOfficial AS 'OFFICIAL?' FROM locator_table ORDER BY locator_id DESC"
  
       myadapter.SelectCommand = mycommand
       myadapter.Fill(mydata)
  
       DataGridView1.DataSource = mydata
       DataGridView1.Refresh()
  End Sub
  </code></pre>
  
  <p>This is the image:</p>
  
  <p><a href="https://i.stack.imgur.com/d3yiT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d3yiT.png" alt="result"></a></p>
  
  <p>As you can see <code>Official?</code> column is not checkbox.</p>
  
  <p>Now, I want <code>Official?</code> to be checkbox column. The value in <code>Official?</code> column is only 1 and 0. When the value is 1 checkbox should be check otherwise uncheck. How to achieve this?</p>