public FrmDatabaseImportExplorer(Connector.SgbdType sgbdType, String connectionString, DataBase db) { InitializeComponent(); _connectionString = connectionString; _sgbdType = sgbdType; _appReader = new AppSettingsReader(); _db = db; populateTreeView(); ((DataGridViewComboBoxColumn)dgvDataType.Columns["DataTypeTargetColumn"]).DataSource = _lstDt; ((DataGridViewComboBoxColumn)dgvDataType.Columns["DataTypeTargetColumn"]).DisplayMember = "Name"; ((DataGridViewComboBoxColumn)dgvDataType.Columns["DataTypeTargetColumn"]).ValueMember = "Name"; DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell(); cell.ValueType = typeof(Int64); dgvDataType.Columns[5].CellTemplate = cell; _mapper = new DataTypeMapper(_sgbdType); }
public string GetBaseStruct(string baseName, List<DataImportTable> tableList) { StringBuilder sb = new StringBuilder(); sb.AppendLine(baseName); sb.AppendLine(tableList.Count.ToString()); DataTypeMapper dtm = new DataTypeMapper(_sgbdType); foreach (DataImportTable table in tableList) { sb.AppendLine(); sb.AppendLine(String.Format("\"{0}\" {1} {2} {3}", table.Name, table.Order.ToString(), table.Count.ToString(), table.Columns.Count.ToString())); foreach (DataImportColumn column in table.Columns) { string finalType = dtm.Map(column.DataType); string length = dtm.MapLength(column.DataType, column.Size); if (finalType == "VARCHAR" || finalType == "VARCHAR2") if (length != string.Empty) length = ((Int64.Parse(length) + 1)).ToString(); sb.AppendLine(String.Format("\"{0}\" {1} {2} {3}", column.Name, column.Order.ToString(), length, finalType)); } } return sb.ToString(); }