how to create table to database when program is running

[ohohling]

i have developer a lab system...
the lab system include multi test...each test have many sub test
user can select which test they want
the problem i face know is...
after they choose the test n run the test... the table need to store to database

i dunno how to generate the table from vb.net to ms sql server by coding.

coz everytime we link the vb.net interface to database by createing a table on database 1st. but this time i hv to create the table when the system running..

izit i possible to do this....anyone got example or idea to do it...
thanks

[chmonalisa]

hello

Please correct me If i am wrong.

What you need is to create a table in ur database and store the details whenver a user runs the test .

right? if it so then here it is

simply use a command object

sqlcommand.commandtext="create table table1 (col1 varchar(10),col2 varchar(20)"

sqlcommand.executenonquery()

this should work.

Thanks,
Chaitanya.

[ohohling]

hello

Please correct me If i am wrong.

What you need is to create a table in ur database and store the details whenver a user runs the test .

right? if it so then here it is

simply use a command object

sqlcommand.commandtext="create table table1 (col1 varchar(10),col2 varchar(20)"

sqlcommand.executenonquery()

this should work.

Thanks,
Chaitanya.

thanks... it help....:cheesy:

[Shum]

My advice to you is to use an sql command object.For example
dim cmd as sqlcommand
then connect using a connector. I'm assuming u already know how to do this.
You use the command objects command text property to insert sql commands and send them to the database.
example
cmd.commandtext= "Create table user......"
you then execute the command
cmd.executenonquery()