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; }