ADOQuery1->SQL->Clear();
sql="select distinct NAME from TmpTable order by NAME";
ADOQuery1->SQL->Add(sql);
ADOQuery1->Open();
sum=ADOQuery1->RecordCount;
while(sum-->0)
{
TreeView1->Items->Add(0,ADOQuery1->Fields->Fields[0]->AsString);
ADOQuery1->Next();
}
ADOQuery1->Close();