得到表名,放在一个STRINGLIST变量里: var tablename:TStringlist; begin tablename:=TStringList.Create; ADOConnection.GetTableNames(tablename,false); end;
前提,你要先用adoconnection1连接到你要查看的数据库! procedure TForm1.Button1Click(Sender: TObject); var str:tstringlist; i:integer; begin str:=tstringlist.Create; adoconnection1.GetTableNames(str,false); for i:=0 to str.Count-1 do listbox1.Items.Add(str.Strings[i]); end; 呵呵,可以给分了吧!
Memo1: TMemo;
……ADOCon.adocon.GetTableNames(memo1.Lines);memo1.Lines中间的字符就是你的表名!
TSession.GetTableNames即可取得数据库中所有的表名。
ADOCon: TADOConnection;
Memo1: TMemo;
……ADOCon.GetTableNames(memo1.Lines);memo1.Lines中间的字符就是你的表名!
var
tablename:TStringlist;
begin
tablename:=TStringList.Create;
ADOConnection.GetTableNames(tablename,false);
end;
procedure TForm1.Button1Click(Sender: TObject);
var
str:tstringlist;
i:integer;
begin
str:=tstringlist.Create;
adoconnection1.GetTableNames(str,false);
for i:=0 to str.Count-1 do
listbox1.Items.Add(str.Strings[i]);
end;
呵呵,可以给分了吧!