/// <summary> /// Initialises FieldDataTable /// Pulls Data from the database and generates columns and rows to match the said data /// and inputs that dta afterwards /// </summary> /// <param name="context">Allows it to know which activity it is calling it from</param> /// <param name="Name">Used to Determine which spreadsheet is to be openned</param> public FieldDataTable(Context context, String Name) : base(Name) { FieldTableDB fieldTable = new FieldTableDB(context); string fieldName = "FieldName"; string tableID = "TableID"; string dataType = "DataType"; var dataColumns = new Dictionary <string, float>(); dataColumns.Add(" " + fieldName, 100); dataColumns.Add(tableID, 100); dataColumns.Add(dataType, 100); foreach (var key in dataColumns.Keys) { var dc = new DSDataColumn(key); dc.Caption = key; dc.ReadOnly = true; dc.DataType = typeof(string); dc.AllowSort = true; dc.Width = dataColumns[key]; Columns.Add(dc); } List <string> FieldNameList = fieldTable.readString(fieldName); List <int> TableIDList = fieldTable.readInt(tableID); List <string> DataTypeList = fieldTable.readString(dataType); int row = fieldTable.Count(); for (int i = 0; i < row; i += 1) { var dataRows = new DSDataRow(); dataRows[" " + fieldName] = " " + FieldNameList[i]; dataRows[tableID] = TableIDList[i]; dataRows[dataType] = DataTypeList[i]; Rows.Add(dataRows); } }