有数据表1
结构如下:id st1 st2
1 aaa aa1
2 bbb bbb
(上表没有特殊规律)
欲将表中一列如:ST1列加入到一个COMBOBOX的Items中;
即得可以在COMBOBOX的下拉列表中得到该列数据。应该怎么写,请高手指点谢谢!!!!(补充:祝大家情人节快乐)
(在线等答案。)
结构如下:id st1 st2
1 aaa aa1
2 bbb bbb
(上表没有特殊规律)
欲将表中一列如:ST1列加入到一个COMBOBOX的Items中;
即得可以在COMBOBOX的下拉列表中得到该列数据。应该怎么写,请高手指点谢谢!!!!(补充:祝大家情人节快乐)
(在线等答案。)
I:Integer;
begin
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from tablename');
open;
first;
for I:=0 to recordcount-1 do
begin
combobox1.items.add(fieldbyname('st1').asstring);
end;
close;
end;
end;
begin
ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+ExtractFilePath(Application.ExeName)+'Works.mdb;Persist Security Info=False';//此连接语句请自行修改
SQL.Add('Select * From 表1');
Open;
ComboBox1.Items.Clear;
While Not Eof do
begin
ComboBox1.Items.Add(FieldbyName('st1').AsString;
Next;
end;
Free;
end;
begin
ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+ExtractFilePath(Application.ExeName)+'Works.mdb;Persist Security Info=False';//此连接语句请自行修改
SQL.Add('Select * From 表1');
Open;
ComboBox1.Items.Clear;
While Not Eof do
begin
ComboBox1.Items.Add(FieldbyName('st1').AsString);//刚才这里少了个括号
Next;
end;
Free;
end;
aaa
aaa
也就是第一列复制了两次!!
-----------------------------------------------
var
I:Integer;
begin
with adoquery1 do
begin
close;
sql.clear;
sql.add('select distinct st1 from tablename');
open;
first;
for I:=0 to recordcount-1 do
begin
combobox1.items.add(fieldbyname('st1').asstring);
end;
close;
end;
end;