我想請問一下 我是用ADO元件來做我查詢的動作，我想請問一下該怎麼取得現階段的欄位，並且我按下下一筆的時候，可以順利的跳到下一筆呢？ String SearchNum; SearchNum = Edit1->Text; Form1->ADOQuery1->Close(); Form1->ADOQuery1->SQL->Clear(); Form1->ADOQuery1->SQL->Add("select * from Query where 受訓員工編號 = '" SearchNum "'"); Form1->ADOQuery1->Open(); Form1->Edit2->Text = Form1->ADOQuery1->FieldByName("受訓員工編號")->AsString; Form1->Edit3->Text = Form1->ADOQuery1->FieldByName("姓名")->AsString; Form1->Edit4->Text = Form1->ADOQuery1->FieldByName("單位")->AsString; Form1->Edit5->Text = Form1->ADOQuery1->FieldByName("受訓年度")->AsString; Form1->Edit6->Text = Form1->ADOQuery1->FieldByName("受訓開始日期")->AsString; Form1->Edit7->Text = Form1->ADOQuery1->FieldByName("受訓結束日期")->AsString; Form1->Edit8->Text = Form1->ADOQuery1->FieldByName("主辦單位")->AsString; Form1->Edit9->Text = Form1->ADOQuery1->FieldByName("課程名稱")->AsString; Form1->Memo1->Text = Form1->ADOQuery1->FieldByName("備註")->AsString;

你是要讀取欄位內容?    <欄位內容> ADOQuery1->Fields->Fields[第幾個欄位]->AsString;    <跳下一行> ADOQuery1->Next();    然後用ADOQuery1->Eof來判斷是否"存在"    <玩樂用的SOURCE CODE>

ADOQuery1->Close();
    ADOQuery1->SQL->Clear();
    ADOQuery1->SQL->Add("SELECT * FROM TestDB");
    ADOQuery1->Open();        if (ADOQuery1->IsEmpty())
        ShowMessage("Data Not Found");
    else
    {
        int DataNum = 0;
        AnsiString tempString = "Fields: " AnsiString(ADOQuery1->FieldCount);
        
        while ( !ADOQuery1->Eof )
        {
            for (int b=0; b<4; b  )
            {
                StringGrid1->Cells[b][DataNum 1] = AnsiString(ADOQuery1->Fields->Fields[b]->AsString);
            }
            DataNum  ;
            ADOQuery1->Next();  // Access to the NEXT ROW.
        }
        tempString  = " -- Data: "  AnsiString(DataNum);
        Label1->Caption = tempString; 
    }

ㄟ...我想我的表達一開始就錯了！！ 我是想說假設一開始就先查詢到了 A欄位 然後我再按下一筆的時候 會自動的知道是A欄位的下一筆，Show B出來 希望前輩再指教