How to create a Dynamic check box?

[lucky m]

Hi..
I am displaying database table on the form. Now i want to create a dynamic check box(it should place a checkbox for each row).If i check the check box it will add to database..
Can anyone guide me how to create a dynamic checkbox.

[jhardman]

Give a few more details: does the checkbox correspond to a database field (in other words you have a db field that is a true/false or yes/no ) or you have a form on your page and if they check the box then submit, you want to add a new record to the db with the info that is in the rest of the form?

Jared

[lucky m]

@Jhardman..
Thanks for helping me..

I have create a boolean(bit) column in sql table. But I haven't enter any data to that column..

Is it possible to display checkbox for each row..
(here comes my problem..I don't need all checkboxes are true.only one row need to be checked and same time i am displaying sql data on form ).


This is what it leading a problem for me..

atleast give me some idea what i have to do for best design of form..