title: ASP.NET CheckBoxField binding to oracle which has no boolean. Known work around?
body: <p>I have a gridview controller with a set of BoundField columns to my data source. I also have a CheckBoxField that I want checked depending on if that row in the table I get from the database is marked accordingly. The problem is, Oracle does not have a boolean type and ASP.NET is expecting a boolean to mark the check box. Is there some sort of work around for this?</p>
  
  <p>Here is my gridview with the check box column.</p>
  
  <pre><code>&lt;asp:GridView ID="DeviceGridView" runat="server" CssClass="SmallGridView"  
         DataSourceID="DeviceDataSource" AutoGenerateColumns="False" 
         EmptyDataText="No devices found." CellPadding="4" ForeColor="#333333" 
         GridLines="None"  OnRowCreated="GridView_RowCreated" 
         OnRowDataBound="GridView_RowDataBound"  &gt;
      &lt;FooterStyle CssClass="gridViewFooter" /&gt;
      &lt;RowStyle CssClass="gridViewRow" /&gt;
      &lt;EditRowStyle CssClass="gridViewEditRow" /&gt;
      &lt;SelectedRowStyle CssClass="gridViewSelectedRow" /&gt;
      &lt;HeaderStyle CssClass="gridViewHeader" /&gt;
      &lt;AlternatingRowStyle CssClass="gridViewAltRow" /&gt;
      &lt;Columns&gt;
          &lt;asp:BoundField HeaderText="DeviceID" DataField="device_id" /&gt;
          &lt;asp:BoundField HeaderText="Device Type" DataField="device_type" /&gt;
          &lt;asp:BoundField HeaderText="Description" DataField="description" /&gt;
          &lt;asp:BoundField HeaderText="Enable Logging" DataField="enable_logging" /&gt;
          &lt;asp:CheckBoxField DataField="normal_toggle" Text="Normal User Logging" /&gt;
      &lt;/Columns&gt;
   &lt;/asp:GridView&gt;
  </code></pre>