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; }
//获取打开表的列名 public ActionResult GetTableCols(string id) { dtOpen = DelNullRow(dsRead.Tables[int.Parse(id)]); string[] cols = new string[dtOpen.Columns.Count]; for (int i = 0; i < cols.Length; i++) { cols[i] = dtOpen.Columns[i].ColumnName; } TableCols Cs = new TableCols(); Cs.Cols = cols; return(Json(Cs, "text/html;charset=utf-8", JsonRequestBehavior.AllowGet)); }