Baza danych Firebird, połaczenie poprzez SimpleDataSet, zapytanie do bazy danych SQLQuery.
do komponentu DBGrid wpisuję dane z tablicy przy pomocy poniższego kodu:
KOD cpp: UKRYJ
DM1->SQLQuery1->SQL->Add("SELECT USERS.USERS_NAME FROM USERS ORDER BY USERS.USERS_NAME");
DM1->SQLQuery1->ExecSQL();
for(DM1->SQLQuery1->Open();!DM1->SQLQuery1->Eof;DM1->SQLQuery1->Next())
{
DBComboBox1->Items->Add(DM1->SQLQuery1->Fields->Fields[0]->AsAnsiString);
}
DBComboBox1->ItemIndex=4;
DM1->SQLQuery1->ExecSQL();
for(DM1->SQLQuery1->Open();!DM1->SQLQuery1->Eof;DM1->SQLQuery1->Next())
{
DBComboBox1->Items->Add(DM1->SQLQuery1->Fields->Fields[0]->AsAnsiString);
}
DBComboBox1->ItemIndex=4;
W przypadku komponenty ComboBox taka sytuacja nie ma miejsca
KOD cpp: UKRYJ
DM1->SQLQuery1->SQL->Add("SELECT USERS.USERS_NAME FROM USERS ORDER BY USERS.USERS_NAME");
DM1->SQLQuery1->ExecSQL();
for(DM1->SQLQuery1->Open();!DM1->SQLQuery1->Eof;DM1->SQLQuery1->Next())
{
ComboBox1->Items->Add(DM1->SQLQuery1->Fields->Fields[0]->AsAnsiString);
}
ComboBox1->ItemIndex=0;
DM1->SQLQuery1->ExecSQL();
for(DM1->SQLQuery1->Open();!DM1->SQLQuery1->Eof;DM1->SQLQuery1->Next())
{
ComboBox1->Items->Add(DM1->SQLQuery1->Fields->Fields[0]->AsAnsiString);
}
ComboBox1->ItemIndex=0;