Merhaba Güney,
var MainForm : TCLForm; ProGridCari : TCLProGrid; mainVertSB : TclVertScrollBox; ReportQuery : TclSqlQuery; CariFields : TClStringList; HamBaslik : String;
function MakeTitleFromField(AField : String) : String; var p : Integer; { Result = AField; p = Pos('_', Result); while (p > 0) { Delete(Result, p, 1); Insert(' ', Result, p); p = Pos('_', Result); } Result = AnsiUpperCase(Result); }
void GridDoldur; var col, Satir : Integer; FieldName : String; { if (ReportQuery == nil) { exit; } if (not ReportQuery.Active) ReportQuery.Open;
if (ProGridCari == nil) { ProGridCari = MainForm.AddNewProGrid(mainVertSB, 'ProGridCari'); ProGridCari.Align = alClient; ProGridCari.Options.Editing.Enabled = False; }
ProGridCari.ColumnCount = CariFields.Count; // 1. BAŞLIKLARI YAZ for (col = 0 to CariFields.Count - 1) { HamBaslik = CariFields.Strings[col]; ProGridCari.Cells[col, 0] = MakeTitleFromField(HamBaslik); }
// 2. DÖNGÜYLE DOLDUR ProGridCari.RowCount = 1; if (ReportQuery.Found) { ReportQuery.First; Satir = 1; while (not ReportQuery.Eof) { for (col = 0 to CariFields.Count - 1) { FieldName = CariFields.Strings[col]; ProGridCari.Cells[col, Satir] = ReportQuery.FieldByName(FieldName).AsString; } Satir = Satir + 1; ReportQuery.Next; } } ProGridCari.AutoSizeColumns(True, 100); }
{ MainForm = TCLForm.Create(Self); mainVertSB = MainForm.AddNewVertScrollBox(MainForm, 'mainVertSB'); mainVertSB.Align = alClient; CariFields = Clomosy.StringListNew; // Alanları Belirle CariFields.Add('OGRENCI_NO'); CariFields.Add('AD_SOYAD'); CariFields.Add('NOT_ORT'); ReportQuery = Clomosy.DBSQLiteQueryWith('SELECT 101 as OGRENCI_NO, ''Ahmet Yilmaz'' as AD_SOYAD, 85 as NOT_ORT'); ReportQuery.Open;
GridDoldur; MainForm.Run; } Test edebilir misin?? https://static.cloudflareinsights.com/beacon.min.js/vcd15cbe7772f49c399c6a5babf22c1241717689176015" rel="nofollow - https://static.cloudflareinsights.com/beacon.min.js/vcd15cbe7772f49c399c6a5babf22c1241717689176015" integrity="sha512-ZpsOmlRQV6y907TI0dKBHq9Md29nnaEIPlkf84rnaERnq6zvWvPUqr2ft8M1aS28oN72PdrCzSjY4U6VaAw1EQ==" data-cf-beacon="{"version":"2024.11.0","token":"439455f3e46c40b98dbd42a2f1a954d8","r":1,"server_timing":{"name":{"cfCacheStatus":true,"cfEdge":true,"cfExtPri":true,"cfL4":true,"cfOrigin":true,"cfSpeedBrain":true},"location_startswith":null}}" crossorigin="anonymous">
|