|
Ïðåäñòàâëåíèå çàïèñåé â òàáëè÷íîì âèäå
Äëÿ âûâîäà çàïèñåé íàáîðà äàííûõ â òàáëè÷íîì âèäå óäîáíî èñïîëüçîâàòü ñåòêó – êîìïîíåíò DBGrid. Âíåøíèé âèä ñåòêè ñîîòâåòñòâóåò âíóòðåííåé ñòðóêòóðå òàáëèöû áàçû äàííûõ è íàáîðà äàííûõ, ïðè ýòîì ñòðîêå ñåòêè (êîìïîíåíòà) ñîîòâåòñòâóåò çàïèñü (êîðòåæ), à ñòîëáöó – ïîëå (äîìåí). Ñâîéñòâà ñåòêè:
|
Ñâîéñòâî |
Îïèñàíèå |
|
Columns |
Îïèñûâàåò ñòîëáöû ñåòêè |
|
FieldCount |
Äîñòóïíî âî âðåìÿ âûïîëíåíèÿ ïðîãðàììû è ñîäåðæèò ÷èñëî âèäèìûõ ñòîëáöîâ ñåòêè |
|
Fields |
Ïîçâîëÿåò ïîëó÷èòü äîñòóï ê îòäåëüíûì ñòîëáöàì (ïðèíèìàåò çíà÷åíèÿ â èíòåðâàëå îò 0 äî FieldCount-1) |
|
FixedColor |
Çàäàåò öâåò ôèêñèðîâàííûõ ýëåìåíòîâ ñåòêè |
|
TitleFont |
Îïðåäåëÿåò øðèôò, èñïîëüçóåìûé äëÿ âûâîäà çàãîëîâêîâ ñòîëáöîâ |
Äîñòóï ê ïàðàìåòðàì ñåòêè âîçìîæåí ÷åðåç ñâîéñòâî Options:
|
Ñâîéñòâî |
Îïèñàíèå |
|
dgEditing |
Ïîëüçîâàòåëþ ðàçðåøàåòñÿ ðåäàêòèðîâàíèå äàííûõ â ÿ÷åéêå (true) |
|
dgTitles |
Îòîáðàæàþòñÿ çàãîëîâêè ñòîëáöîâ (true) |
|
dgIndicator |
Äëÿ çàïèñè â íà÷àëå ñòðîêè âûâîäèòñÿ óêàçàòåëü (true) |
|
dgColumnResize |
Ïîëüçîâàòåëü ìîæåò ñ ïîìîùüþ ìûøè èçìåíÿòü ðàçìåð ñòîëáöîâ (true) |
|
dgColLins |
Ìåæäó ñòîëáöàìè âûâîäÿòñÿ ðàçäåëèòåëüíûå âåðòèêàëüíûå ëèíèè |
|
dgRowLins |
Ìåæäó ñòðîêàìè âûâîäÿòñÿ ðàçäåëèòåëüíûå ãîðèçîíòàëüíûå ëèíèè |
|
dgTabs |
Äëÿ ïåðåìåùåíèÿ ïî ñåòêè ìîæíî èñïîëüçîâàòü êëàâèøè Tab è Shift+Tab |
|
dgRowSelect |
Ïîëüçîâàòåëü ìîæåò âûäåëèòü öåëóþ ñòðîêó (èãíîðèðóåòñÿ çíà÷åíèå dgEditing) |
|
dgMultiSelect |
 ñåòêå ìîæíî îäíîâðåìåííî âûäåëèòü íåñêîëüêî ñòðîê |
Ïî óìîë÷àíèþ äëÿ êàæäîãî ïîëÿ íàáîðà äàííûõ, ñâÿçàííîãî ñ êîìïîíåíòîì DBGrid, àâòîìàòè÷åñêè ñîçäàåòñÿ îòäåëüíûé ñòîëáåö, òàêèå ñòîëáöû íàçûâàþòñÿ äèíàìè÷åñêèìè. Äëÿ ñîçäàíèÿ ñòàòè÷åñêèõ ñòîëáöîâ èñïîëüçóåòñÿ Ðåäàêòîð ñòîëáöîâ, äëÿ êîòîðîãî ìîæíî âîñïîëüçîâàòüñÿ êîíòåêñòíûì ìåíþ êîìïîíåíòà DBGrid è âûáðàòü â íåì ïóíêò Columns Editor… Ðåäàêòîð ñòîëáöîâ òàêæå ìîæíî âûçâàòü ñ ïîìîùüþ ñâîéñòâà Columns â Èíñïåêòîðå îáúåêòîâ. Ïåðâîíà÷àëüíî ñïèñîê ñòàòè÷åñêèõ ñòîëáöîâ ïóñò.
Ñâîéñòâà îáúåêòà ñòîëáöà:
|
Ñâîéñòâî |
Îïèñàíèå |
|
Alignment |
Âûðàâíèâàíèå çíà÷åíèé â ÿ÷åéêàõ ñòîëáöà |
|
FieldName |
Îïðåäåëÿåò îáúåêò ïîëÿ íàáîðà äàííûõ, ñâÿçàííûé ñî ñòîëáöîì |
|
PickList |
Ïðåäñòàâëÿåò ñîáîé ñïèñîê äëÿ âûáîðà çàíîñèìûõ â ïîëå çíà÷åíèé |
|
Width |
Øèðèíà ñòîëáöà |
Ñâîéñòâî Title (çàãîëîâîê) ñòîëáöà ñåòêè:
|
Ñâîéñòâî |
Îïèñàíèå |
|
Alignment |
Âûðàâíèâàíèå çàãîëîâêà |
|
Caption |
Òåêñò çàãîëîâêà |
|
Color |
Öâåò çàãîëîâêà |
|
Font |
Øðèôò çàãîëîâêà |
Èñïîëüçîâàíèå íàâèãàöèîííîãî èíòåðôåéñà
Äëÿ óïðàâëåíèÿ íàáîðîì äàííûõ ìîæíî èñïîëüçîâàòü íàâèãàòîð – DBNavigator. Îí ïî âíåøíåìó âèäó ïîõîæ íà ìóëüòèìåäèéíûé ïðîèãðûâàòåëü. Íàâèãàòîð ñîäåðæèò êíîïêè äëÿ âûïîëíåíèÿ ðàçëè÷íûõ îïåðàöèé ñ íàáîðîì äàííûõ ïóòåì àâòîìàòè÷åñêîãî âûçîâà ñîîòâåòñòâóþùèõ ìåòîäîâ. Ñîñòàâ âèäèìûõ êíîïîê îïðåäåëÿåò ñâîéñòâî VisibleButtons:
|
Çíà÷åíèå |
Îïèñàíèå |
|
nbFirst |
Ïåðåéòè ê ïåðâîé çàïèñè (ìåòîä First) |
|
nbPrior |
Ïåðåéòè ê ïðåäûäóùåé çàïèñè (ìåòîä Prior) |
|
nbNext |
Ïåðåéòè ê ñëåäóþùåé çàïèñè (ìåòîä Next) |
|
nbLast |
Ïåðåéòè ê ïîñëåäíåé çàïèñè (ìåòîä Last) |
|
nbInsert |
Âñòàâèòü íîâóþ çàïèñü (ìåòîä Insert) |
|
nbDelete |
Óäàëèòü òåêóùóþ çàïèñü (ìåòîä Delete) |
|
nbEdit |
Ðåäàêòèðîâàòü òåêóùóþ çàïèñü (ìåòîä Edit) |
|
nbPost |
Óòâåðäèòü ðåçóëüòàò èçìåíåíèÿ çàïèñè (ìåòîä Post) |
|
nbCancel |
Îòìåíèòü èçìåíåíèÿ â òåêóùåé çàïèñè (ìåòîä Cancel) |
|
nbRefresh |
Îáíîâèòü èíôîðìàöèþ â íàáîðå äàííûõ (ìåòîä Refresh) |
Ñâîéñòâà DBNavigator:
|
Ñâîéñòâî |
Îïèñàíèå |
|
Flat |
Îïðåäåëÿåò âíåøíèé âèä êíîïîê |
|
Hints |
Ïîäñêàçêà äëÿ îòäåëüíîé êíîïêè êîìïîíåíòà |
|
ShowHint |
Îòîáðàæåíèå ïîäñêàçêè |
ñòð. {SITELINK-S380}1{/SITELINK}, 2
| 
