目前我已經完成連結的部份，但是我還想多一個能夠Sort功能，也就是說在我的 資料欄中有1.Number 2.Name 3. date 等資料，如Name 有 jack，andy，John， werdy等人名。但是我要如何才能接收(access)到這些資料，拿來做Sorting的事呢? 謝謝 ex. Number Name date 1 jack 1972/10 2 andy 1982/5 3 john 1962/4 . . . . . .

    int dbgrid1_id;
bool dbgrid1_desc_sorted;    __fastcall TForm1::TfrmQIRTStrip(TComponent* Owner)
    : TForm(Owner)
{
    dbgrid1_id = 0;
    dbgrid1_desc_sorted = false;
}
//-------------------------------------------------------------------    void __fastcall TForm1::DBGrid1TitleClick(TColumn *Column)
{
    if (Column->ID == dbgrid1_id)
        dbgrid1_desc_sorted = !dbgrid1_desc_sorted;
    else
    {
        dbgrid1_desc_sorted = false;
        dbgrid1_id = Column->ID;
    }        try
    {
        Query1->Close();
        Query1->SQL->Clear();
        Query1->SQL->Add("Select * From Table");
        AnsiString sOrder;
        if (!dbgrid1_desc_sorted)
            sOrder = "Order By "   Column->FieldName;
        else
            sOrder = "Order By "   Column->FieldName   " Desc";
        Query1->SQL->Add(sOrder);
        if (!Query1->Prepared)
            Query1->Prepare();
        Query1->Open();
    }
    catch (...)
    {
        ...
    }
}
 

參考看看.

try { Query1->Close(); Query1->SQL->Clear(); Query1->SQL->Add("Select * From Table"); AnsiString sOrder; if (!dbgrid1_desc_sorted) sOrder = "Order By " Column->FieldName; else sOrder = "Order By " Column->FieldName " Desc"; Query1->SQL->Add(sOrder); if (!Query1->Prepared) Query1->Prepare(); Query1->Open(); } furbylin 多謝你的答案。 因為我是用Table來做，所以可能不用query的方法，因此我因為要Sorting每一 column的內容來做排序，只是現在還想不出來。