procedure TForm1.Button1Click(Sender: TObject); begin DataSource1.DataSet := Query1; DBGrid1.DataSource := DataSource1; Query1.Close; Query1.SQL.Text := format('select * from book where author = %s', [edit1.text]); Query1.Open; end;
我看见过有人用 query1.close; query1.sql.add('select * from 表名 where 字段='''+edit1.text+''''); query1.open; 不知道可不可以用啊?
procedure TForm1.searchOnClick(sender:Tobject) var str:string; begin str:='select * from table where name='+#39+edit.text+#39+; dateSource1.dateset:=QryGrid; dbGrid.datesource:=datesource1; with QryGrid do begin close; sql.clear; sql.add(str); open; end; end;
button_click begin adoquery.close; adoquery.sql.text := 'select * from table where name=''' + edtName.text + ''''; adoquery.open; end; 设置dbgrid的datasource = DataSouce1; 设置DataSouce1的dataset 为 adoquery.
query1.close; query1.sql.clear; query1.sql.add('select * from 表名 where 字段='"+edit1.text+"') query1.open
procedure TForm1.Button1Click(Sender: TObject);
begin
DataSource1.DataSet := Query1;
DBGrid1.DataSource := DataSource1;
Query1.Close;
Query1.SQL.Text := format('select * from book where author = %s', [edit1.text]);
Query1.Open;
end;
query1.close;
query1.sql.add('select * from 表名 where 字段='''+edit1.text+'''');
query1.open;
不知道可不可以用啊?
var
str:string;
begin
str:='select * from table where name='+#39+edit.text+#39+;
dateSource1.dateset:=QryGrid;
dbGrid.datesource:=datesource1;
with QryGrid do
begin
close;
sql.clear;
sql.add(str);
open;
end;
end;
begin
adoquery.close;
adoquery.sql.text := 'select * from table where name=''' + edtName.text + '''';
adoquery.open;
end;
设置dbgrid的datasource = DataSouce1;
设置DataSouce1的dataset 为 adoquery.
query1.sql.clear;
query1.sql.add('select * from 表名 where 字段='"+edit1.text+"')
query1.open