[dba-VB] Displaying SQL Bit Data Type As Checkbox

Seth D. Galitzer sgsax at ksu.edu
Tue Dec 30 21:11:16 CST 2003


I don't know about specific caveats for a data grid control (or for converting 
data on the fly from SQL server for that matter), but does using CBool() 
(either in a stored proc or setting the checkbox value in the OnCurrent event) 
not work?


>===== Original Message From paul.hartland at fsmail.net, 
dba-vb at databaseadvisors.com =====
>To all,
>We are in the process of converting an old Access application to a Visual 
Basic 6 front-end and SQL Server 7.0 back-end.  The problem I am getting is 
how to display a Bit Data Type as a Checkbox in a DataGrid.
>Has anyone ever done this and can tell me how to go about it
>Thanks in advance.
>Paul Hartland
>Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month
>dba-VB mailing list
>dba-VB at databaseadvisors.com

The beatings will continue until morale has improved.

More information about the dba-VB mailing list