ADOConnection如何使用sql语句？最好给个简单例子

Question

先回答者得分！

Answer 1

adodataset1.conection:=adoconnection1
adodataset1.commandText:="sql"

Answer 2

qry_temp的conection指向ADOConnection1，ADOConnection1的connectionstring类似与
Provider=MSDAORA.1;Password=...;User ID=...;Data Source=...
with dm.qry_temp do
  begin
    close;
    sql.Clear;
    sql.Add('SELECT DISTINCT DWMC00 FROM GSTGSGL0 WHERE DWDM00='''+compcode+'''');
    prepared;
    open;
  end;

Answer 3

use query to execute sql,not use connection to do this.