如何在数据库中建表

[xiaoyaofan]

我在页面中放了一个文本框，然后在SqlCommand sqlcom=new SqlCommand("create database 数据库名");
我用的数据库名是变量，是从文本框中取的值，现在想在这个新建的数据库上建表要怎样建
use 数据库名，数据库名写变量是不对的，怎样写呢?求助!!!

[copico]

strSQL = "CREATE TABLE FileCaption(" & _
"id int not null IDENTITY PRIMARY KEY ," & _
"FileName varchar(512) not null," & _
"FileAssoc varchar(255) ," & _
"FileTitle varchar(255) ," & _
"Folder varchar(50) ," & _
"lsOpen bit ," & _
"TreeNode varchar(50) ," & _
"FileDeny int ," & _
"StartTime datetime ," & _
"FilePath varchar(260) ," & _
"lsRefresh bit ," & _
"fileld int )"

[xiaoyaofan]

FileCaption是什么东西，我建的数据库名取的是页面上文本框中的值，是一个变量，如果我在文本框中输入的是aa，那我就在这个aa库上建个BB表，语句怎样写?

[copico]

dim BB as string
BB="bb"
将建一个以bb名字的表
strSQL = "CREATE TABLE '"& BB &"'(" & _
"id int not null IDENTITY PRIMARY KEY ," & _
"FileName varchar(512) not null," & _
"FileAssoc varchar(255) ," & _
"FileTitle varchar(255) ," & _
"Folder varchar(50) ," & _
"lsOpen bit ," & _
"TreeNode varchar(50) ," & _
"FileDeny int ," & _
"StartTime datetime ," & _
"FilePath varchar(260) ," & _
"lsRefresh bit ," & _
"fileld int )"
至于aa库,这个是你连接的时候写进去的

[xiaoyaofan]

不写use aa（库名）
的话,那你的表不定建到哪个库里去了呢，

[Goheadon]

use aa你知道了还问？

[Goheadon]

可以结贴了

[xiaoyaofan]

当然不知道了，哪个“aa”这个库名是取的文本框里的值，我就是想问怎摸才能把表建到你在文本框里输入的这个库里呢