hi everybody,

my problem is:

i have one dinamic checkboxlist. User is allow to check more than 1 .
I don't know how to read the data as the data will be use in sql statement.

__________________
Suzila

run a for-next loop on the array.
reading each check list's values one by one.
and put the results in an array of boolean.

then use this function to translate the 1-0-1-..
combination in the array to an integer.

and then use simple SQL line to insert this integer to
the database.


---------- code ------------------

 Private Function make_int_no(ByVal arr As Boolean(), ByVal size As Integer) As Integer
        Dim result As Integer = 0
        Dim i As Integer
        For i = 0 To size - 1
            result = result + arr(i) * (2 ^ i)
        Next
        Return (-result) ' because true is -1
    End Function

----------------------------------------


that's it!
hope it helped,
and im not too mysterious here.. :)

I don't like storing Boolean data this way. It is the most efficient, but it is very hard to read the data if you are using SQL tools. Also it is very difficult if you want to search. I would personally store each Boolean in a char(1) or a bit data type. SQL Server will optimize how it stores bits, and if there are < 9 in a table they will be consolidated to a byte for you. But you still can access/view them as bits. The only down side is that you can't index them. But an index on a Boolean type isn't very useful, as it really only splits the data into two groups anyway.


John R Lick
[email protected]