动态的生成sql数据库该用哪个控件怎样用哟，是不是这样哟(20分)

W

wecluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #1

adocommand1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security Info=False;User ID='''+edit3.text+''';Initial Catalog=msdb;Data Source='''+edit1.text+'''';
adocommand1.commandtext:='create database ;
adocommand1.Execute;

 

H

HeBaisong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #2

知道数据库就可以了，你先连接到服务器的master数据库上，然后用sql语句建立你需要的数据库
再重新连接到你建立的数据库上，不是ok了吗？

 

M

mlzhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #3

adocommand1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security Info=False;User ID='''+edit3.text+''';Initial Catalog=msdb;Data Source='''+edit1.text+'''';

adocommand1.commandtext:='create table aaa(a1 int, a2 int) ;
adocommand1.Execute;

 

W

wecluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #4

用那个控件来执行sql语句呢如是不是用adocommand

 

W

wecluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #5

我是想用edit3.text的值来生成数据库 如我要生成的数据库就是edit3.text的值，
这行代码有错请指教
adocommand1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security Info=False;User ID='''+edit3.text+''';Initial Catalog=msdb;Data Source='''+edit1.text+'''';
adocommand1.commandtext:='create database '''+edit3.text+'''';
adocommand1.Execute;

 

M

mlzhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #6

adocommand1.commandtext:='create database '+''''+edit3.text+'''';

 

W

wecluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #7

运行后出错哟，

 

M

mlzhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #8

写出出错信息。帖上代码。

 

W

wecluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #9

project project1.exe raised exceptior class for eolecxception with
message 'line: Incorrect syntax '数据库名" . process stopped use step
run continue

 

W

wecluo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-30

• #10

rocedure TForm1.Button1Click(Sender: TObject);
begin
代码如下
adocommand1.ConnectionString:='Provider=SQLOLEDB.1;Persist Security Info=False;User ID='''+edit3.text+''';Initial Catalog=msdb;Data Source='''+edit1.text+'''';
adocommand1.CommandText:='create database '+''''+edit2.text+'''';
adocommand1.Execute;


end;

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-31

• #11

with AdoQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Create Database DataBase1');
SQL.Add('On Primary');
SQL.Add('(Name=DataBase1_Data,FileName='C:/MSSQL/DataBase1_Data.MDF'')');
SQL.Add('Log On');
SQL.Add('(Name=DataBase1_Log,FileName='C:/MSSQL/DataBase1_Log.LDF'')');
Prepared;
ExecSQL;
end;