public void PopulateCombo(ComboBox combo, TPCIndexField[] keys, int offsetkeys, int noKeys) { combo.Items.Clear(); if (cursor.HasReader()) { dataTableGrid.Table.Load(cursor.Reader); System.Data.DataRowCollection rows = dataTableGrid.Table.Rows; for (int r = 0; r < rows.Count; r++) { string text = ""; string w = ""; for (int i = 0; i < noKeys; i++) { int c = keys[i + offsetkeys].index; text += w + rows[r][c]; w = "|"; } combo.Items.Add(text); } } }
public void GetTable(string tableName, TPCField[] allFields, int offsetFields, int noFields, TPCIndexField[] orderFields, int offsetOrderFields, int noOrderFields) { string query = "SELECT"; string comma = " "; fields = new TPCField[noFields]; for (int i=0; i<noFields; i++) { fields[i] = allFields[offsetFields + i]; query += comma + fields[i].name; comma = ", "; } dataTableGrid = new DataTableGrid(tableName); dataTableGrid.MakeTableColumns(fields); query += comma + UsId + ", " + TmStamp + " FROM " + tableName; if (Lookup.Length > 0) query += " " + Lookup; else query += " WHERE ROWNUM <= 1000"; if (noOrderFields > 0) { string orderBy = " ORDER BY"; comma = " "; for (int i = 0; i < noOrderFields; i++) { int no = orderFields[offsetOrderFields + i].index; TPCField field = fields[no]; orderBy += comma + field.name; comma = ", "; } query += orderBy; } cursor.Format(query, 0); if (ShowSQL) LogDebug = query; cursor.Run(); }