var mysql: string; begin mysql:='select '''+edit1.text+''' from yourtable'; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add(mysql); ADOQuery1.Active := true; end;
var mysql: string; begin mysql:='select '''+edit1.text+''' from yourtable'; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add(mysql); ADOQuery1.Active := true; end;
dbgrid.datasource:=datasource1;
表的active:=true;就可以显示了
如果需要返回值可以使用ADOQuery或ADODataSet,如何绑定楼上说了
ADODataSet1.Connection := cnnA;
ADODataSet1.CommandType := cmdText;
ADODataSet1.CommandText := 'select * from tb_temp';
ADODataSet1.Open;
DataSource1.DataSet := ADODataSet1;
ADOQuery1.Connection := cnnA;
ADOQuery1.SQL.Text := 'select * from tb_send';
ADOQuery1.Open;
DataSource1.DataSet := ADOQuery1;
mysql: string;
begin
mysql:='select '''+edit1.text+''' from yourtable';
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(mysql);
ADOQuery1.Active := true;
end;
ADODataSet1.Connection := cnnA;
ADODataSet1.CommandType := cmdText;
ADODataSet1.CommandText := 'select * from tb_temp';
ADODataSet1.Open;
DataSource1.DataSet := ADODataSet1;
2.
dbgrid.datasource:=datasource1;3.ok!
mysql: string;
begin
mysql:='select '''+edit1.text+''' from yourtable';
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(mysql);
ADOQuery1.Active := true;
end;