/// <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);
}
}
