我用ADOQuery、DataSource、DBGrid显示表内容,代码如下:procedure TForm1.FormCreate(Sender: TObject);
begin
ADOQuery1.ConnectionString:=连接串;
adoquery1.Active:=True ;
//adoquery1.SQL:='SELECT * FROM Car'; 这一句出错
adoquery1.Open;
DataSource1.dataset:=adoquery1;
DBGrid1.DataSource:=datasource1;
end;我ADOQuery的SQL属性里改成“SELECT * FROM Car”显示没问题,但我想在程序里写就出错了,请问怎么写呢?
begin
ADOQuery1.ConnectionString:=连接串;
adoquery1.Active:=True ;
//adoquery1.SQL:='SELECT * FROM Car'; 这一句出错
adoquery1.Open;
DataSource1.dataset:=adoquery1;
DBGrid1.DataSource:=datasource1;
end;我ADOQuery的SQL属性里改成“SELECT * FROM Car”显示没问题,但我想在程序里写就出错了,请问怎么写呢?
adoquery1.SQL.Add( 'SELECT * FROM Car');
begin
ADOQuery1.ConnectionString:=连接串;
adoquery1.Active:=True ;
adoquery1.SQL.Text:='SELECT * FROM Car'; 这一句出错
adoquery1.Open;
DataSource1.dataset:=adoquery1;
DBGrid1.DataSource:=datasource1;
end;
begin
ADOQuery1.ConnectionString:=连接串;
adoquery1.Active:=True ; //****注意这里,怎么能Active := True呢?****
adoquery1.SQL.Add('SELECT * FROM Car');
adoquery1.Open;
DataSource1.dataset:=adoquery1;
DBGrid1.DataSource:=datasource1;
end;