/// <summary> /// Creates <see cref="DataSourceConverter{DataRow}"/>s based off the <see cref="DataTable"/>. Defaults to all /// columns defined in each <see cref="DataTable"/> /// </summary> /// <param name="table">DataTable</param> /// <returns>DataSource Converter</returns> public static DataSourceConverter<DataRow> CreateDefaultDataTableConverter(DataTable table) { DataSourceConverter<DataRow> converter = new DataSourceConverter<DataRow>(); foreach (DataColumn column in table.Columns) { converter.Fields.Add(new AdapterBoundField<DataRow>(column.ColumnName)); } return converter; }
/// <summary> /// Builds data repository from sources and handle conversion of data sources /// </summary> private void GetDataSourceDefinitions() { // read new sources from remote byte[] buf = ApplicationSourcesManager.GetInstance().ReadSource(dataDefinitionIdsUrl, true); this.DataSourceBuilder.DataSourceReader = GetDataSourceBuffer; new DataSourceDefinitionManagerSaxHandler(buf, this); if (CommandsProcessorManager.SessionStatus == CommandsProcessorManager.SessionStatusEnum.Remote) { // handle data source conversion if modified definition have any change related to database DataSourceConverter dataSourceConverter = ClientManager.Instance.LocalManager.DataSourceConverter = new DataSourceConverter(); dataSourceConverter.NewDataSourceRepositoryContents = buf; dataSourceConverter.HandleRepositoryChanges(this, dataDefinitionIdsUrl); } }
public void WithCustomConverters() { DataSetConverter converter = new DataSetConverter(); DataSourceConverter<DataRow> table1Converter = new DataSourceConverter<DataRow>(); table1Converter.Fields.Add(new AdapterBoundField<DataRow>("Name", "Character Name")); table1Converter.Fields.Add(new AdapterBoundField<DataRow>("Age", "Age", "{0:###}")); converter.TableAdapters.Add(table1Converter); converter.TableAdapters.Add(DataSetConverter.CreateDefaultDataTableConverter(_data.Tables[1])); XlsDocument doc = new XlsDocument(); converter.CreateDocument(doc, _data); Assert.AreEqual(_data.Tables.Count, doc.Workbook.Worksheets.Count); DataSourceConverterTest.ValidateWorksheetFromDataTable(doc.Workbook.Worksheets[0], _data.Tables[0]); ValidateSheetFromDataTable(doc.Workbook.Worksheets[1], _data.Tables[1]); }
public SqlFileConnectionProperties(string defaultInstanceName) { _defaultDataSource = "."; if (defaultInstanceName != null && defaultInstanceName.Length > 0) { _defaultDataSource += "\\" + defaultInstanceName; } else { DataSourceConverter conv = new DataSourceConverter(); System.ComponentModel.TypeConverter.StandardValuesCollection coll = conv.GetStandardValues(null); if (coll.Count > 0) { _defaultDataSource = coll[0] as string; } } LocalReset(); }