public void CancelEdit()
{
DataTable myTable = new DataTable("myTable");
DataColumn dc = new DataColumn("Id", typeof(int));
dc.Unique = true;
myTable.Columns.Add(dc);
myTable.Rows.Add(new object[] { 1 });
myTable.Rows.Add(new object[] { 2 });
myTable.Rows.Add(new object[] { 3 });
DataRow myRow = myTable.Rows[0];
myRow.BeginEdit();
myRow[0] = 7;
myRow.CancelEdit();
// DataRow CancelEdit
Assert.Equal(true, (int)myRow[0] == 1);
}
internal Key(DataTable table,DataColumn[] columns,ListSortDirection[] sort, DataViewRowState rowState, IExpression filter)
{
_table = table;
_filter = filter;
if (_filter != null)
_tmpRow = _table.NewNotInitializedRow();
_columns = columns;
if (sort != null && sort.Length == columns.Length) {
_sortDirection = sort;
}
else {
_sortDirection = new ListSortDirection[columns.Length];
for(int i=0; i < _sortDirection.Length; i++) {
_sortDirection[i] = ListSortDirection.Ascending;
}
}
if (rowState != DataViewRowState.None) {
_rowStateFilter = rowState;
}
else {
// FIXME : what is the correct value ?
_rowStateFilter = DataViewRowState.CurrentRows;
}
}
private DataTable MakeTable()
{
DataTable namesTable = new DataTable("Names");
DataColumn idColumn = new DataColumn();
idColumn.DataType = Type.GetType("System.Int32");
idColumn.ColumnName = "Id";
idColumn.AutoIncrement = true;
namesTable.Columns.Add(idColumn);
DataColumn fNameColumn = new DataColumn();
fNameColumn.DataType = Type.GetType("System.String");
fNameColumn.ColumnName = "Fname";
fNameColumn.DefaultValue = "Fname";
namesTable.Columns.Add(fNameColumn);
DataColumn lNameColumn = new DataColumn();
lNameColumn.DataType = Type.GetType("System.String");
lNameColumn.ColumnName = "LName";
lNameColumn.DefaultValue = "LName";
namesTable.Columns.Add(lNameColumn);
// Set the primary key for the table
DataColumn[] keys = new DataColumn[1];
keys[0] = idColumn;
namesTable.PrimaryKey = keys;
// Return the new DataTable.
return namesTable;
}
internal static DbSchemaRow[] GetSortedSchemaRows(DataTable dataTable, bool returnProviderSpecificTypes)
{
DataColumn sortindex = dataTable.Columns[SchemaMappingUnsortedIndex];
if (null == sortindex)
{
sortindex = new DataColumn(SchemaMappingUnsortedIndex, typeof(int));
dataTable.Columns.Add(sortindex);
}
int count = dataTable.Rows.Count;
for (int i = 0; i < count; ++i)
{
dataTable.Rows[i][sortindex] = i;
};
DbSchemaTable schemaTable = new DbSchemaTable(dataTable, returnProviderSpecificTypes);
const DataViewRowState rowStates = DataViewRowState.Unchanged | DataViewRowState.Added | DataViewRowState.ModifiedCurrent;
DataRow[] dataRows = dataTable.Select(null, "ColumnOrdinal ASC", rowStates);
Debug.Assert(null != dataRows, "GetSchemaRows: unexpected null dataRows");
DbSchemaRow[] schemaRows = new DbSchemaRow[dataRows.Length];
for (int i = 0; i < dataRows.Length; ++i)
{
schemaRows[i] = new DbSchemaRow(schemaTable, dataRows[i]);
}
return schemaRows;
}
public DataViewTest()
{
_dataTable = new DataTable("itemTable");
_dc1 = new DataColumn("itemId");
_dc2 = new DataColumn("itemName");
_dc3 = new DataColumn("itemPrice");
_dc4 = new DataColumn("itemCategory");
_dataTable.Columns.Add(_dc1);
_dataTable.Columns.Add(_dc2);
_dataTable.Columns.Add(_dc3);
_dataTable.Columns.Add(_dc4);
DataRow dr;
_seed = 123;
_rowCount = 5;
_rndm = new Random(_seed);
for (int i = 1; i <= _rowCount; i++)
{
dr = _dataTable.NewRow();
dr["itemId"] = "item " + i;
dr["itemName"] = "name " + _rndm.Next();
dr["itemPrice"] = "Rs. " + (_rndm.Next() % 1000);
dr["itemCategory"] = "Cat " + ((_rndm.Next() % 10) + 1);
_dataTable.Rows.Add(dr);
}
_dataTable.AcceptChanges();
_dataView = new DataView(_dataTable);
_dataView.ListChanged += new ListChangedEventHandler(OnListChanged);
_listChangedArgs = null;
}
private DataView CreateTestView()
{
DataTable dt1 = new DataTable("table1");
DataColumn c1 = new DataColumn("col");
dt1.Columns.Add(c1);
dt1.Rows.Add(new object[] { "1" });
return new DataView(dt1);
}
internal static AbstractDataContainer CreateInstance(Type type, DataColumn column)
{
AbstractDataContainer container;
switch (Type.GetTypeCode(type)) {
case TypeCode.Int16 :
container = new Int16DataContainer();
break;
case TypeCode.Int32 :
container = new Int32DataContainer();
break;
case TypeCode.Int64 :
container = new Int64DataContainer();
break;
case TypeCode.String :
container = new StringDataContainer();
break;
case TypeCode.Boolean:
container = new BitDataContainer();
break;
case TypeCode.Byte :
container = new ByteDataContainer();
break;
case TypeCode.Char :
container = new CharDataContainer();
break;
case TypeCode.Double :
container = new DoubleDataContainer();
break;
case TypeCode.SByte :
container = new SByteDataContainer();
break;
case TypeCode.Single :
container = new SingleDataContainer();
break;
case TypeCode.UInt16 :
container = new UInt16DataContainer();
break;
case TypeCode.UInt32 :
container = new UInt32DataContainer();
break;
case TypeCode.UInt64 :
container = new UInt64DataContainer();
break;
case TypeCode.DateTime :
container = new DateTimeDataContainer();
break;
case TypeCode.Decimal :
container = new DecimalDataContainer();
break;
default :
container = new ObjectDataContainer();
break;
}
container._type = type;
container._column = column;
return container;
}
private void MakeParentTable()
{
// Create a new Table
_parentTable = new DataTable("ParentTable");
_dataSet = new DataSet("XmlSchemaDataSet");
DataColumn column;
DataRow row;
// Create new DataColumn, set DataType,
// ColumnName and add to Table.
column = new DataColumn();
column.DataType = typeof(int);
column.ColumnName = "id";
column.Unique = true;
// Add the Column to the DataColumnCollection.
_parentTable.Columns.Add(column);
// Create second column
column = new DataColumn();
column.DataType = typeof(string);
column.ColumnName = "ParentItem";
column.AutoIncrement = false;
column.Caption = "ParentItem";
column.Unique = false;
// Add the column to the table
_parentTable.Columns.Add(column);
// Create third column.
column = new DataColumn();
column.DataType = typeof(int);
column.ColumnName = "DepartmentID";
column.Caption = "DepartmentID";
// Add the column to the table.
_parentTable.Columns.Add(column);
// Make the ID column the primary key column.
DataColumn[] PrimaryKeyColumns = new DataColumn[2];
PrimaryKeyColumns[0] = _parentTable.Columns["id"];
PrimaryKeyColumns[1] = _parentTable.Columns["DepartmentID"];
_parentTable.PrimaryKey = PrimaryKeyColumns;
_dataSet.Tables.Add(_parentTable);
// Create three new DataRow objects and add
// them to the DataTable
for (int i = 0; i <= 2; i++)
{
row = _parentTable.NewRow();
row["id"] = i + 1;
row["ParentItem"] = "ParentItem " + (i + 1);
row["DepartmentID"] = i + 1;
_parentTable.Rows.Add(row);
}
}
public void Ctor()
{
string colName = "ColName";
DataColumn col = new DataColumn();
//These should all ctor without an exception
col = new DataColumn(colName);
col = new DataColumn(colName, typeof(int));
col = new DataColumn(colName, typeof(int), null);
col = new DataColumn(colName, typeof(int), null, MappingType.Attribute);
}
DataSet CreateDataSet ()
{
DataSet ds = new DataSet (DbProviderFactories.CONFIG_SECTION_NAME);
DataTable dt = ds.Tables.Add (DbProviderFactories.CONFIG_SEC_TABLE_NAME);
DataColumn [] columns = new DataColumn [4];
columns [0] = new DataColumn ("Name", typeof (string));
columns [1] = new DataColumn ("Description", typeof (string));
columns [2] = new DataColumn ("InvariantName", typeof (string));
columns [3] = new DataColumn ("AssemblyQualifiedName", typeof (string));
dt.Columns.AddRange (columns);
dt.PrimaryKey = new DataColumn [] { columns [2] };
return ds;
}
public ColumnManager(int numCols) {
allowedNull = "-";
columnData = new ArrayList(numCols);
for (int i = 0; i < numCols; i++)
{
DataColumn<string> col = new DataColumn<string>("Column " + i);
columnData.Add(col);
columnNames.Add("");
}
}
public void AutoIncrement()
{
DataColumn col = new DataColumn("Auto");
col.AutoIncrement = true;
col.AutoIncrementSeed = 0;
col.AutoIncrementStep = 1;
_tbl.Columns.Add(col);
_tbl.Rows.Add(_tbl.NewRow());
Assert.Equal(0, Convert.ToInt32(_tbl.Rows[0]["Auto"]));
_tbl.Rows.Add(_tbl.NewRow());
Assert.Equal(1, Convert.ToInt32(_tbl.Rows[1]["Auto"]));
col.AutoIncrement = false;
Assert.Equal(1, Convert.ToInt32(_tbl.Rows[1]["Auto"]));
_tbl.Rows.Add(_tbl.NewRow());
Assert.Equal(DBNull.Value, _tbl.Rows[2]["Auto"]);
col.AutoIncrement = true;
col.AutoIncrementSeed = 10;
col.AutoIncrementStep = 2;
_tbl.Rows.Add(_tbl.NewRow());
Assert.Equal(10, Convert.ToInt32(_tbl.Rows[3]["Auto"]));
_tbl.Rows.Add(_tbl.NewRow());
Assert.Equal(12, Convert.ToInt32(_tbl.Rows[4]["Auto"]));
col = new DataColumn("Auto2");
col.DataType = typeof(string);
col.AutoIncrement = true;
col.AutoIncrementSeed = 0;
col.AutoIncrementStep = 1;
_tbl.Columns.Add(col);
_tbl.Rows.Add(_tbl.NewRow());
Assert.Equal(typeof(int), _tbl.Columns[1].DataType);
Assert.Equal(typeof(int), _tbl.Rows[5]["Auto2"].GetType());
col = new DataColumn("Auto3");
col.AutoIncrement = true;
col.AutoIncrementSeed = 0;
col.AutoIncrementStep = 1;
col.DataType = typeof(string);
Assert.Equal(typeof(string), col.DataType);
Assert.False(col.AutoIncrement);
}
public void Generate()
{
Exception tmpEx = new Exception();
DataTable tbl = new DataTable();
tbl.Columns.Add(new DataColumn("Column"));
DataColumn dc = new DataColumn();
dc.Expression = "something"; //invalid expression
// SyntaxErrorException - Column Expression
Assert.Throws<SyntaxErrorException>(() => tbl.Columns[0].Expression = "Colummn +=+ 1"); //invalid expression
// SyntaxErrorException - Select
Assert.Throws<SyntaxErrorException>(() => tbl.Select("Name += something"));
}
public void AllowDBNull()
{
DataColumn col = new DataColumn("NullCheck", typeof(int));
_tbl.Columns.Add(col);
col.AllowDBNull = true;
_tbl.Rows.Add(_tbl.NewRow());
_tbl.Rows[0]["NullCheck"] = DBNull.Value;
try
{
col.AllowDBNull = false;
Assert.False(true);
}
catch (DataException)
{
}
}
public void FillAddWithKey()
{
DataSet ds = new DataSet();
NpgsqlDataAdapter da = new NpgsqlDataAdapter("select field_serial, field_int2, field_timestamp, field_numeric from tableb", TheConnection);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
da.Fill(ds);
DataColumn field_serial = ds.Tables[0].Columns[0];
DataColumn field_int2 = ds.Tables[0].Columns[1];
DataColumn field_timestamp = ds.Tables[0].Columns[2];
DataColumn field_numeric = ds.Tables[0].Columns[3];
Assert.IsFalse(field_serial.AllowDBNull);
Assert.IsTrue(field_serial.AutoIncrement);
Assert.AreEqual("field_serial", field_serial.ColumnName);
Assert.AreEqual(typeof(int), field_serial.DataType);
Assert.AreEqual(0, field_serial.Ordinal);
// version 2 of the protocol doesn't know how to populate the unique field
if (TheConnection.BackendProtocolVersion != ProtocolVersion.Version2)
{
Assert.IsTrue(field_serial.Unique);
}
Assert.IsTrue(field_int2.AllowDBNull);
Assert.IsFalse(field_int2.AutoIncrement);
Assert.AreEqual("field_int2", field_int2.ColumnName);
Assert.AreEqual(typeof(short), field_int2.DataType);
Assert.AreEqual(1, field_int2.Ordinal);
Assert.IsFalse(field_int2.Unique);
Assert.IsTrue(field_timestamp.AllowDBNull);
Assert.IsFalse(field_timestamp.AutoIncrement);
Assert.AreEqual("field_timestamp", field_timestamp.ColumnName);
Assert.AreEqual(typeof(DateTime), field_timestamp.DataType);
Assert.AreEqual(2, field_timestamp.Ordinal);
Assert.IsFalse(field_timestamp.Unique);
Assert.IsTrue(field_numeric.AllowDBNull);
Assert.IsFalse(field_numeric.AutoIncrement);
Assert.AreEqual("field_numeric", field_numeric.ColumnName);
Assert.AreEqual(typeof(decimal), field_numeric.DataType);
Assert.AreEqual(3, field_numeric.Ordinal);
Assert.IsFalse(field_numeric.Unique);
}
private DataTable CreateTempTable()
{
DataTable dtprescompl = new DataTable();
DataColumn theID = new DataColumn("ID");
theID.DataType = System.Type.GetType("System.Int32");
dtprescompl.Columns.Add(theID);
DataColumn theDateValue1 = new DataColumn("DateField1");
theDateValue1.DataType = System.Type.GetType("System.DateTime");
dtprescompl.Columns.Add(theDateValue1);
DataColumn theValue1 = new DataColumn("OtherNotes");
theValue1.DataType = System.Type.GetType("System.String");
dtprescompl.Columns.Add(theValue1);
DataColumn theFieldName = new DataColumn("FieldName");
theFieldName.DataType = System.Type.GetType("System.String");
dtprescompl.Columns.Add(theFieldName);
return dtprescompl;
}
/// <summary>
///
/// </summary>
/// <param name="AContext"></param>
/// <param name="ARow"></param>
/// <param name="AVerificationResultCollection"></param>
/// <param name="AValidationControlsDict"></param>
public static void ValidateAdminGrantReceivable(object AContext, AFeesReceivableRow ARow,
ref TVerificationResultCollection AVerificationResultCollection, TValidationControlsDict AValidationControlsDict)
{
// ChargeOption = { "Minimum", "Maximum", "Fixed", "Percentage" }
// Don't validate deleted DataRows
if (ARow.RowState == DataRowState.Deleted)
{
return;
}
if (ARow.ChargeOption == "Percentage")
{
DataColumn ValidationColumn = ARow.Table.Columns[AFeesReceivableTable.ColumnChargePercentageId];
TValidationControlsData ValidationControlsData;
if (AValidationControlsDict.TryGetValue(ValidationColumn, out ValidationControlsData))
{
decimal enteredValue = (ARow.IsChargePercentageNull() ? -1 : ARow.ChargePercentage); // If the user has cleared the value in the control, I'll treat it as -1.
TVerificationResult VerificationResult = TNumericalChecks.IsPositiveDecimal(enteredValue,
ValidationControlsData.ValidationControlLabel,
AContext, ValidationColumn, ValidationControlsData.ValidationControl);
// Handle addition to/removal from TVerificationResultCollection
AVerificationResultCollection.Auto_Add_Or_AddOrRemove(AContext, VerificationResult, ValidationColumn);
}
}
else // the ChargeOption relates to an amount
{
DataColumn ValidationColumn = ARow.Table.Columns[AFeesReceivableTable.ColumnChargeAmountId];
TValidationControlsData ValidationControlsData;
if (AValidationControlsDict.TryGetValue(ValidationColumn, out ValidationControlsData))
{
decimal enteredValue = (ARow.IsChargeAmountNull() ? -1 : ARow.ChargeAmount); // If the user has cleared the value in the control, I'll treat it as -1.
TVerificationResult VerificationResult = TNumericalChecks.IsPositiveDecimal(enteredValue,
ValidationControlsData.ValidationControlLabel,
AContext, ValidationColumn, ValidationControlsData.ValidationControl);
// Handle addition to/removal from TVerificationResultCollection
AVerificationResultCollection.Auto_Add_Or_AddOrRemove(AContext, VerificationResult, ValidationColumn);
}
}
}
private void init_Booked()
{
booked = new DataTable();
var column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "Booked";
booked.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "From";
booked.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "To";
booked.Columns.Add(column);
}
protected override void Context()
{
base.Context();
_expectedCommandType = Command.CommandTypeEdit;
_expectedDescription = Command.MolecularWeightModifiedInDataRepositories;
var baseGrid = new BaseGrid("Time", "Time", DomainHelperForSpecs.TimeDimensionForSpecs());
_column = new DataColumn("Col", "Col", DomainHelperForSpecs.ConcentrationDimensionForSpecs(), baseGrid);
_observedData = new DataRepository {
_column
};
_list = new List <DataRepository> {
_observedData
};
}
internal void InitVars()
{
this.columnTipo = this.Columns["Tipo"];
this.columnCliente = this.Columns["Cliente"];
this.columnNomCli = this.Columns["NomCli"];
this.columnOCCliente = this.Columns["OCCliente"];
this.columnNroOV = this.Columns["NroOV"];
this.columnNroOCProv = this.Columns["NroOCProv"];
this.columnNomProv = this.Columns["NomProv"];
this.columnFEntPed = this.Columns["FEntPed"];
this.columnFEntConf = this.Columns["FEntConf"];
this.columnPaisDest = this.Columns["PaisDest"];
this.columnMoneda = this.Columns["Moneda"];
this.columnMontoOV = this.Columns["MontoOV"];
this.columnImpAFac = this.Columns["ImpAFac"];
this.columnFormaDesp = this.Columns["FormaDesp"];
}
/// <summary>
/// Preview the xml content and validate it
/// </summary>
/// <returns>Dataset containing the results of the preview stored procedure.</returns>
public DataSet Preview()
{
try
{
//1. Validate the XML document
this.Validate();
//2. If the document is valid upload it to the database otherwise do nothing.
if (this.p_objValidationResult.IsValid)
{
DataSet dsLoadResult;
Toolbook objToolbook = new Toolbook();
//3. Loads the UserXMLData.
return(dsLoadResult = objToolbook.UploadContentObjectXMLPreview(this.GetXMLData(this.XMLFile), this.ModuleID, this.UserID));
}
else //4. Schema Validation failed.
{
//5. Create a new DataSet
DataSet dsLoadResult = new DataSet("LoadResult");
//6. Create a datatable with the error result from the validation struct.
DataTable dtbLoadResult = new DataTable("Result");
DataColumn dtcName = new DataColumn("Error", System.Type.GetType("System.String"));
dtbLoadResult.Columns.Add(dtcName);
DataRow drError;
drError = dtbLoadResult.NewRow();
drError["Error"] = "Invalid XML file";
dtbLoadResult.Rows.Add(drError);
//7. Log the error to the error log
//new ErrorLog(new Exception(this.ValidationResult.Error), ErrorLevel.High, "ImportToolbook", "Preview", "Validate XML");
new ErrorLog(new ApplicationException(ValidationResult.Error.ToString()));
//8. Add the DataTable to the DataSet.
dsLoadResult.Tables.Add(dtbLoadResult);
//9. Return the DataSet.
return(dsLoadResult);
}
}
catch (Exception ex)
{
throw ex;
}
}
string makeClassFromDataTable(string className, string tableName)
{
DataTable dt = getDataTableSqlServer(tableName);
string Clase = "public class " + className + Environment.NewLine;
Clase += "{" + Environment.NewLine;
for (int i = 0; i < dt.Columns.Count; i++)
{
DataColumn column = dt.Columns[i];
Clase += "public " + getType(column.DataType.ToString().Substring(7, column.DataType.ToString().Count() - 7)) + " " + column.ColumnName + " {get;set;}" + Environment.NewLine;;
}
Clase += "}" + Environment.NewLine;
return(Clase);
}
private void ShowTable(List <string> columnOID, List <List <String> > table)
{
DataTable myTable = new DataTable();
DataColumn dtColumn;
DataRow myDataRow;
if (table.Count == 0)
{
MessageBox.Show("No results returned.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
for (int i = 0; i < columnOID.Count; i++)
{
dtColumn = new DataColumn();
dtColumn.DataType = System.Type.GetType("System.String");
dtColumn.ColumnName = columnOID[i];
myTable.Columns.Add(dtColumn);
}
for (int w = 0; w < table[0].Count; w++)
{
myDataRow = myTable.NewRow();
//uzupełniam cały wiersz
for (int n = 0; n < table.Count; n++)
{
myDataRow[myTable.Columns[n]] = table[n][w];
}
myTable.Rows.Add(myDataRow);
}
//wyświetlanie tabeli
dataGridView_TABLE.DataSource = myTable;
//wyłączenie sortowania
foreach (DataGridViewColumn column in dataGridView_TABLE.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
//włacz przycisk po wykonanych czynnościach
button_Table_GetTableOID.Enabled = true;
}
internal virtual void CreateDataTables (DataSet ds, XmlNode section)
{
DataTable dt = ds.Tables.Add ("DbProviderFactories");
DataColumn [] columns = new DataColumn [5];
columns [0] = new DataColumn ("Name", typeof (string));
columns [1] = new DataColumn ("Description", typeof (string));
columns [2] = new DataColumn ("InvariantName", typeof (string));
columns [3] = new DataColumn ("AssemblyQualifiedName", typeof (string));
columns [4] = new DataColumn ("SupportedClasses", typeof (int));
dt.Columns.AddRange (columns);
dt.PrimaryKey = new DataColumn [] {columns [2]};
foreach (XmlNode node in section.SelectNodes (".//DbProviderFactories")) {
AddRows (dt, node);
RemoveRows (dt, node);
}
}
private void InitClass()
{
this.columnVPATIENTID = new DataColumn("VPATIENTID", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVPATIENTID.AllowDBNull = true;
this.Columns.Add(this.columnVPATIENTID);
this.columnVNAME = new DataColumn("VNAME", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVNAME.AllowDBNull = true;
this.Columns.Add(this.columnVNAME);
this.columnVSEX = new DataColumn("VSEX", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVSEX.AllowDBNull = true;
this.Columns.Add(this.columnVSEX);
this.columnVBIRTHDATE = new DataColumn("VBIRTHDATE", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVBIRTHDATE.AllowDBNull = true;
this.Columns.Add(this.columnVBIRTHDATE);
this.columnVAGE = new DataColumn("VAGE", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVAGE.AllowDBNull = true;
this.Columns.Add(this.columnVAGE);
this.columnVIDNO = new DataColumn("VIDNO", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVIDNO.AllowDBNull = true;
this.Columns.Add(this.columnVIDNO);
this.columnVBIRTHPLACE = new DataColumn("VBIRTHPLACE", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVBIRTHPLACE.AllowDBNull = true;
this.Columns.Add(this.columnVBIRTHPLACE);
this.columnVNATIONNAME = new DataColumn("VNATIONNAME", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVNATIONNAME.AllowDBNull = true;
this.Columns.Add(this.columnVNATIONNAME);
this.columnVCOUNTRY = new DataColumn("VCOUNTRY", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVCOUNTRY.AllowDBNull = true;
this.Columns.Add(this.columnVCOUNTRY);
this.columnVJIGUAN = new DataColumn("VJIGUAN", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVJIGUAN.AllowDBNull = true;
this.Columns.Add(this.columnVJIGUAN);
this.columnVPRESENTADDRESS = new DataColumn("VPRESENTADDRESS", typeof(System.String), null, System.Data.MappingType.Element);
this.columnVPRESENTADDRESS.AllowDBNull = true;
this.Columns.Add(this.columnVPRESENTADDRESS);
}
public GameConfigDB()
{
this.TableName = "rated_game_configuration";
this.connection = Local.input_db;
DataColumn dc = this.Columns.Add("game_config_id", typeof(int));
dc.AutoIncrement = true;
this.PrimaryKey = new DataColumn[1] {
dc
};
this.Columns.Add("session_game_group_name", typeof(string));
this.Columns.Add("rate", typeof(bool));
this.Columns.Add("session_game_group_id", typeof(int));
DsnSQLUtil.MatchCreate(connection, this);
DsnSQLUtil.FillDataTable(connection, this);
}
/// <summary>Initializes the members, after a clone action.</summary>
private void InitMembers()
{
_columnProductId = this.Columns["ProductId"];
_columnProductName = this.Columns["ProductName"];
_columnSupplierId = this.Columns["SupplierId"];
_columnCategoryId = this.Columns["CategoryId"];
_columnQuantityPerUnit = this.Columns["QuantityPerUnit"];
_columnUnitPrice = this.Columns["UnitPrice"];
_columnUnitsInStock = this.Columns["UnitsInStock"];
_columnUnitsOnOrder = this.Columns["UnitsOnOrder"];
_columnReorderLevel = this.Columns["ReorderLevel"];
_columnDiscontinued = this.Columns["Discontinued"];
_columnCategoryName = this.Columns["CategoryName"];
_fields = EntityFieldsFactory.CreateTypedViewEntityFieldsObject(TypedViewType.AlphabeticalListOfProductsTypedView);
// __LLBLGENPRO_USER_CODE_REGION_START InitMembers
// __LLBLGENPRO_USER_CODE_REGION_END
}
private void preencheGridModelos(int CodProduto)
{
List <MarcaModelo> marcaModelos = ModeloDataAcess.buscaModelosPorProd(CodProduto);
// Criando um Datatable
DataTable table = new DataTable();
DataColumn colunaId = new DataColumn();
colunaId.DataType = System.Type.GetType("System.Int32");
colunaId.ColumnName = "Id";
table.Columns.Add(colunaId);
DataColumn colunaModel = new DataColumn();
colunaModel.DataType = System.Type.GetType("System.String");
colunaModel.ColumnName = "Modelo";
table.Columns.Add(colunaModel);
DataColumn colunaMarca = new DataColumn();
colunaMarca.DataType = System.Type.GetType("System.String");
colunaMarca.ColumnName = "Marca";
table.Columns.Add(colunaMarca);
// DataRow é o objeto para linha no Datatable
DataRow row;
// Iniciamos um For para Adicionar itens no DataTable
for (int i = 0; i < marcaModelos.Count; i++)
{
row = table.NewRow(); // Adicionamos uma linha do DataTable
row["Id"] = marcaModelos[i].id;
row["Modelo"] = marcaModelos[i].nome; // Iniciamos a inserção na coluna “Item” como Iema + contador.
row["Marca"] = marcaModelos[i].marca;
table.Rows.Add(row); // No final adicionamos a linha no Datatable.
}
// Create a DataView using the DataTable.
DataView view = new DataView(table); // O View recebe o Datatable Preenchido
// Set a DataGrid control’s DataSource to the DataView.
dataGridView1.DataSource = view; // O DataGridView recebe o View carregado.
dataGridView1.Columns[0].Visible = false;
}
private void LoadGridFromDBF()
{
try
{
if (File.Exists(GlobalVar.DbfDownload + "\\Download\\DBFMATCH.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\Download\\DBFMATCH.zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\Download\\DBFMATCH.zip tidak ada");
return;
}
string fileNameH = "overduefu.dbf";
fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH;
if (File.Exists(fileNameH))
{
tblHeader = Foxpro.ReadFile(fileNameH);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblHeader.Columns.Add(newcol);
GVDownOVF.DataSource = tblHeader;
lblStst.Text = "0/" + tblHeader.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblHeader.Rows.Count;
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("File " + fileNameH + " tidak ada");
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
public DataTable GetContactsNames()
{
OAuth2Parameters parameters = new OAuth2Parameters();
parameters.AccessToken = credential.Token.AccessToken;
parameters.RefreshToken = credential.Token.RefreshToken;
RequestSettings settings = new RequestSettings(ApplicationName, parameters);
ContactsRequest cr = new ContactsRequest(settings);
Nameday nday = new Nameday();
DataTable dataTable = new DataTable();
DataColumn dataCol = dataTable.Columns.Add("Jmeno", typeof(string));
dataCol.AllowDBNull = false;
dataCol.Unique = true;
dataCol = dataTable.Columns.Add("Datum", typeof(string));
dataCol.ReadOnly = true;
Feed <Contact> f = cr.GetContacts();
foreach (Contact entry in f.Entries)
{
if (entry.Name != null)
{
Name name = entry.Name;
if (!string.IsNullOrEmpty(name.GivenName))
{
Console.WriteLine("\t\t" + name.GivenName);
dataTable.Rows.Add(new Object[] { name.GivenName, nday.GetDate(name.GivenName) });
}
else
{
Console.WriteLine("\t\t (no given name found)");
}
}
else
{
Console.WriteLine("\t (no name found)");
}
}
return(dataTable);
}
public void SetUp()
{
_semanticType = SemanticType.Measure;
_dataType = typeof(Boolean);
_filePath = @"C:\Test.csv";
_map = new SourceMap();
_dataColumn = new DataColumnBuilder()
.WithColumnName("Test")
.WithDataType(typeof(Boolean))
.Build();
_table = new DataTableBuilder()
.WithColumn(_dataColumn)
.Build();
_source = new CsvFileSource();
_mockRepository = new Mock <ISourceRepository>();
_mockRepository.Setup(p => p.GetSource <CsvFileSource>())
.Returns(_source);
_mockDataAdapter = new Mock <ICsvFileDataAdapter>();
_mockDataAdapter.Setup(p => p.GetTable(_source))
.Returns(_table);
_mockDataTypeDetector = new Mock <IDataTypeDetector>();
_mockDataTypeDetector.Setup(p => p.Detect(It.IsAny <IEnumerable <object> >()))
.Returns(_dataType);
_mockSemanticTypeDetector = new Mock <ISemanticTypeDetector>();
_mockSemanticTypeDetector.Setup(p => p.Detect(_dataType, It.IsAny <List <object> >()))
.Returns(_semanticType);
_mockFactory = new Mock <ISourceMapFactory>();
_mockFactory.Setup(p => p.Create(_dataColumn.Ordinal, _dataColumn.ColumnName, _dataType, _semanticType))
.Returns(_map);
_mockEventBus = new Mock <IEventBus>();
_handler = new UpdateCsvFileSourceCommandHandler(
_mockRepository.Object,
_mockDataAdapter.Object,
_mockDataTypeDetector.Object,
_mockSemanticTypeDetector.Object,
_mockFactory.Object,
_mockEventBus.Object);
}
/// <summary>
/// todoComment
/// </summary>
/// <param name="e"></param>
/// <param name="AVerificationResultCollection"></param>
/// <param name="AVerificationResult"></param>
/// <param name="FDataColumnComparedTo"></param>
/// <returns></returns>
public static Boolean VerifySubscriptionData(DataColumnChangeEventArgs e,
TVerificationResultCollection AVerificationResultCollection,
out TVerificationResult AVerificationResult,
out DataColumn FDataColumnComparedTo)
{
Boolean ReturnValue;
AVerificationResult = null;
DataColumn FDataColumnComparedTo2 = null;
if ((e.Column.ColumnName == PSubscriptionTable.GetDateCancelledDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetExpiryDateDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetDateNoticeSentDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetStartDateDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetSubscriptionRenewalDateDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetFirstIssueDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetLastIssueDBName()))
{
VerifySubscriptionDates(e, AVerificationResultCollection, out AVerificationResult, out FDataColumnComparedTo2);
}
FDataColumnComparedTo = FDataColumnComparedTo2;
// if (e.Column.Ordinal = (e.Column.Table as PPartnerLocationTable).ColumnEmailAddress.Ordinal) then
// begin
// VerifyEMailAddress(e, AVerificationResult);
// end;
if ((e.Column.ColumnName == PSubscriptionTable.GetPublicationCopiesDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetNumberIssuesReceivedDBName()) ||
(e.Column.ColumnName == PSubscriptionTable.GetNumberComplimentaryDBName()))
{
VerifyInteger(e, out AVerificationResult);
}
// any verification errors?
if (AVerificationResult == null)
{
ReturnValue = true;
}
else
{
ReturnValue = false;
}
return(ReturnValue);
}
/// <summary>
/// 将CSV文件的数据读取到DataTable中
/// </summary>
/// <param name="fileName">CSV文件路径</param>
/// <returns>返回读取了CSV数据的DataTable</returns>
public static DataTable OpenCSV(string fileName)
{
DataTable dt = new DataTable();
FileStream fs = new FileStream(fileName, System.IO.FileMode.Open, System.IO.FileAccess.Read);
StreamReader sr = new StreamReader(fs, System.Text.Encoding.Default);
//记录每次读取的一行记录
string strLine = "";
//记录每行记录中的各字段内容
string[] aryLine;
//标示列数
int columnCount = 0;
//标示是否是读取的第一行
bool IsFirst = true;
//逐行读取CSV中的数据
while ((strLine = sr.ReadLine()) != null)
{
aryLine = strLine.Split(',');
if (IsFirst == true)
{
IsFirst = false;
columnCount = aryLine.Length;
//创建列
for (int i = 0; i < columnCount; i++)
{
DataColumn dc = new DataColumn(aryLine[i]);
dt.Columns.Add(dc);
}
}
else
{
DataRow dr = dt.NewRow();
for (int j = 0; j < columnCount; j++)
{
dr[j] = aryLine[j];
}
dt.Rows.Add(dr);
}
}
sr.Close();
fs.Close();
return(dt);
}
/// <summary>
/// 设置导出EXCEL单元格格式
/// </summary>
/// <param name="cell"></param>
/// <param name="row"></param>
/// <param name="column"></param>
private static void SetCellType(ICell cell, DataRow row, DataColumn column)
{
switch (column.DataType.ToString())
{
case "System.String":
cell.SetCellValue(row[column].ToString() ?? "");
break;
case "System.DateTime":
DateTime dateV;
DateTime.TryParse(row[column].ToString(), out dateV);
cell.SetCellValue(dateV);
break;
case "System.Boolean":
bool boolV = false;
bool.TryParse(row[column].ToString(), out boolV);
cell.SetCellValue(boolV);
break;
case "System.Int16": //整型
case "System.Int32":
case "System.Int64":
case "System.Byte":
int intV = 0;
int.TryParse(row[column].ToString(), out intV);
cell.SetCellValue(intV);
break;
case "System.Decimal": //浮点型
case "System.Double":
double doubV = 0;
double.TryParse(row[column].ToString(), out doubV);
cell.SetCellValue(doubV);
break;
case "System.DBNull": //空值处理
cell.SetCellValue("");
break;
default:
cell.SetCellValue("");
break;
}
}
private void AddTVPsToDataTypesTable(DataTable dataTypesTable, SqlConnection connection, string ServerVersion)
{
if (0 <= string.Compare(ServerVersion, "10.00.0000", StringComparison.OrdinalIgnoreCase))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = "select name, is_nullable, max_length from sys.types where is_table_type = 1";
DataRow row = null;
DataColumn column6 = dataTypesTable.Columns[DbMetaDataColumnNames.ProviderDbType];
DataColumn column5 = dataTypesTable.Columns[DbMetaDataColumnNames.ColumnSize];
DataColumn column4 = dataTypesTable.Columns[DbMetaDataColumnNames.IsSearchable];
DataColumn column3 = dataTypesTable.Columns[DbMetaDataColumnNames.IsLiteralSupported];
DataColumn column2 = dataTypesTable.Columns[DbMetaDataColumnNames.TypeName];
DataColumn column = dataTypesTable.Columns[DbMetaDataColumnNames.IsNullable];
if ((((column6 == null) || (column5 == null)) || ((column4 == null) || (column3 == null))) || ((column2 == null) || (column == null)))
{
throw ADP.InvalidXml();
}
using (IDataReader reader = command.ExecuteReader())
{
object[] values = new object[11];
while (reader.Read())
{
reader.GetValues(values);
row = dataTypesTable.NewRow();
row[column6] = SqlDbType.Structured;
if (values[2] != DBNull.Value)
{
row[column5] = values[2];
}
row[column4] = false;
row[column3] = false;
if (values[1] != DBNull.Value)
{
row[column] = values[1];
}
if (values[0] != DBNull.Value)
{
row[column2] = values[0];
dataTypesTable.Rows.Add(row);
row.AcceptChanges();
}
}
}
}
}
private DataTable BuildSchemaTable()
{
var schemaTable = new DataTable("SchemaTable")
{
Locale = CultureInfo.InvariantCulture,
MinimumCapacity = this.columns.Count
};
var columnName = new DataColumn("ColumnName", typeof(string));
var columnOrdinal = new DataColumn("ColumnOrdinal", typeof(int))
{
DefaultValue = 0
};
var columnSize = new DataColumn("ColumnSize", typeof(int))
{
DefaultValue = -1
};
var dataType = new DataColumn("DataType", typeof(Type));
var dataTypeName = new DataColumn("DataTypeName", typeof(string));
schemaTable.Columns.Add(columnName);
schemaTable.Columns.Add(columnOrdinal);
schemaTable.Columns.Add(columnSize);
schemaTable.Columns.Add(dataType);
schemaTable.Columns.Add(dataTypeName);
for (var i = 0; i < this.columns.Count; i++)
{
var schemaRow = schemaTable.NewRow();
schemaRow[columnName] = this.columns[i].Name;
schemaRow[columnOrdinal] = this.columns[i].Ordinal;
schemaRow[dataType] = this.columns[i].DataType;
schemaRow[dataTypeName] = this.columns[i].DataType.Name;
schemaTable.Rows.Add(schemaRow);
}
foreach (DataColumn column in schemaTable.Columns)
{
column.ReadOnly = true;
}
return(schemaTable);
}
private void InitClass()
{
this.columnIdPedido = new DataColumn("IdPedido", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdPedido);
this.columnFecha = new DataColumn("Fecha", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnFecha);
this.columnFevarcharegistracion = new DataColumn("Fevarcharegistracion", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnFevarcharegistracion);
this.columnIdResponsable = new DataColumn("IdResponsable", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdResponsable);
this.columnIdCuenta = new DataColumn("IdCuenta", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdCuenta);
this.columnComentario = new DataColumn("Comentario", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnComentario);
this.columnFechaVencimiento = new DataColumn("FechaVencimiento", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnFechaVencimiento);
this.columnIdEstado = new DataColumn("IdEstado", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdEstado);
this.columnOrigen = new DataColumn("Origen", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnOrigen);
this.columnFechaCierre = new DataColumn("FechaCierre", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnFechaCierre);
this.columnFechaCreacion = new DataColumn("FechaCreacion", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnFechaCreacion);
this.columnIdConexionCreacion = new DataColumn("IdConexionCreacion", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdConexionCreacion);
this.columnUltimaModificacion = new DataColumn("UltimaModificacion", typeof(System.Byte[]), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnUltimaModificacion);
this.columnIdConexionUltimaModificacion = new DataColumn("IdConexionUltimaModificacion", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdConexionUltimaModificacion);
this.columnIdReservado = new DataColumn("IdReservado", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdReservado);
this.columnRowId = new DataColumn("RowId", typeof(System.Guid), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnRowId);
this.columnIdSucursal = new DataColumn("IdSucursal", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdSucursal);
this.columnIdEmpresa = new DataColumn("IdEmpresa", typeof(long), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnIdEmpresa);
this.Constraints.Add(new UniqueConstraint("tsa_PedidosKey1", new DataColumn[] {
this.columnIdPedido
}, true));
this.columnIdPedido.AllowDBNull = false;
this.columnIdPedido.Unique = true;
this.columnUltimaModificacion.ReadOnly = true;
}
private void loadDataGridfromDBF()
{
if (File.Exists(GlobalVar.DbfDownload + "\\Download\\DBFMATCH.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\Download\\DBFMATCH.zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\Download\\DBFMATCH.zip tidak ada");
return;
}
string fileNameS = "hjual.dbf";
fileNameS = GlobalVar.DbfDownload + "\\" + fileNameS;
if (File.Exists(fileNameS))
{
try
{
dtHPromo = Foxpro.ReadFile(fileNameS);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dtHPromo.Columns.Add(newcol);
dataGridView1.DataSource = dtHPromo;
lblDownloadStatus1.Text = "0/" + dtHPromo.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = dtHPromo.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameS + " tidak ada");
return;
}
}
private DataTable SetUpCurrentData(object[] datas)
{
DataTable table = new DataTable();
DataColumn[] dcs = new DataColumn[] { new DataColumn("Mã GV"), new DataColumn("Mã môn học")
, new DataColumn("Mã lớp"), new DataColumn("Trình độ")
, new DataColumn("Ngày thi"), new DataColumn("Lần thi")
, new DataColumn("Số câu"), new DataColumn("Thời gian") };
table.Columns.AddRange(dcs);
DataRow dr = table.NewRow();
dr.ItemArray = datas;
table.Rows.Add(dr);
return(table);
}
public void LoadXml()
{
this.m_dsHelp = new System.Data.DataSet();
this.m_dsHelp.ReadXmlSchema(XSDFile);
this.m_dsHelp.ReadXml(XMLFile, System.Data.XmlReadMode.InferSchema);
m_dtHelp = m_dsHelp.Tables[TableName];
//define the primary key for the table
if (PrimaryKeyColumns != null)
{
DataColumn[] colPk = new DataColumn[PrimaryKeyColumns.Length];
for (int x = 0; x <= PrimaryKeyColumns.Length - 1; x++)
{
colPk[x] = m_dtHelp.Columns[PrimaryKeyColumns[x]];
}
m_dtHelp.PrimaryKey = colPk;
}
}
private DataTable DynamicsTable()
{
DataTable Dynamics = new DataTable();
DataColumn idGrDin = new DataColumn("id", Type.GetType("System.Int32"));
DataColumn idCoreInd = new DataColumn("idCoreInd", Type.GetType("System.Int32"));
DataColumn CoreInd = new DataColumn("Основные показатели", Type.GetType("System.String"));
DataColumn OneSemestr = new DataColumn("1-ый семестр", Type.GetType("System.Single"));
DataColumn TwoSemestr = new DataColumn("2-ой семестр", Type.GetType("System.Single"));
DataColumn note = new DataColumn("Примечания", Type.GetType("System.String"));
Dynamics.Columns.Add(idGrDin);
Dynamics.Columns.Add(idCoreInd);
Dynamics.Columns.Add(CoreInd);
Dynamics.Columns.Add(OneSemestr);
Dynamics.Columns.Add(TwoSemestr);
Dynamics.Columns.Add(note);
return(Dynamics);
}
private void addcol()
{
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] { tblSanPham, tblNSX, tblLoaiSP });
DataRelation qh = new DataRelation("FRK_NSX_SANPHAM", tblNSX.Columns["MaNSX"], tblSanPham.Columns["MaNSX"]);
ds.Relations.Add(qh);
DataColumn cTenNSX = new DataColumn("TenNSX", Type.GetType("System.String"), "Parent(FRK_NSX_SANPHAM).TenNSX");
tblSanPham.Columns.Add(cTenNSX);
DataRelation qh1 = new DataRelation("FRK_LoaiSP_SANPHAM", tblLoaiSP.Columns["MaLoai"], tblSanPham.Columns["MaLoai"]);
ds.Relations.Add(qh1);
DataColumn cTenLoai = new DataColumn("TenLoai", Type.GetType("System.String"), "Parent(FRK_LoaiSP_SANPHAM).TenLoai");
tblSanPham.Columns.Add(cTenLoai);
}
public LoggerWrapper()
{
this.dataTable = new DataTable();
DataColumn[] dataColumns = new DataColumn[]
{
new DataColumn(ColumnNameTime, typeof(DateTime)),
new DataColumn(ColumnNameCategory, typeof(string)),
new DataColumn(ColumnNameCallingMethod, typeof(string)),
new DataColumn(ColumnNameMessage, typeof(string)),
new DataColumn(ColumnNameException, typeof(Exception)),
};
foreach (DataColumn dataColumn in dataColumns)
{
this.dataTable.Columns.Add(dataColumn);
}
}
protected override void Context()
{
base.Context();
_template.Curves.Add(new CurveTemplate
{
Name = "Curve1",
xData = { QuantityType = QuantityType.BaseGrid },
yData = { QuantityType = _drugColumn.QuantityInfo.Type, Path = new[] { "Organism", "Liver", "Cells", "Aspirin", "Concentration" }.ToPathString() }
});
_anotherColumn = new DataColumn("Another", _concentrationDimension, _baseGrid);
_anotherColumn.QuantityInfo.Path = new[] { "Sim", "Organism", "Liver", "Cells", "ANOTHER", "Concentration" };
_anotherColumn.QuantityInfo.Type = QuantityType.Drug | QuantityType.Observer;
_anotherColumn.DataInfo.Origin = ColumnOrigins.Calculation;
_dataColumns.Add(_anotherColumn);
}
public ComBox()
{
this.InitializeComponent();
DataColumn column = new DataColumn {
ColumnName = "Display",
DataType = System.Type.GetType("System.Object")
};
this.dtData.Columns.Add(column);
column = new DataColumn {
ColumnName = "Value",
DataType = System.Type.GetType("System.Object")
};
this.dtData.Columns.Add(column);
base.DataSource = this.dtData;
base.DisplayMember = "Display";
base.ValueMember = "Value";
}
public DataRelationTest()
{
_set = new DataSet();
_mom = new DataTable("Mom");
_child = new DataTable("Child");
_set.Tables.Add(_mom);
_set.Tables.Add(_child);
DataColumn Col = new DataColumn("Name");
DataColumn Col2 = new DataColumn("ChildName");
_mom.Columns.Add(Col);
_mom.Columns.Add(Col2);
DataColumn Col3 = new DataColumn("Name");
DataColumn Col4 = new DataColumn("Age");
Col4.DataType = Type.GetType("System.Int16");
_child.Columns.Add(Col3);
_child.Columns.Add(Col4);
}
public void Generate()
{
Exception tmpEx = new Exception();
DataTable tbl = new DataTable();
tbl.Columns.Add(new DataColumn("Column"));
DataColumn dc = new DataColumn();
dc.Expression = "something"; //invalid expression
// EvaluateException - Column
Assert.Throws<EvaluateException>(() =>
{
tbl.Columns.Add(dc);
});
// EvaluateException - Column Expression
Assert.Throws<EvaluateException>(() =>
{
tbl.Columns[0].Expression = "Min(AK47)"; //invalid expression
});
}
public void AllowDBNull()
{
DataTable dt = new DataTable();
DataColumn dc;
dc = new DataColumn("ColName", typeof(int));
dc.DefaultValue = DBNull.Value;
dt.Columns.Add(dc);
dc.AutoIncrement = false;
// Checking default value (True)
Assert.Equal(true, dc.AllowDBNull);
// AllowDBNull=true - adding new row with null value
dt.Rows.Add(dt.NewRow());
Assert.Equal(DBNull.Value, dt.Rows[0][0]);
// set AllowDBNull=false
Assert.Throws<DataException>(() =>
{
dc.AllowDBNull = false; //the exisiting row contains null value
});
dt.Rows.Clear();
dc.AllowDBNull = false;
// AllowDBNull=false - adding new row with null value
Assert.Throws<NoNullAllowedException>(() =>
{
dt.Rows.Add(dt.NewRow());
});
dc.AutoIncrement = true;
int iRowCount = dt.Rows.Count;
// AllowDBNull=false,AutoIncrement=true - adding new row with null value
dt.Rows.Add(dt.NewRow());
Assert.Equal(dt.Rows.Count, iRowCount + 1);
}
public void CreateChildViewSimple()
{
DataSet ds = new DataSet();
DataTable dt1 = new DataTable("table1");
ds.Tables.Add(dt1);
DataColumn c1 = new DataColumn("col");
dt1.Columns.Add(c1);
dt1.Rows.Add(new object[] { "1" });
DataTable dt2 = new DataTable("table2");
ds.Tables.Add(dt2);
DataColumn c2 = new DataColumn("col");
dt2.Columns.Add(c2);
dt2.Rows.Add(new object[] { "1" });
DataRelation dr = new DataRelation("dr", c1, c2);
DataView dv = new DataView(dt1);
DataRowView dvr = dv[0];
DataView v = dvr.CreateChildView(dr);
Assert.Equal("", v.RowFilter);
Assert.Equal("", v.Sort);
}
public UInt32Storage(DataColumn column)
: base(column, typeof(UInt32), defaultValue, StorageType.UInt32) {
}
public SqlMoneyStorage(DataColumn column)
: base(column, typeof(SqlMoney), SqlMoney.Null, SqlMoney.Null, StorageType.SqlMoney) {
}
public void ContainsSchema()
{
var ds = new DataSet();
DataTable dt1 = new DataTable();
ds.Tables.Add(dt1);
DataColumn dc1 = new DataColumn("Col1");
dt1.Columns.Add(dc1);
dt1.Rows.Add(new string[] { "aaa" });
DataTable dt2 = new DataTable();
ds.Tables.Add(dt2);
DataColumn dc2 = new DataColumn("Col2");
dt2.Columns.Add(dc2);
dt2.Rows.Add(new string[] { "bbb" });
DataRelation rel = new DataRelation("Rel1", dc1, dc2, false);
ds.Relations.Add(rel);
StringWriter sw = new StringWriter();
ds.WriteXml(sw, XmlWriteMode.WriteSchema);
ds = new DataSet();
ds.ReadXml(new StringReader(sw.ToString()));
sw = new StringWriter();
ds.WriteXml(sw);
XmlDocument doc = new XmlDocument();
doc.LoadXml(sw.ToString());
Assert.Equal(2, doc.DocumentElement.ChildNodes.Count);
}
public void ConflictExistingPrimaryKey()
{
Assert.Throws<ConstraintException>(() =>
{
// <wrong>The 'col' DataTable tries to create another primary key (and fails)</wrong> The data violates key constraint.
var ds = new DataSet();
ds.Tables.Add(new DataTable("table"));
DataColumn c = new DataColumn("pk");
ds.Tables[0].Columns.Add(c);
ds.Tables[0].PrimaryKey = new DataColumn[] { c };
XmlTextReader xtr = new XmlTextReader(_xml22, XmlNodeType.Document, null);
xtr.Read();
ds.ReadXml(xtr, XmlReadMode.InferSchema);
});
}
public void IndexOf()
{
DataTable Table = new DataTable("test_table");
DataColumnCollection Cols = Table.Columns;
Cols.Add("test");
Cols.Add("test2");
Cols.Add("test3");
Cols.Add("test4");
Assert.Equal(0, Cols.IndexOf("test"));
Assert.Equal(1, Cols.IndexOf("TEST2"));
Table.CaseSensitive = true;
Assert.Equal(1, Cols.IndexOf("TEST2"));
Assert.Equal(3, Cols.IndexOf(Cols[3]));
DataColumn C = new DataColumn("error");
Assert.Equal(-1, Cols.IndexOf(C));
Assert.Equal(-1, Cols.IndexOf("_error_"));
}
public void CopyTo()
{
DataTable Table = new DataTable("test_table");
DataColumnCollection Cols = Table.Columns;
Cols.Add("test");
Cols.Add("test2");
Cols.Add("test3");
Cols.Add("test4");
DataColumn[] array = new DataColumn[4];
Cols.CopyTo(array, 0);
Assert.Equal(4, array.Length);
Assert.Equal("test", array[0].ColumnName);
Assert.Equal("test2", array[1].ColumnName);
Assert.Equal("test3", array[2].ColumnName);
Assert.Equal("test4", array[3].ColumnName);
array = new DataColumn[6];
Cols.CopyTo(array, 2);
Assert.Equal(6, array.Length);
Assert.Equal("test", array[2].ColumnName);
Assert.Equal("test2", array[3].ColumnName);
Assert.Equal("test3", array[4].ColumnName);
Assert.Equal("test4", array[5].ColumnName);
Assert.Null(array[0]);
Assert.Null(array[1]);
}
public void Add()
{
var Table = new DataTable("test_table");
DataColumnCollection cols = Table.Columns;
DataColumn c = null;
cols.Add();
cols.Add();
for (int i = 0; i < 2; i++)
{
c = cols[i];
Assert.True(c.AllowDBNull);
Assert.False(c.AutoIncrement);
Assert.Equal(0L, c.AutoIncrementSeed);
Assert.Equal(1L, c.AutoIncrementStep);
Assert.Equal($"Column{i + 1}", c.Caption);
Assert.Equal("Element", c.ColumnMapping.ToString());
Assert.Equal($"Column{i + 1}", c.ColumnName);
Assert.Null(c.Container);
Assert.Equal(typeof(string), c.DataType);
Assert.Equal(DBNull.Value, c.DefaultValue);
Assert.False(c.DesignMode);
Assert.Equal("", c.Expression);
Assert.Equal(0, c.ExtendedProperties.Count);
Assert.Equal(-1, c.MaxLength);
Assert.Equal("", c.Namespace);
Assert.Equal(i, c.Ordinal);
Assert.Equal("", c.Prefix);
Assert.False(c.ReadOnly);
Assert.Null(c.Site);
Assert.Equal("test_table", c.Table.TableName);
Assert.Equal($"Column{i + 1}", c.ToString());
Assert.False(c.Unique);
}
cols.Add("test1", typeof(int), "");
cols.Add("test2", typeof(string), "Column1 + Column2");
c = cols[2];
Assert.True(c.AllowDBNull);
Assert.False(c.AutoIncrement);
Assert.Equal(0L, c.AutoIncrementSeed);
Assert.Equal(1L, c.AutoIncrementStep);
Assert.Equal("test1", c.Caption);
Assert.Equal("Element", c.ColumnMapping.ToString());
Assert.Equal("test1", c.ColumnName);
Assert.Null(c.Container);
Assert.Equal(typeof(int), c.DataType);
Assert.Equal(DBNull.Value, c.DefaultValue);
Assert.False(c.DesignMode);
Assert.Equal("", c.Expression);
Assert.Equal(0, c.ExtendedProperties.Count);
Assert.Equal(-1, c.MaxLength);
Assert.Equal("", c.Namespace);
Assert.Equal(2, c.Ordinal);
Assert.Equal("", c.Prefix);
Assert.False(c.ReadOnly);
Assert.Null(c.Site);
Assert.Equal("test_table", c.Table.TableName);
Assert.Equal("test1", c.ToString());
Assert.False(c.Unique);
c = cols[3];
Assert.True(c.AllowDBNull);
Assert.False(c.AutoIncrement);
Assert.Equal(0L, c.AutoIncrementSeed);
Assert.Equal(1L, c.AutoIncrementStep);
Assert.Equal("test2", c.Caption);
Assert.Equal("Element", c.ColumnMapping.ToString());
Assert.Equal("test2", c.ColumnName);
Assert.Null(c.Container);
Assert.Equal(typeof(string), c.DataType);
Assert.Equal(DBNull.Value, c.DefaultValue);
Assert.False(c.DesignMode);
Assert.Equal("Column1 + Column2", c.Expression);
Assert.Equal(0, c.ExtendedProperties.Count);
Assert.Equal(-1, c.MaxLength);
Assert.Equal("", c.Namespace);
Assert.Equal(3, c.Ordinal);
Assert.Equal("", c.Prefix);
Assert.True(c.ReadOnly);
Assert.Null(c.Site);
Assert.Equal("test_table", c.Table.TableName);
Assert.Equal("test2 + Column1 + Column2", c.ToString());
Assert.False(c.Unique);
c = new DataColumn("test3", typeof(int));
cols.Add(c);
c = cols[4];
Assert.True(c.AllowDBNull);
Assert.False(c.AutoIncrement);
Assert.Equal(0L, c.AutoIncrementSeed);
Assert.Equal(1L, c.AutoIncrementStep);
Assert.Equal("test3", c.Caption);
Assert.Equal("Element", c.ColumnMapping.ToString());
Assert.Equal("test3", c.ColumnName);
Assert.Null(c.Container);
Assert.Equal(typeof(int), c.DataType);
Assert.Equal(DBNull.Value, c.DefaultValue);
Assert.False(c.DesignMode);
Assert.Equal("", c.Expression);
Assert.Equal(0, c.ExtendedProperties.Count);
Assert.Equal(-1, c.MaxLength);
Assert.Equal("", c.Namespace);
Assert.Equal(4, c.Ordinal);
Assert.Equal("", c.Prefix);
Assert.False(c.ReadOnly);
Assert.Null(c.Site);
Assert.Equal("test_table", c.Table.TableName);
Assert.Equal("test3", c.ToString());
Assert.False(c.Unique);
}
public void CanRemove()
{
DataTable Table = new DataTable("test_table");
DataTable Table2 = new DataTable("test_table_2");
DataColumnCollection Cols = Table.Columns;
DataColumn C = new DataColumn("test1");
Cols.Add();
// LAMESPEC: MSDN says that if C doesn't belong to Cols
// Exception is thrown.
Assert.False(Cols.CanRemove(C));
Cols.Add(C);
Assert.True(Cols.CanRemove(C));
C = new DataColumn();
C.Expression = "test1 + 2";
Cols.Add(C);
C = Cols["test2"];
Assert.False(Cols.CanRemove(C));
C = new DataColumn("t");
Table2.Columns.Add(C);
DataColumnCollection Cols2 = Table2.Columns;
Assert.True(Cols2.CanRemove(C));
DataSet Set = new DataSet();
Set.Tables.Add(Table);
Set.Tables.Add(Table2);
DataRelation Rel = new DataRelation("Rel", Table.Columns[0], Table2.Columns[0]);
Set.Relations.Add(Rel);
Assert.False(Cols2.CanRemove(C));
Assert.False(Cols.CanRemove(null));
}
public void AddRange()
{
DataTable Table = new DataTable("test_table");
DataTable Table2 = new DataTable("test_table2");
DataColumnCollection Cols = Table.Columns;
DataColumn C = null;
DataColumn[] ColArray = new DataColumn[2];
C = new DataColumn("test1");
ColArray[0] = C;
C = new DataColumn("test2");
C.AllowDBNull = false;
C.Caption = "Test_caption";
C.DataType = typeof(XmlReader);
ColArray[1] = C;
Cols.AddRange(ColArray);
C = Cols[0];
Assert.True(C.AllowDBNull);
Assert.False(C.AutoIncrement);
Assert.Equal(0L, C.AutoIncrementSeed);
Assert.Equal(1L, C.AutoIncrementStep);
Assert.Equal("test1", C.Caption);
Assert.Equal("Element", C.ColumnMapping.ToString());
Assert.Equal("test1", C.ColumnName);
Assert.Null(C.Container);
Assert.Equal(typeof(string), C.DataType);
Assert.Equal(DBNull.Value, C.DefaultValue);
Assert.False(C.DesignMode);
Assert.Equal("", C.Expression);
Assert.Equal(0, C.ExtendedProperties.Count);
Assert.Equal(-1, C.MaxLength);
Assert.Equal("", C.Namespace);
Assert.Equal(0, C.Ordinal);
Assert.Equal("", C.Prefix);
Assert.False(C.ReadOnly);
Assert.Null(C.Site);
Assert.Equal("test_table", C.Table.TableName);
Assert.Equal("test1", C.ToString());
Assert.False(C.Unique);
C = Cols[1];
Assert.False(C.AllowDBNull);
Assert.False(C.AutoIncrement);
Assert.Equal(0L, C.AutoIncrementSeed);
Assert.Equal(1L, C.AutoIncrementStep);
Assert.Equal("Test_caption", C.Caption);
Assert.Equal("Element", C.ColumnMapping.ToString());
Assert.Equal("test2", C.ColumnName);
Assert.Null(C.Container);
Assert.Equal(typeof(XmlReader), C.DataType);
Assert.Equal(DBNull.Value, C.DefaultValue);
Assert.False(C.DesignMode);
Assert.Equal("", C.Expression);
Assert.Equal(0, C.ExtendedProperties.Count);
Assert.Equal(-1, C.MaxLength);
Assert.Equal("", C.Namespace);
Assert.Equal(1, C.Ordinal);
Assert.Equal("", C.Prefix);
Assert.False(C.ReadOnly);
Assert.Null(C.Site);
Assert.Equal("test_table", C.Table.TableName);
Assert.Equal("test2", C.ToString());
Assert.False(C.Unique);
}
public void AddExceptions()
{
DataTable Table = new DataTable("test_table");
DataTable Table2 = new DataTable("test_table2");
DataColumnCollection Cols = Table.Columns;
DataColumn C = null;
try
{
Cols.Add(C);
Assert.False(true);
}
catch (Exception e)
{
Assert.Equal(typeof(ArgumentNullException), e.GetType());
}
C = new DataColumn("test");
Cols.Add(C);
try
{
Cols.Add(C);
Assert.False(true);
}
catch (ArgumentException e)
{
// Assert.Equal (typeof (ArgumentException), e.GetType ());
// Assert.Equal ("Column 'test' already belongs to this or another DataTable.", e.Message);
}
try
{
Table2.Columns.Add(C);
Assert.False(true);
}
catch (ArgumentException e)
{
// Assert.Equal (typeof (ArgumentException), e.GetType ());
// Assert.Equal ("Column 'test' already belongs to this or another DataTable.", e.Message);
}
DataColumn C2 = new DataColumn("test");
try
{
Cols.Add(C2);
Assert.False(true);
}
catch (DuplicateNameException e)
{
// Assert.Equal (typeof (DuplicateNameException), e.GetType ());
// Assert.Equal ("A DataColumn named 'test' already belongs to this DataTable.", e.Message);
}
try
{
Cols.Add("test2", typeof(string), "substring ('fdsafewq', 2)");
Assert.False(true);
}
catch (InvalidExpressionException e)
{
// Assert.True (e is InvalidExpressionException);
// Assert.Equal ("Expression 'substring ('fdsafewq', 2)' is invalid.", e.Message);
}
}
DataColumn GetDataColumn(string name, Type type)
{
// look for column
var col = _dt.Columns[name];
// not found, add now
if (col == null)
{
// create new column
col = new DataColumn(name, type);
col.AllowDBNull = true;
// make sure TableLink columns come after regular properties
int index = _dt.Columns.Count;
if (type != typeof(TableLink))
{
for (int i = 0; i < _dt.Columns.Count; i++)
{
if (_dt.Columns[i].DataType == typeof(TableLink))
{
index = i;
break;
}
}
}
// add the new column
_dt.Columns.Insert(index, col);
}
return col;
}
