How to use Delphi SQL database table from extracting a specific data?-CodePudding

For the above-mentioned in 68 (the first line of the third column) and 87 (the first line in the fourth column) respectively in Edit1 and Edit2!

I am a beginner, to help, explain the

CodePudding user response:

ADOQuery1. Close;
ADOQuery1. SQL. Text:='select * from table_score where bh=', '009' ' './/in the lookup table Numbers for only 009 students
ADOQuery1. Open;
Edit1. Text:=ADOQuery1. Fieldbyname (' yw). AsString;//will he scores in Chinese shows to Edit1
Edit2. Text:=ADOQuery1. Fieldbyname (' sx). AsString;//will show his math scores to Edit2

CodePudding user response:

On the first floor is the solution,

CodePudding user response:

Say is a novice, detail first establish a from, with adoquery, adoconnection, datasource, edit1, 2 to a button in the click event for the it is ok to write the code on the ground floor, there is some basic Settings, controls on online check yourself, now form mostly use cxgrid (no use dbgrid!)

CodePudding user response:

reference i_am_a_fish reply: 3/f

say is a novice, detail first establish a from, with adoquery, adoconnection, datasource, edit1, 2 to a button in the click event for the it is ok to write the code on the ground floor, there is some controls the basic Settings, check on the Internet by yourself, now form mostly use cxgrid (no use dbgrid)

in detail