//---------------------------------------------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "stud.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TStudForm *StudForm;
//---------------------------------------------------------------------------
__fastcall TStudForm::TStudForm(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TStudForm::FormClose(TObject *Sender, TCloseAction &Action)
{
     Action = caFree;          
}
//---------------------------------------------------------------------------
void __fastcall TStudForm::Button4Click(TObject *Sender)
{
    DBNavigator1->BtnClick(nbFirst);         
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button3Click(TObject *Sender)
{
    DBNavigator1->BtnClick(nbPrior);        
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button2Click(TObject *Sender)
{
     DBNavigator1->BtnClick(nbNext);        
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button5Click(TObject *Sender)
{
   DBNavigator1->BtnClick(nbLast);        
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button6Click(TObject *Sender)
{
     DBNavigator1->BtnClick(nbInsert);        
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button7Click(TObject *Sender)
{
    DBNavigator1->BtnClick(nbDelete);        
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button8Click(TObject *Sender)
{
    DBNavigator1->BtnClick(nbEdit);        
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button9Click(TObject *Sender)
{
    DBNavigator1->BtnClick(nbCancel);
}
//---------------------------------------------------------------------------


void __fastcall TStudForm::FormCreate(TObject *Sender)
{
    AnsiString tmp;
    
    ADOQuery1->Close();
    ADOQuery1->SQL->Clear();
    ADOQuery1->SQL->Add("select distinct Class_ID From Class");
    ADOQuery1->Open();
    if(ADOQuery1->RecordCount!=0)
    {
        ADOQuery1->First();
        while(!ADOQuery1->Eof)
        {
            tmp = ADOQuery1->FieldByName("Class_ID")->AsInteger;
            ComboBox1->AddItem(tmp, this);
            ADOQuery1->Next();
        }
    }
}
//---------------------------------------------------------------------------

void __fastcall TStudForm::Button1Click(TObject *Sender)
{
     ADOTable1->Active = false;
     if (ComboBox1->Text != "")
     {
         ADOTable1->Filter = "Class_ID = '" + ComboBox1->Text + "'";
     }
     ADOTable1->Filtered = true;
     ADOTable1->Active = true;
}
//---------------------------------------------------------------------------