public static System.Data.DataTable createDataTable() { var dataTable = new System.Data.DataTable(Guid.NewGuid().ToString()); dataTable.AddColumn(System.Type.GetType("System.Int32"), "userId"); dataTable.AddColumn(System.Type.GetType("System.Int16"), "researchId"); dataTable.AddColumn(System.Type.GetType("System.Byte"), "isCompleted"); dataTable.AddColumn(System.Type.GetType("System.Int32"), "investedResearchpoints"); dataTable.AddColumn(System.Type.GetType("System.Int16"), "researchPriority"); return(dataTable); }
public static System.Data.DataTable createDataTable() { var dataTable = new System.Data.DataTable(Guid.NewGuid().ToString()); DataColumn column; column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "id"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "userId"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "name"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "energy"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "crew"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Byte"); column.ColumnName = "scanRange"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "attack"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "defense"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "hitpoints"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Byte"); column.ColumnName = "damageReduction"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "cargoroom"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int16"); column.ColumnName = "fuelroom"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Decimal"); column.ColumnName = "max_hyper"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Decimal"); column.ColumnName = "max_impuls"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Decimal"); column.ColumnName = "hyper"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Decimal"); column.ColumnName = "impuls"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Boolean"); column.ColumnName = "colonizer"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int64"); column.ColumnName = "population"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "shipHullsImage"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Byte"); column.ColumnName = "hullId"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Byte"); column.ColumnName = "systemX"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Byte"); column.ColumnName = "systemY"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "spaceX"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "spaceY"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "systemId"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "templateId"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Byte"); column.ColumnName = "refitCounter"; dataTable.Columns.Add(column); dataTable.AddColumn(System.Type.GetType("System.Byte"), "noMovementCounter"); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "objectId"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int64"); column.ColumnName = "versionId"; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "experience"; dataTable.Columns.Add(column); return(dataTable); }
private DataTable ParseFile(string FileName) { if (File.Exists(FileName)) { string[] fileLines = File.ReadAllLines(FileName); if (fileLines != null && fileLines.Length > 0) { DataTable dtFWRules = new DataTable(); dtFWRules.AddColumn<string>("Name"); dtFWRules.AddColumn<string>("Group"); dtFWRules.AddColumn<ProfileTypeEnum>("Profile"); dtFWRules.AddColumn<bool>("On"); dtFWRules.AddColumn<FirewallActionTypeEnum>("Allow"); dtFWRules.AddColumn<bool>("Override"); dtFWRules.AddColumn<string>("Program"); dtFWRules.AddColumn<string>("Local IP"); dtFWRules.AddColumn<string>("Remote IP"); dtFWRules.AddColumn<ProtocolTypeEnum>("Protocol"); dtFWRules.AddColumn<string>("Local Ports"); dtFWRules.AddColumn<string>("Remote Ports"); dtFWRules.AddColumn<string>("Allowed Users"); dtFWRules.AddColumn<string>("Allowed Computers"); for (int i = 1; i < fileLines.Length; i++) { string[] lineFields = fileLines[i].Split('\t'); DataRow dr = dtFWRules.NewRow(); dr[0] = lineFields[0];//Name dr[1] = lineFields[1] ?? "";//Group dr[2] = lineFields[2].ParseEnum<ProfileTypeEnum>();//Profile dr[3] = lineFields[3].Matches("yes");//Enabled dr[4] = lineFields[4].ParseEnum<FirewallActionTypeEnum>();//Allow dr[5] = lineFields[5].Matches("yes");//Override dr[6] = lineFields[6];//Program dr[7] = lineFields[7];//Local Address dr[8] = lineFields[8];//Remote Address dr[9] = lineFields[9].ParseEnum<ProtocolTypeEnum>();////Protocol dr[10] = lineFields[10];//Local Port dr[11] = lineFields[11];//Remote Port dr[12] = lineFields[12];//Allowed Users dr[13] = lineFields[13];//Allowed Computers dtFWRules.Rows.Add(dr); } return dtFWRules; } else return null; } else return null; }