public void createObjectsTable(ref DataSet myDataSet, ref StructFunctions.objectsStruct myDataTableStruct, ref DataTable myTable)
{
//StructFunctions.objectsStruct myDataTableStruct = new StructFunctions.objectsStruct();
string TableName = myDataTableStruct.tableName;
//DataTable myTable = myDataSet.Tables.Add(TableName);
myTable = myDataSet.Tables.Add(TableName);
DataColumnCollection TableCols;
TableCols = myTable.Columns;
//Primary key GUID
DataColumn colGuid = TableCols.Add(myDataTableStruct.GUID_fieldName, typeof(Guid));
colGuid.AllowDBNull = false;
colGuid.Unique = true;
colGuid.DefaultValue = Guid.NewGuid();
myTable.PrimaryKey = new DataColumn[] { colGuid };
//Fields
DataColumn colType = TableCols.Add(myDataTableStruct.Type_fieldName, typeof(int));
DataColumn colTypeDescription = TableCols.Add(myDataTableStruct.Type_Description_fieldName, typeof(string));
DataColumn colID = TableCols.Add(myDataTableStruct.ID_fieldName, typeof(int));
DataColumn colDescription = TableCols.Add(myDataTableStruct.Description_fieldName, typeof(string));
DataTableCollection myDataTableColl = myDataSet.Tables;
}
public DataClass()
{
myDataSet = new DataSet();
objectTypesTable = new DataTable();
createObjectTypesTable(ref myDataSet, ref objectTypeStruct, ref objectTypesTable);
objectTable = new DataTable();
createObjectsTable(ref myDataSet, ref objectStruct, ref objectTable);
objectStruct = new StructFunctions.objectsStruct();
}
public Guid populateObjectRow(ref DataTable myDataTable, StructFunctions.objectsStruct myDataTableStruct)
{
DataRow row = myDataTable.NewRow();
row[myDataTableStruct.GUID_fieldName] = Guid.NewGuid();
row[myDataTableStruct.ID_fieldName] = myDataTableStruct.ID;
row[myDataTableStruct.Type_fieldName] = myDataTableStruct.Type;
row[myDataTableStruct.Type_Description_fieldName] = myDataTableStruct.Type_Description;
row[myDataTableStruct.Description_fieldName] = myDataTableStruct.Description;
myDataTable.Rows.Add(row);
System.Windows.Forms.MessageBox.Show(myDataTable.Rows.Count.ToString());
return((Guid)row[myDataTableStruct.GUID_fieldName]);
}
