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 void createFieldsTable(ref DataSet myDataSet, ref StructFunctions.fieldsStruct myDataTableStruct) { //StructFunctions.fieldsStruct myDataTableStruct = new StructFunctions.fieldsStruct(); string TableName = myDataTableStruct.tableName; DataTable 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 colTable_No = TableCols.Add(myDataTableStruct.Table_No_fieldName, typeof(int)); DataColumn colField_No = TableCols.Add(myDataTableStruct.Field_No_fieldName, typeof(int)); DataColumn colField_Name = TableCols.Add(myDataTableStruct.Field_Name_fieldName, typeof(string)); DataColumn colData_Type = TableCols.Add(myDataTableStruct.Data_Type_fieldName, typeof(string)); DataColumn colLength = TableCols.Add(myDataTableStruct.Length_fieldName, typeof(int)); DataColumn colEnabled = TableCols.Add(myDataTableStruct.Enabled_fieldName, typeof(bool)); DataColumn colDescription = TableCols.Add(myDataTableStruct.Description_fieldName, typeof(string)); DataTableCollection myDataTableColl = myDataSet.Tables; }