How to add checkbox column in database dynamically

[krishnaneeraja]

Hi
Iam developing c#.net windows application.In that i want to add some tables programatically .I want to add one table like num integer,name char(50),status yes/no,but i want status field is checkbox.How to add that display control programatically .plz help me.



Thanks & Regards.
Neeraja.

[jeffstl]

Hi
Iam developing c#.net windows application.In that i want to add some tables programatically .I want to add one table like num integer,name char(50),status yes/no,but i want status field is checkbox.How to add that display control programatically .plz help me.



Thanks & Regards.
Neeraja.

You must execute SQL on your database using CREATE TABLE and ALTER TABLE syntax for this.

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
.......
)

ALTER TABLE table_name 
ADD column_name datatype