Inheritance: System.ComponentModel.MarshalByValueComponent
		private void BindToColumns(DataTable metaData)
		{
			if(false == _fieldsBound)
			{
				if(metaData.Columns.Contains("TABLE_CATALOG"))			f_Catalog			 = metaData.Columns["TABLE_CATALOG"];
				if(metaData.Columns.Contains("TABLE_SCHEMA"))			f_Schema			 = metaData.Columns["TABLE_SCHEMA"];
				if(metaData.Columns.Contains("TABLE_NAME"))				f_TableName			 = metaData.Columns["TABLE_NAME"];
				if(metaData.Columns.Contains("INDEX_CATALOG"))			f_IndexCatalog		 = metaData.Columns["INDEX_CATALOG"];
				if(metaData.Columns.Contains("INDEX_SCHEMA"))			f_IndexSchema		 = metaData.Columns["INDEX_SCHEMA"];
				if(metaData.Columns.Contains("INDEX_NAME"))				f_IndexName			 = metaData.Columns["INDEX_NAME"];
				if(metaData.Columns.Contains("UNIQUE"))					f_Unique			 = metaData.Columns["UNIQUE"];
				if(metaData.Columns.Contains("CLUSTERED"))				f_Clustered			 = metaData.Columns["CLUSTERED"];
				if(metaData.Columns.Contains("TYPE"))					f_Type				 = metaData.Columns["TYPE"];
				if(metaData.Columns.Contains("FILL_FACTOR"))			f_FillFactor		 = metaData.Columns["FILL_FACTOR"];
				if(metaData.Columns.Contains("INITIAL_SIZE"))			f_InitializeSize	 = metaData.Columns["INITIAL_SIZE"];
				if(metaData.Columns.Contains("NULLS"))					f_Nulls				 = metaData.Columns["NULLS"];
				if(metaData.Columns.Contains("SORT_BOOKMARKS"))			f_SortBookmarks		 = metaData.Columns["SORT_BOOKMARKS"];
				if(metaData.Columns.Contains("AUTO_UPDATE"))			f_AutoUpdate		 = metaData.Columns["AUTO_UPDATE"];
				if(metaData.Columns.Contains("NULL_COLLATION"))			f_NullCollation		 = metaData.Columns["NULL_COLLATION"];
				if(metaData.Columns.Contains("COLLATION"))				f_Collation			 = metaData.Columns["COLLATION"];
				if(metaData.Columns.Contains("CARDINALITY"))			f_Cardinality		 = metaData.Columns["CARDINALITY"];
				if(metaData.Columns.Contains("PAGES"))					f_Pages				 = metaData.Columns["PAGES"];
				if(metaData.Columns.Contains("FILTER_CONDITION"))		f_FilterCondition	 = metaData.Columns["FILTER_CONDITION"];
				if(metaData.Columns.Contains("INTEGRATED"))				f_Integrated		 = metaData.Columns["INTEGRATED"];
			}
		}
Exemplo n.º 2
1
		public void GetReady ()
		{
			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;
		}
Exemplo n.º 3
0
        private DataTable CreateDataTable()
        {
            DataTable table = new DataTable();
            DataColumn column1 = new DataColumn("Id", typeof(string));
            DataColumn column2 = new DataColumn("Text", typeof(String));
            DataColumn column3 = new DataColumn("ParentId", typeof(string));
            table.Columns.Add(column1);
            table.Columns.Add(column2);
            table.Columns.Add(column3);

            DataRow row = table.NewRow();
            row[0] = "china";
            row[1] = "中国";
            row[2] = DBNull.Value;
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "henan";
            row[1] = "河南省";
            row[2] = "china";
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "zhumadian";
            row[1] = "驻马店市";
            row[2] = "henan";
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "luohe";
            row[1] = "漯河市";
            row[2] = "henan";
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "anhui";
            row[1] = "安徽省";
            row[2] = "china";
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "hefei";
            row[1] = "合肥市";
            row[2] = "anhui";
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "golden";
            row[1] = "金色池塘小区";
            row[2] = "hefei";
            table.Rows.Add(row);

            row = table.NewRow();
            row[0] = "ustc";
            row[1] = "中国科学技术大学";
            row[2] = "hefei";
            table.Rows.Add(row);

            return table;
        }
        public void CarregarPesquisa(string conteudo)
        {
            DataTable dt = new DataTable();
            DataColumn coluna1 = new DataColumn("ID", Type.GetType("System.Int32"));
            DataColumn coluna2 = new DataColumn("CODIGO", Type.GetType("System.String"));
            DataColumn coluna3 = new DataColumn("DESCRICAO", Type.GetType("System.String"));

            dt.Columns.Add(coluna1);
            dt.Columns.Add(coluna2);
            dt.Columns.Add(coluna3);

            PessoasBL pesBL = new PessoasBL();
            Pessoas pe = new Pessoas();
            List<Pessoas> pessoas = pesBL.PesquisarBuscaBL(conteudo);

            foreach (Pessoas pes in pessoas)
            {
                DataRow linha = dt.NewRow();

                linha["ID"] = pes.Id;
                linha["CODIGO"] = pes.Codigo;
                linha["DESCRICAO"] = pes.Nome;

                dt.Rows.Add(linha);
            }

            grdPesquisa.DataSource = dt;
            grdPesquisa.DataBind();
        }
Exemplo n.º 5
0
 private void BindToColumns(DataTable metaData)
 {
     if (false == _fieldsBound)
     {
         if (metaData.Columns.Contains("DOMAIN_CATALOG")) f_DomainCatalog = metaData.Columns["DOMAIN_CATALOG"];
         if (metaData.Columns.Contains("DOMAIN_SCHEMA")) f_DomainSchema = metaData.Columns["DOMAIN_SCHEMA"];
         if (metaData.Columns.Contains("DOMAIN_NAME")) f_DomainName = metaData.Columns["DOMAIN_NAME"];
         if (metaData.Columns.Contains("DATA_TYPE")) f_DataType = metaData.Columns["DATA_TYPE"];
         if (metaData.Columns.Contains("CHARACTER_MAXIMUM_LENGTH"))
             f_MaxLength = metaData.Columns["CHARACTER_MAXIMUM_LENGTH"];
         if (metaData.Columns.Contains("CHARACTER_OCTET_LENGTH"))
             f_OctetLength = metaData.Columns["CHARACTER_OCTET_LENGTH"];
         if (metaData.Columns.Contains("COLLATION_CATALOG"))
             f_CollationCatalog = metaData.Columns["COLLATION_CATALOG"];
         if (metaData.Columns.Contains("COLLATION_SCHEMA"))
             f_CollationSchema = metaData.Columns["COLLATION_SCHEMA"];
         if (metaData.Columns.Contains("COLLATION_NAME")) f_CollationName = metaData.Columns["COLLATION_NAME"];
         if (metaData.Columns.Contains("CHARACTER_SET_CATALOG"))
             f_CharSetCatalog = metaData.Columns["CHARACTER_SET_CATALOG"];
         if (metaData.Columns.Contains("CHARACTER_SET_SCHEMA"))
             f_CharSetSchema = metaData.Columns["CHARACTER_SET_SCHEMA"];
         if (metaData.Columns.Contains("CHARACTER_SET_NAME"))
             f_CharSetName = metaData.Columns["CHARACTER_SET_NAME"];
         if (metaData.Columns.Contains("NUMERIC_PRECISION"))
             f_NumericPrecision = metaData.Columns["NUMERIC_PRECISION"];
         if (metaData.Columns.Contains("NUMERIC_SCALE")) f_NumericScale = metaData.Columns["NUMERIC_SCALE"];
         if (metaData.Columns.Contains("DATETIME_PRECISION"))
             f_DatetimePrecision = metaData.Columns["DATETIME_PRECISION"];
         if (metaData.Columns.Contains("DOMAIN_DEFAULT")) f_Default = metaData.Columns["DOMAIN_DEFAULT"];
         if (metaData.Columns.Contains("IS_NULLABLE")) f_IsNullable = metaData.Columns["IS_NULLABLE"];
     }
 }
        /// 
        /// <param name="column"></param>
        public static GoogleDataColumn CreateGoogleDataColumn(DataColumn column)
        {
            switch (column.DataType.FullName)
            {
                case "System.Boolean": return new BooleanGoogleDataColumn(column);
                case "System.Byte": return new NumberGoogleDataColumn(column);
                case "System.Char": return new StringGoogleDataColumn(column);
                case "System.DateTime":
                    if (column.ExtendedProperties.ContainsKey("GoogleDateType"))
                    {
                        switch ((GoogleDateType)column.ExtendedProperties["GoogleDateType"])
                        {
                            case GoogleDateType.Date: return new DateGoogleDataColumn(column);
                            case GoogleDateType.TimeOfDay: return new TimeOfDayGoogleDataColumn(column);
                            default: return new DateTimeGoogleDataColumn(column);
                        }
                    }
                    else
                        return new DateTimeGoogleDataColumn(column);

                case "System.Decimal": return new NumberGoogleDataColumn(column);
                case "System.Double": return new NumberGoogleDataColumn(column);
                case "System.Int16": return new NumberGoogleDataColumn(column);
                case "System.Int32": return new NumberGoogleDataColumn(column);
                case "System.Int64": return new NumberGoogleDataColumn(column);
                case "System.SByte": return new NumberGoogleDataColumn(column);
                case "System.Single": return new NumberGoogleDataColumn(column);
                case "System.String": return new StringGoogleDataColumn(column);
                case "System.TimeSpan": return new StringGoogleDataColumn(column);
                case "System.UInt16": return new NumberGoogleDataColumn(column);
                case "System.UInt32": return new NumberGoogleDataColumn(column);
                case "System.UInt64": return new NumberGoogleDataColumn(column);
                default: return new StringGoogleDataColumn(column);
            }
        }
        public void CarregarPesquisaTitulos(string conteudo)
        {
            DataTable dt = new DataTable();
            DataColumn coluna1 = new DataColumn("ID", Type.GetType("System.Int32"));
            DataColumn coluna2 = new DataColumn("CODIGO", Type.GetType("System.String"));
            DataColumn coluna3 = new DataColumn("DESCRICAO", Type.GetType("System.String"));

            dt.Columns.Add(coluna1);
            dt.Columns.Add(coluna2);
            dt.Columns.Add(coluna3);

            TitulosBL titBL = new TitulosBL();
            Titulos tit = new Titulos();
            List<Titulos> titulos = titBL.PesquisarBuscaBL("R",conteudo);

            foreach (Titulos ltTit in titulos)
            {
                DataRow linha = dt.NewRow();

                linha["ID"] = ltTit.Id;
                linha["CODIGO"] = ltTit.Numero;
                linha["DESCRICAO"] = ltTit.Parcela;

                dt.Rows.Add(linha);
            }

            grdPesquisatit.DataSource = dt;
            grdPesquisatit.DataBind();
        }
Exemplo n.º 8
0
	//Activate This Construntor to log All To Standard output
	//public TestClass():base(true){}

	//Activate this constructor to log Failures to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, false){}


	//Activate this constructor to log All to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, true){}

	//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES

	public void run()
	{
		Exception exp = null;
		string sColErr = "Error!";
		DataTable dt = new DataTable("myTable"); 
		DataColumn dc = new DataColumn("Column1"); 
		dt.Columns.Add(dc);
		DataRow dr = dt.NewRow();

		try
		{
			BeginCase("empty string");
			Compare( dr.GetColumnError(0) ,String.Empty );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}
		
		dr.SetColumnError(0,sColErr );
        
		try
		{
			BeginCase("error string");
			Compare( dr.GetColumnError(0) ,sColErr  );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}
		
	}
Exemplo n.º 9
0
 protected void btnCreate_Click(object sender, EventArgs e)
 {
     //为DataTable指定一个表名,通过dt.TableName可以访问表名
     DataTable dt = new DataTable("内存表示例");
     //为DataTable添加架构信息,也就是创建字段
     dt.Columns.Add(new DataColumn("书名", typeof(string)));
     dt.Columns.Add(new DataColumn("书号", typeof(string)));
     //使用数组的形式创建表列
     DataColumn[] dcs = new DataColumn[2];
     dcs[0] = new DataColumn("价格", typeof(decimal));
     dcs[1] = new DataColumn("出版社", typeof(string));
     //调用DataTable的Columns集合的AddRange方法添加列
     dt.Columns.AddRange(dcs);
     //初始化新的行
     DataRow dr = dt.NewRow();
     //为DataRow中的列赋字值
     dr["书名"] = "C#编程系列";
     dr["书号"] = "12345-678-90";
     dr["价格"] = 45.3;
     dr["出版社"] = "我的出版社";
     //必须将创建的行添加的DataTable的Rows集合中。
     dt.Rows.Add(dr);
     //也可以使用Rows的重载的Add方法来添加表列
     dt.Rows.Add(new object[] { "C#编程系列二", "33455-333-333", 45.7, "我的出版社" });
     //绑定到GridView对象
     GridView1.DataSource = dt;
     GridView1.DataBind();
 }
Exemplo n.º 10
0
 public static DataTable ReadTable(DbCommand cmd)
 {
     DataTable dt = new DataTable();
     DbDataReader reader = null;
     try
     {
         reader = cmd.ExecuteReader();
         int fieldc = reader.FieldCount;
         for (int i = 0; i < fieldc; i++)
         {
             DataColumn dc = new DataColumn(reader.GetName(i), reader.GetFieldType(i));
             dt.Columns.Add(dc);
         }
         while (reader.Read())
         {
             DataRow dr = dt.NewRow();
             for (int i = 0; i < fieldc; i++)
             {
                 dr[i] = reader[i];
             }
             dt.Rows.Add(dr);
         }
         return dt;
     }
     finally
     {
         if (reader != null) reader.Close();
     }
 }
Exemplo n.º 11
0
	//Activate This Construntor to log All To Standard output
	//public TestClass():base(true){}

	//Activate this constructor to log Failures to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, false){}


	//Activate this constructor to log All to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, true){}

	//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES

	public void run()
	{
		Exception exp = null;


		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();

		try
		{
			BeginCase("DataRow CancelEdit");
			Compare( (int)myRow[0] == 1,true );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}
		
	}
        private void PopulateReceivingFieldList()
        {
            string CheckedMember = "CHECKED";
            string DisplayMember = "Field Name";
            string ValueMember = "Field Key";

            FFieldTable = TRemote.MFinance.Reporting.WebConnectors.GetReceivingFields(FLedgerNumber, out DisplayMember, out ValueMember);

            DataColumn FirstColumn = new DataColumn(CheckedMember, typeof(bool));

            FirstColumn.DefaultValue = false;
            FFieldTable.Columns.Add(FirstColumn);

            clbFields.Columns.Clear();
            clbFields.AddCheckBoxColumn("", FFieldTable.Columns[CheckedMember], 17, false);
            clbFields.AddTextColumn(Catalog.GetString("Field Key"), FFieldTable.Columns[ValueMember], 100);
            clbFields.AddTextColumn(Catalog.GetString("Field Name"), FFieldTable.Columns[DisplayMember], 200);
            clbFields.DataBindGrid(FFieldTable, ValueMember, CheckedMember, ValueMember, false, true, false);

            FTypeTable = TDataCache.TMPartner.GetCacheablePartnerTable(TCacheablePartnerTablesEnum.PartnerTypeList);

            DataColumn CheckedColumn = new DataColumn(CheckedMember, typeof(bool));
            CheckedColumn.DefaultValue = false;

            FTypeTable.Columns.Add(CheckedColumn);
            clbTypes.Columns.Clear();
            clbTypes.AddCheckBoxColumn("", FTypeTable.Columns[CheckedMember], 17);
            clbTypes.AddTextColumn(Catalog.GetString("Partner Type"), FTypeTable.Columns[PTypeTable.GetTypeCodeDBName()], 280);
            clbTypes.DataBindGrid(FTypeTable, PTypeTable.GetTypeCodeDBName(), CheckedMember,
                PTypeTable.GetTypeCodeDBName(), false, true, false);
        }
Exemplo n.º 13
0
 public ConfigurableColumn CreateColumn(IColumnInfo info, DataColumn column)
 {
     if(info != null)
     {
         if(!String.IsNullOrEmpty(info.FkReferenceTable))
             return new LookupColumn(this, info, column);
     }
     if(column != null)
     {
         Type type = column.DataType;
         if(type == typeof(DateTime))
             return new DateTimeColumn(this, info, column);
         else if(type == typeof(string))
             return new StringColumn(this, info, column);
         else if(type == typeof(bool))
             return new CheckBoxColumn(this, info, column);
         else if(type == typeof(Decimal))
             return new DecimalColumn(this, info, column);
         else if(type == typeof(Int64))
             return new Int64Column(this, info, column);
         else if(type == typeof(Int32))
             return new Int64Column(this, info, column);
         throw new Exception("Nelze vytvořit sloupeček pro typ " + type.ToString());
     }
     throw new Exception("Nelze vytvořit sloupeček");
 }
Exemplo n.º 14
0
        //consultar
        protected DataTable crearTabla()
        {
            DataTable tabla = new DataTable();
            DataColumn columna;

            columna = new DataColumn();
            columna.DataType = System.Type.GetType("System.String");
            columna.ColumnName = "Origen";
            tabla.Columns.Add(columna);

            columna = new DataColumn();
            columna.DataType = System.Type.GetType("System.String");
            columna.ColumnName = "Destino";
            tabla.Columns.Add(columna);

            columna = new DataColumn();
            columna.DataType = System.Type.GetType("System.String");
            columna.ColumnName = "Hora";
            tabla.Columns.Add(columna);

            columna = new DataColumn();
            columna.DataType = System.Type.GetType("System.String");
            columna.ColumnName = "Ruta";
            tabla.Columns.Add(columna);

            columna = new DataColumn();
            columna.DataType = System.Type.GetType("System.String");
            columna.ColumnName = "Días Disponibles";
            tabla.Columns.Add(columna);

            GridRutas.DataSource = tabla;
            GridRutas.DataBind();

            return tabla;
        }
Exemplo n.º 15
0
    public DataTable GetAllProducts()
    {
        DataTable dt = new DataTable();
        DataRow dr;
        DataColumn dc;

        dc = new DataColumn("ID", typeof(Int32));
        dc.Unique = true;
        dt.Columns.Add(dc);

        dt.Columns.Add(new DataColumn("ProductName", typeof(string)));
        dt.Columns.Add(new DataColumn("Description", typeof(string)));
        dt.Columns.Add(new DataColumn("Price", typeof(string)));

        for (int i = 0; i < 10000; i++)
        {
            dr = dt.NewRow();
            dr["id"] = i;
            dr["ProductName"] = "Product " + i;
            dr["Description"] = "Description for Product " + i;
            dr["Price"] = "$100";
            dt.Rows.Add(dr);
        }
        return dt;
    }
Exemplo n.º 16
0
    private void CreateTempTable()
    {
        tempTable = new DataTable();
        DataColumn dcORDERNO = new DataColumn("ORDERNO");
        DataColumn dcBARCODE = new DataColumn("BARCODE");
        DataColumn dcNAME = new DataColumn("PRODUCTNAME");
        DataColumn dcQUANTITY = new DataColumn("QUANTITY");
        DataColumn dcUNIT = new DataColumn("UNIT");
        DataColumn dcCOST = new DataColumn("COST");
        DataColumn dcPRICE = new DataColumn("PRICE");
        DataColumn dcSTDPRICE= new DataColumn("STDPRICE");
        DataColumn dcLOID = new DataColumn("LOID");
        DataColumn dcPUNIT = new DataColumn("PUNIT");

        tempTable.Columns.Add(dcORDERNO);
        tempTable.Columns.Add(dcBARCODE);
        tempTable.Columns.Add(dcNAME);
        tempTable.Columns.Add(dcQUANTITY);
        tempTable.Columns.Add(dcUNIT);
        tempTable.Columns.Add(dcCOST);
        tempTable.Columns.Add(dcPRICE);
        tempTable.Columns.Add(dcSTDPRICE);
        tempTable.Columns.Add(dcLOID);
        tempTable.Columns.Add(dcPUNIT);
    }
        protected void Page_Load(object sender, EventArgs e)
        {
            _category = Request.QueryString["category"];

            CategoryLabel.Text = _category;

            var productBL = new ProductBL();
            var productList = productBL.GetCategoryList(_category);

            var dt = new DataTable();
            var dcImage = new DataColumn("Image", typeof(string));
            var dcProductName = new DataColumn("Product Name", typeof(string));
            var dcDescription = new DataColumn("Description", typeof(string));
            var dcPrice = new DataColumn("Price", typeof(string));

            dt.Columns.AddRange(new[] { dcImage, dcProductName, dcDescription, dcPrice });

            for (var i = 0; i < productList.Count; i++)
            {
                dt.Rows.Add(new object[]
                    {
                        productList.ElementAt(i).GetImage().Trim(), productList.ElementAt(i).GetProductName().Trim(),
                        productList.ElementAt(i).GetDescription().Trim(), productList.ElementAt(i).GetPrice().Trim()
                    });
            }

            ToysTreatsAndVitaminsGrid.DataSource = dt;
            ToysTreatsAndVitaminsGrid.DataBind();
        }
Exemplo n.º 18
0
		public DataSet SensitiveData()
		{
			DataSet data = new DataSet();
			
			//Do our authentication
			//this can be via a database or whatever
			if(Authentication.Username == "test" && Authentication.Password == "test")
			{
				//they are allowed access to our sensitive data
				
				//just create some dummy data
				DataTable dtTable1 = new DataTable();
				DataColumn drCol1 = new DataColumn("Data", System.Type.GetType("System.String"));
				dtTable1.Columns.Add(drCol1);

				DataRow drRow = dtTable1.NewRow();
				drRow["Data"] = "Sensitive Data";
				dtTable1.Rows.Add(drRow);
				dtTable1.AcceptChanges();

				data.Tables.Add(dtTable1);


				
			}
			else
			{
				data = null;
			}			

			return data;
		}
        private void FillDataTable()
        {
            if (ResultValue == null)
            {
                throw new ArgumentNullException("Result is null now");
            }
            for (int i = 0; i < ResultValue.ColumnTitles.Count; ++i)
            {
                tableColumn = new DataColumn();
                tableColumn.ColumnName = 
                    string.IsNullOrEmpty(ResultValue.ColumnTitles[i]) ? 
                    (i + 1).ToString() : ResultValue.ColumnTitles[i];
                Table.Columns.Add(tableColumn);
            }

            object[,] value = ResultValue.GetValueAsMatrix();
            for (int i = 0; i < value.GetLength(0); ++i)
            {
                tableRow = Table.NewRow();
                for (int j = 0; j < ResultValue.GetValueAsMatrix().GetLength(1); ++j)
                {
                    tableRow[j] = value[i, j];
                }
                Table.Rows.Add(tableRow);
            }
        }
 public DesignColumn()
 {
     this.namingPropNames = new StringCollection();
     this.dataColumn = new System.Data.DataColumn();
     this.designTable = null;
     this.namingPropNames.Add("typedName");
 }
Exemplo n.º 21
0
        private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
        {
            buttonCancel.Visible = false;
            progressBar1.Visible = false;
            cur = dmp.ChooseCurriculum();
            for (int j = 1; j < 6; j++)
            {
                DataTable dt = new DataTable();
                dt.DefaultView.AllowDelete = false;
                dt.DefaultView.AllowEdit = false;
                dt.DefaultView.AllowNew = false;
                DataColumn sütun;
                DataRow satır;
                foreach (Classroom item in cur.ClassroomList)
                {
                    sütun = new DataColumn(item.Name);
                    dt.Columns.Add(sütun);

                }

                for (int i = 9; i < 17; i++)
                {
                    satır = dt.NewRow();
                    foreach (Classroom item in cur.ClassroomList)
                    {
                        foreach (Schedule item2 in item.scheduleList)
                        {
                            if (i >= item2.startHour && i < item2.endHour && item2.whichDay == j)
                            {
                                satır[item.Name] += " + " + item2.section.SectionCourse.Name + "-sec " + item2.section.Name;
                            }
                        }
                    }
                    dt.Rows.Add(satır);
                }
                switch (j)
                {
                    case 1:
                        dgw_mon_curri.DataSource = dt;
                        break;
                    case 2:
                        dgw_tues_curri.DataSource = dt;
                        break;
                    case 3:
                        dgw_wed_curri.DataSource = dt;
                        break;
                    case 4:
                        dgw_thur_curri.DataSource = dt;
                        break;
                    case 5:
                        dgw_fri_curri.DataSource = dt;
                        break;

                    default:
                        break;
                }
            }
            CB_prof_list.DataSource = cur.ProfessorList;
            progressBar1.Visible = false;
        }
Exemplo n.º 22
0
		/// <summary>
		/// 得到当前指定条件和页数的积分交易日志记录(表)
		/// </summary>
		/// <param name="pagesize">当前分页的尺寸大小</param>
		/// <param name="currentpage">当前页码</param>
		/// <param name="condition">查询条件</param>
		/// <returns></returns>
		public static DataTable LogList(int pagesize,int currentpage , string condition)
		{
            DataTable dt = Discuz.Data.PaymentLogs.GetPaymentLogList(pagesize, currentpage, condition);
			if (dt!=null)
			{
				DataColumn dc=new DataColumn();
				dc.ColumnName="forumname";
				dc.DataType=System.Type.GetType("System.String");
				dc.DefaultValue="";
				dc.AllowDBNull=false;
				dt.Columns.Add(dc);
                DataTable ForumList = Forums.GetForumListForDataTable();
				foreach(DataRow dr in dt.Rows)
				{
					if(dr["fid"].ToString().Trim()!="")
					{
						foreach(DataRow forumdr in ForumList.Select("fid="+dr["fid"].ToString()))
						{
							dr["forumname"]=forumdr["name"].ToString();
							break;
						}
					}
				}
			}
			return dt;
		}
		public override DataTable GetDataSources ()
		{
			DataTable dt = new DataTable ();
			DataColumn col;

			col = new DataColumn ("ServerName", typeof (string));
			dt.Columns.Add (col);

			col = new DataColumn ("InstanceName", typeof (string));
			dt.Columns.Add (col);

			col = new DataColumn ("IsClustered", typeof (bool));
			dt.Columns.Add (col);

			col = new DataColumn ("Version", typeof (string));
			dt.Columns.Add (col);

			col = new DataColumn ("FactoryName", typeof (string));
			dt.Columns.Add (col);

			DataRow dr = dt.NewRow ();
			dr [0] = "Sqlite Embedded Database";
			dr [1] = "Sqlite Default Instance";
			dr [2] = false;
			dr [3] = "?";
			dr [4] = "Community.CsharpSqlite.SQLiteClient.SqliteConnectionFactory";
			dt.Rows.Add (dr);

			return dt;
		}
Exemplo n.º 24
0
 private static FieldBuilder CréeAttributs(TypeBuilder constructeurDeType, DataColumn colonne)
 {
     FieldBuilder champBldr = null;
     PropertyBuilder constructeurPropriété;
     #region Création de l'attribut
     champBldr = constructeurDeType.DefineField(colonne.ColumnName.ToLower(), colonne.DataType, FieldAttributes.Private);
     #endregion
     #region Création de la Propriété associée
     constructeurPropriété = constructeurDeType.DefineProperty(colonne.ColumnName, System.Reflection.PropertyAttributes.HasDefault, colonne.DataType, null);
     // Choix des attributs
     MethodAttributes attrGetSet = MethodAttributes.Public |
        MethodAttributes.SpecialName | MethodAttributes.HideBySig;
     #region Définition du "getter".
     MethodBuilder constructeurGet = constructeurDeType.DefineMethod("get_" + colonne.ColumnName, attrGetSet, colonne.DataType, Type.EmptyTypes);
     ILGenerator champGetIL = constructeurGet.GetILGenerator();
     champGetIL.Emit(OpCodes.Ldarg_0);
     champGetIL.Emit(OpCodes.Ldfld, champBldr);
     champGetIL.Emit(OpCodes.Ret);
     #endregion
     #region Définition du "setter".
     MethodBuilder constructeurSet = constructeurDeType.DefineMethod("set_" + colonne.ColumnName, attrGetSet, null, new Type[] { colonne.DataType });
     ILGenerator champSetIL = constructeurSet.GetILGenerator();
     champSetIL.Emit(OpCodes.Ldarg_0);
     champSetIL.Emit(OpCodes.Ldarg_1);
     champSetIL.Emit(OpCodes.Stfld, champBldr);
     champSetIL.Emit(OpCodes.Ret);
     #endregion
     #region Association des accesseurs à la propriété
     constructeurPropriété.SetGetMethod(constructeurGet);
     constructeurPropriété.SetSetMethod(constructeurSet);
     #endregion
     #endregion
     return champBldr;
     }
Exemplo n.º 25
0
        public static void ExecuteFormula(string formula,decimal omset, decimal tarif)
        {
            DataTable table = new DataTable();
            // Create the first column.
            DataColumn omsetColumn = new DataColumn();
            omsetColumn.DataType = System.Type.GetType("System.Decimal");
            omsetColumn.ColumnName = "Omset";
            omsetColumn.DefaultValue = omset;

            // Create the first column.
            DataColumn tarifColumn = new DataColumn();
            tarifColumn.DataType = System.Type.GetType("System.Decimal");
            tarifColumn.ColumnName = "Tarif";
            tarifColumn.DefaultValue = tarif;

            // Create the second, calculated, column.
            DataColumn bagiHasilColumn = new DataColumn();
            bagiHasilColumn.DataType = System.Type.GetType("System.Decimal");
            bagiHasilColumn.ColumnName = "BagiHasil";
            bagiHasilColumn.Expression = formula;

            // Add columns to DataTable.
            table.Columns.Add(omsetColumn);
            table.Columns.Add(tarifColumn);
            table.Columns.Add(bagiHasilColumn);

            DataRow row = table.NewRow();
            table.Rows.Add(row);
            //DataView view = new DataView(table);
            // dataGrid1.DataSource = view;
            //Assert.AreEqual(909.09,row["BagiHasil"])
            Console.WriteLine("909.09 = {0}", row["BagiHasil"]);
            Console.Read();
        }
Exemplo n.º 26
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var catBL = new CatBL(false);
            var catsList = catBL.GetAllCats();

            var dt = new DataTable();
            var dcBreed = new DataColumn("Breed", typeof(string));
            var dcCountry = new DataColumn("Country", typeof(string));
            var dcOrigin = new DataColumn("Origin", typeof(string));
            var dcBodyType = new DataColumn("Body Type", typeof(string));
            var dcCoat = new DataColumn("Coat", typeof(string));
            var dcPattern = new DataColumn("Pattern", typeof(string));
            var dcImage = new DataColumn("Image", typeof(string));

            dt.Columns.AddRange(new[] { dcBreed, dcCountry, dcOrigin, dcBodyType, dcCoat, dcPattern, dcImage });

            for (var i = 0; i < catsList.Count; i++)
            {
                dt.Rows.Add(new object[]
                    {
                        catsList.ElementAt(i).GetBreed().Trim(), catsList.ElementAt(i).GetCountry().Trim(),
                        catsList.ElementAt(i).GetOrigin().Trim(), catsList.ElementAt(i).GetBodyType().Trim(),
                        catsList.ElementAt(i).GetCoat().Trim(), catsList.ElementAt(i).GetPattern().Trim(),
                        ResolveUrl(catsList.ElementAt(i).GetImage().Trim())
                    });
            }

            AllBreedGrid.DataSource = dt;
            AllBreedGrid.DataBind();
        }
Exemplo n.º 27
0
        public SourceForm()
        {
            InitializeComponent();
            LiterarySources = new DataTable();
            var column = new DataColumn()
            {
                Caption = "Literary Source",
                ColumnName = "LiterarySource",
                ReadOnly = true,
                DataType = typeof (string)
            };
            LiterarySources.Columns.Add(column);
            column = new DataColumn()
            {
                Caption = "Description",
                ColumnName = "GetDescription",
                ReadOnly = true,
                DataType = typeof (string)
            };
            LiterarySources.Columns.Add(column);
            SourceDataGridView.DataSource = LiterarySources;
            SourceDataGridView.Columns[0].Width = 120;
            SourceDataGridView.Columns[1].Width = 225;

            SourceDataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            sourcesList = new List<IReferences>();
        }
Exemplo n.º 28
0
	//Activate This Construntor to log All To Standard output
	//public TestClass():base(true){}

	//Activate this constructor to log Failures to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, false){}


	//Activate this constructor to log All to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, true){}

	//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES

	public void run()
	{
		Exception exp = null;

		DataTable dt = new DataTable(); 
		DataColumn dc0 = new DataColumn("Col0",typeof(int));
		DataColumn dc1 = new DataColumn("Col1",typeof(int));
		dt.Columns.Add(dc0);
		dt.Columns.Add(dc1);
		dt.Rows.Add(new object[] {1234});
		DataRow dr = dt.Rows[0];
            		
		try
		{
			BeginCase("IsNull_I 2");
			Compare(dr.IsNull(0) ,false );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}
	

		try
		{
			BeginCase("IsNull_I 2");
			Compare(dr.IsNull(1) ,true );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}
	
	}
Exemplo n.º 29
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (IsPostBack) return;
     hlQuayLai.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId);
     if (UserInfo.IsInRole("Administrators") || UserInfo.IsInRole("Admin_DonVi"))
         try
         {
             execSQL.connectionClass ob = new execSQL.connectionClass(); 
             DataSet ds = ob.fillDataset("EXEC ChungNT.Password_Admin");
             string tab = ds.Tables[1].Rows[0]["TabID"].ToString();
             string module = ds.Tables[1].Rows[0]["ModuleID"].ToString();
             DataColumn dc = new DataColumn("Link");
             ds.Tables[0].Columns.Add(dc);
             ds.Tables[0].AcceptChanges();
             foreach (DataRow dr in ds.Tables[0].Rows)
             {
                 dr.BeginEdit();
                 dr["Link"] = DotNetNuke.Common.Globals.NavigateURL(int.Parse(tab), "Edit", "mid/" + module, "UserId/" + dr["UserID"].ToString());
                 dr.EndEdit();
             }
             gvNhanVien.DataSource = ds.Tables[0];
             gvNhanVien.DataBind();
             int d = 0;
             foreach (GridViewRow dr in gvNhanVien.Rows)
             {
                 dr.CssClass = dr.Cells[6].Text;
                 if (dr.Cells[6].Text != "OK") d++;
             }
             lbError.Text = string.Format("Mật khẩu quá hạn: <b>{0}</b> / {1} tài khoản", d, gvNhanVien.Rows.Count);
         }
         catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
     else Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId));
 }
Exemplo n.º 30
0
        private void Form1_Load(object sender, EventArgs e)
        {
            //Create a DataSet from the XML file
            string filePath = "..\\..\\Employees.xml";
            DataSet ds = new DataSet();
            ds.ReadXml(filePath);

            //Create and add barcode column
            DataColumn dc = new DataColumn("BarcodeImage", typeof(byte[]));
            ds.Tables[0].Columns.Add(dc);

            //We'll use Code 128 Barcode Symbology
            BaseBarcode b = BarcodeFactory.GetBarcode(Symbology.Code128);

            b.Height = 50;
            b.FontHeight = 0.3F;
            //Now, generate and fill barcode images
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                //We'll encode the ID column
                b.Number = (string)dr["ID"];

                //Create bitmap and save it to BarcodeImage column
                MemoryStream ms = new MemoryStream();
                b.Save(ms, ImageType.Png);
                dr["BarcodeImage"] = ms.GetBuffer();
            }

            CrystalReport1 report = new CrystalReport1();
            report.SetDataSource(ds);
            crystalReportViewer1.ReportSource = report;
        }
Exemplo n.º 31
0
        private void ArrayRemove(DataColumn column)
        {
            column.SetOrdinalInternal(-1);
            _list.Remove(column);

            int count = _list.Count;

            for (int i = 0; i < count; i++)
            {
                ((DataColumn)_list[i]).SetOrdinalInternal(i);
            }

            if (column.ImplementsIChangeTracking)
            {
                RemoveColumnsImplementingIChangeTrackingList(column);
            }
        }
Exemplo n.º 32
0
        /// <summary>
        ///     Check whether the given column is part of this relation.
        /// <summary>
        /// <returns>
        ///     true if the column is part of this relation, otherwise false.
        /// </returns>
        internal bool Contains(DataColumn column)
        {
            foreach (DataColumn col in ParentColumns)
            {
                if (col == column)
                {
                    return(true);
                }
            }

            foreach (DataColumn col in ChildColumns)
            {
                if (col == column)
                {
                    return(true);
                }
            }
            return(false);
        }
Exemplo n.º 33
0
 private static string GetDataMemberType(DataColumn column)
 {
     if (column.DataType == typeof(string))
         return "string";
     else if (column.DataType == typeof(int))
         return "int" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(short))
         return "short" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(long))
         return "long" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(double))
         return "double" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(decimal))
         return "decimal" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(float))
         return "float" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(char))
         return "char" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(bool))
         return "bool" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(uint))
         return "uint" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(ushort))
         return "ushort" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(ulong))
         return "ulong" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(byte))
         return "byte" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(sbyte))
         return "sbyte" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(DateTime))
         return "DateTime" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(TimeSpan))
         return "TimeSpan" + (column.AllowDBNull ? "?" : string.Empty);
     else if (column.DataType == typeof(Type))
         return "Type";
     else if (column.DataType == typeof(byte[]))
         return "byte[]";
     else
         return column.DataType.ToString() + (column.AllowDBNull && column.DataType.IsClass == false ? "?" : string.Empty);
 }
Exemplo n.º 34
0
 private void columnsCollectionChanged(object sender, NotifyCollectionChangedEventArgs e)
 {
     if (IsInited)
     {
         throw new InvalidOperationException("Невозможно изменить схему объекта DataTable после добавления данных");
     }
     if (e.Action == NotifyCollectionChangedAction.Add && e.NewStartingIndex == _columns.Count - 1)
     {
         DataColumn c = (e.NewItems[0] as DataColumn);
         _indexes.Add(c.ColumnName, e.NewStartingIndex);
     }
     else
     {
         _indexes.Clear();
         int i = 0;
         foreach (var c in _columns)
         {
             _indexes.Add(c.ColumnName, i++);
         }
     }
 }
Exemplo n.º 35
0
        private bool AddColumnSchema(DataColumn col, XmlNameTable nameTable, XmlNodeIdHashtable columns)
        {
            string columnLocalName = nameTable.Get(col.EncodedColumnName);
            string columnNamespace = nameTable.Get(col.Namespace);

            if (columnLocalName == null)
            {
                return(false);
            }
            XmlNodeIdentety idColumn = new XmlNodeIdentety(columnLocalName, columnNamespace);

            columns[idColumn] = col;

            if (col.ColumnName.StartsWith("xml", StringComparison.OrdinalIgnoreCase))
            {
                HandleSpecialColumn(col, nameTable, columns);
            }


            return(true);
        }
Exemplo n.º 36
0
        /// <summary>
        /// Registers this name as being used in the collection.  Will throw an ArgumentException
        /// if the name is already being used.  Called by Add, All property, and Column.ColumnName property.
        /// if the name is equivalent to the next default name to hand out, we increment our defaultNameIndex.
        /// NOTE: To add a child table, pass column as null
        /// </summary>
        internal void RegisterColumnName(string name, DataColumn column)
        {
            Debug.Assert(name != null);

            try
            {
                _columnFromName.Add(name, column);

                if (null != column)
                {
                    column._hashCode = _table.GetSpecialHashCode(name);
                }
            }
            catch (ArgumentException)
            {
                // Argument exception means that there is already an existing key
                if (_columnFromName[name] != null)
                {
                    if (column != null)
                    {
                        throw ExceptionBuilder.CannotAddDuplicate(name);
                    }
                    else
                    {
                        throw ExceptionBuilder.CannotAddDuplicate3(name);
                    }
                }
                throw ExceptionBuilder.CannotAddDuplicate2(name);
            }

            // If we're adding a child table, then update defaultNameIndex to avoid colisions between the child table and auto-generated column names
            if ((column == null) && NamesEqual(name, MakeName(_defaultNameIndex), true, _table.Locale) != 0)
            {
                do
                {
                    _defaultNameIndex++;
                } while (Contains(MakeName(_defaultNameIndex)));
            }
        }
Exemplo n.º 37
0
        private bool AddColumnSchema(XmlNameTable nameTable, DataColumn col, XmlNodeIdHashtable columns)
        {
            string _columnLocalName = XmlConvert.EncodeLocalName(col.ColumnName);
            string columnLocalName  = nameTable.Get(_columnLocalName);          // Look it up in a name table

            if (columnLocalName == null)                                        // Not found?
            {
                columnLocalName = nameTable.Add(_columnLocalName);              // Add it
            }

            col.encodedColumnName = columnLocalName;                            // And set it back

            string columnNamespace = nameTable.Get(col.Namespace);              // Get column namespace from nametable

            if (columnNamespace == null)                                        // Not found ?
            {
                columnNamespace = nameTable.Add(col.Namespace);                 // Add it
            }
            else
            {
                if (col._columnUri != null)                                     // Update namespace
                {
                    col._columnUri = columnNamespace;
                }
            }
            // Create XmlNodeIdentety
            // for this column
            XmlNodeIdentety idColumn = new XmlNodeIdentety(columnLocalName, columnNamespace);

            columns[idColumn] = col;                                            // And add it to hashtable

            if (col.ColumnName.StartsWith("xml", StringComparison.OrdinalIgnoreCase))
            {
                HandleSpecialColumn(col, nameTable, columns);
            }

            return(true);
        }
Exemplo n.º 38
0
        /// <summary>
        /// Clears the collection of any columns.
        /// </summary>
        public void Clear()
        {
            int oldLength = _list.Count;

            DataColumn[] columns = new DataColumn[_list.Count];
            _list.CopyTo(columns, 0);

            OnCollectionChanging(s_refreshEventArgs);

            if (_table.fInitInProgress && _delayedAddRangeColumns != null)
            {
                _delayedAddRangeColumns = null;
            }

            try
            {
                // this will smartly add and remove the appropriate tables.
                _fInClear = true;
                BaseGroupSwitch(columns, oldLength, null, 0);
                _fInClear = false;
            }
            catch (Exception e) when(ADP.IsCatchableOrSecurityExceptionType(e))
            {
                // something messed up: restore to old values and throw
                _fInClear = false;
                BaseGroupSwitch(null, 0, columns, oldLength);
                _list.Clear();
                for (int i = 0; i < oldLength; i++)
                {
                    _list.Add(columns[i]);
                }
                throw;
            }

            _list.Clear();
            _table.ElementColumnCount = 0;
            OnCollectionChanged(s_refreshEventArgs);
        }
Exemplo n.º 39
0
        internal void MoveTo(DataColumn column, int newPosition)
        {
            if (0 > newPosition || newPosition > Count - 1)
            {
                throw ExceptionBuilder.InvalidOrdinal("ordinal", newPosition);
            }

            if (column.ImplementsIChangeTracking)
            {
                RemoveColumnsImplementingIChangeTrackingList(column);
            }

            _list.Remove(column);
            _list.Insert(newPosition, column);
            int count = _list.Count;

            for (int i = 0; i < count; i++)
            {
                ((DataColumn)_list[i]).SetOrdinalInternal(i);
            }

            CheckIChangeTracking(column);
            OnCollectionChanged(new CollectionChangeEventArgs(CollectionChangeAction.Refresh, column));
        }
Exemplo n.º 40
0
        internal int IndexOfCaseInsensitive(string name)
        {
            int        hashcode = _table.GetSpecialHashCode(name);
            int        cachedI  = -1;
            DataColumn column   = null;

            for (int i = 0; i < Count; i++)
            {
                column = (DataColumn)_list[i];
                if ((hashcode == 0 || column._hashCode == 0 || column._hashCode == hashcode) &&
                    NamesEqual(column.ColumnName, name, false, _table.Locale) != 0)
                {
                    if (cachedI == -1)
                    {
                        cachedI = i;
                    }
                    else
                    {
                        return(-2);
                    }
                }
            }
            return(cachedI);
        }
Exemplo n.º 41
0
 public DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn, bool createConstraints)
     : this(relationName, new DataColumn[] { parentColumn }, new DataColumn [] { childColumn }, createConstraints)
 {
 }
Exemplo n.º 42
0
 public DataRowPropertyDescriptor(DataColumn column) : base(column.ColumnName, null)
 {
     _col = column;
 }
Exemplo n.º 43
0
 public static Exception ExpressionAndConstraint(DataColumn column, Constraint constraint) => _Argument(SR.Format(SR.DataColumn_ExpressionAndConstraint, column.ColumnName, constraint.ConstraintName));
Exemplo n.º 44
0
 public static Exception ExpressionInConstraint(DataColumn column) => _Argument(SR.Format(SR.DataColumn_ExpressionInConstraint, column.ColumnName));
Exemplo n.º 45
0
 public static Exception SetFailed(object value, DataColumn column, Type type, Exception innerException) => _Argument(innerException.Message + SR.Format(SR.DataColumn_SetFailed, value.ToString(), column.ColumnName, type.Name), innerException);
Exemplo n.º 46
0
 public static Exception CannotSetToNull(DataColumn column) => _Argument(SR.Format(SR.DataColumn_CannotSetToNull, column.ColumnName));
Exemplo n.º 47
0
 /// <summary>
 ///  Adds the column to the columns array.
 /// </summary>
 private void ArrayAdd(DataColumn column)
 {
     _list.Add(column);
     column.SetOrdinalInternal(_list.Count - 1);
     CheckIChangeTracking(column);
 }
Exemplo n.º 48
0
 public static Exception CannotSetMaxLength(DataColumn column, int value) => _Argument(SR.Format(SR.DataColumn_CannotSetMaxLength, column.ColumnName, value.ToString(CultureInfo.InvariantCulture)));
Exemplo n.º 49
0
        internal bool CanRemove(DataColumn column, bool fThrowException)
        {
            if (column == null)
            {
                if (!fThrowException)
                {
                    return(false);
                }
                else
                {
                    throw ExceptionBuilder.ArgumentNull(nameof(column));
                }
            }

            if (column._table != _table)
            {
                if (!fThrowException)
                {
                    return(false);
                }
                else
                {
                    throw ExceptionBuilder.CannotRemoveColumn();
                }
            }

            // allow subclasses to complain first.
            _table.OnRemoveColumnInternal(column);

            // We need to make sure the column is not involved in any Relations or Constriants
            if (_table._primaryKey != null && _table._primaryKey.Key.ContainsColumn(column))
            {
                if (!fThrowException)
                {
                    return(false);
                }
                else
                {
                    throw ExceptionBuilder.CannotRemovePrimaryKey();
                }
            }

            for (int i = 0; i < _table.ParentRelations.Count; i++)
            {
                if (_table.ParentRelations[i].ChildKey.ContainsColumn(column))
                {
                    if (!fThrowException)
                    {
                        return(false);
                    }
                    else
                    {
                        throw ExceptionBuilder.CannotRemoveChildKey(_table.ParentRelations[i].RelationName);
                    }
                }
            }

            for (int i = 0; i < _table.ChildRelations.Count; i++)
            {
                if (_table.ChildRelations[i].ParentKey.ContainsColumn(column))
                {
                    if (!fThrowException)
                    {
                        return(false);
                    }
                    else
                    {
                        throw ExceptionBuilder.CannotRemoveChildKey(_table.ChildRelations[i].RelationName);
                    }
                }
            }

            for (int i = 0; i < _table.Constraints.Count; i++)
            {
                if (_table.Constraints[i].ContainsColumn(column))
                {
                    if (!fThrowException)
                    {
                        return(false);
                    }
                    else
                    {
                        throw ExceptionBuilder.CannotRemoveConstraint(_table.Constraints[i].ConstraintName, _table.Constraints[i].Table.TableName);
                    }
                }
            }

            if (_table.DataSet != null)
            {
                for (ParentForeignKeyConstraintEnumerator en = new ParentForeignKeyConstraintEnumerator(_table.DataSet, _table); en.GetNext();)
                {
                    Constraint constraint = en.GetConstraint();
                    if (((ForeignKeyConstraint)constraint).ParentKey.ContainsColumn(column))
                    {
                        if (!fThrowException)
                        {
                            return(false);
                        }
                        else
                        {
                            throw ExceptionBuilder.CannotRemoveConstraint(constraint.ConstraintName, constraint.Table.TableName);
                        }
                    }
                }
            }

            if (column._dependentColumns != null)
            {
                for (int i = 0; i < column._dependentColumns.Count; i++)
                {
                    DataColumn col = column._dependentColumns[i];
                    if (_fInClear && (col.Table == _table || col.Table == null))
                    {
                        continue;
                    }

                    if (col.Table == null)
                    {
                        continue;
                    }

                    Debug.Assert(col.Computed, "invalid (non an expression) column in the expression dependent columns");
                    DataExpression expr = col.DataExpression;
                    if ((expr != null) && (expr.DependsOn(column)))
                    {
                        if (!fThrowException)
                        {
                            return(false);
                        }
                        else
                        {
                            throw ExceptionBuilder.CannotRemoveExpression(col.ColumnName, col.Expression);
                        }
                    }
                }
            }

            // you can't remove a column participating in an index,
            // while index events are suspended else the indexes won't be properly maintained.
            // However, all the above checks should catch those participating columns.
            // except when a column is in a DataView RowFilter or Sort clause
            foreach (Index index in _table.LiveIndexes)
            {
            }

            return(true);
        }
Exemplo n.º 50
0
 /// <summary>
 /// Checks if a given column can be removed from the collection.
 /// </summary>
 public bool CanRemove(DataColumn column) => CanRemove(column, false);
Exemplo n.º 51
0
 internal void InitializeColumnChangeEvent(DataColumn column, object value) {            
     _column = column;
     _proposedValue = value;
 }
Exemplo n.º 52
0
 /// <summary>
 /// Adds the specified <see cref='System.Data.DataColumn'/>
 /// to the columns collection.
 /// </summary>
 public void Add(DataColumn column)
 {
     AddAt(-1, column);
 }
Exemplo n.º 53
0
 public DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn)
     : this(relationName, parentColumn, childColumn, true)
 {
 }
Exemplo n.º 54
0
 public static Exception LongerThanMaxLength(DataColumn column) => _Argument(SR.Format(SR.DataColumn_LongerThanMaxLength, column.ColumnName));
Exemplo n.º 55
0
 /// <devdoc>
 ///    <para>
 ///       Initializes a new instance of the <see cref='System.Data.DataColumnChangeEventArgs'/> class.
 ///    </para>
 /// </devdoc>
 public DataColumnChangeEventArgs(DataRow row, DataColumn column, object value) {
     _row = row;
     _column = column;
     _proposedValue = value;
 }
Exemplo n.º 56
0
 private void ArrayAdd(int index, DataColumn column)
 {
     _list.Insert(index, column);
     CheckIChangeTracking(column);
 }
Exemplo n.º 57
0
 public static Exception HasToBeStringType(DataColumn column) => _Argument(SR.Format(SR.DataColumn_HasToBeStringType, column.ColumnName));
Exemplo n.º 58
0
 public static Exception CannotSetMaxLength2(DataColumn column) => _Argument(SR.Format(SR.DataColumn_CannotSetMaxLength2, column.ColumnName));
Exemplo n.º 59
0
    private void mInitializing(Subjects.BannerTypes bannerType)
    {
        switch (bannerType)
        {
        case Subjects.BannerTypes.inActive:
        {
            imgPageBanner.Visible = false;
            rptGallery.Visible    = false;
            break;
        }

        case Subjects.BannerTypes.picture:
        {
            imgPageBanner.Visible = true;
            rptGallery.Visible    = false;

            MediaSubjects mediaSubject = new MediaSubjects();
            mediaSubject.LoadByIDSubjectAndIDMediaSubjectType(Subject.pIDSubject, (byte)MediaSubjectTypes.Enum.headerImage);
            if (mediaSubject.RowCount > 0)
            {
                string   strImageDestinationFolder = Global.Constants.FOLDER_MEDIAS;
                string[] files = System.IO.Directory.GetFiles(MapPath(strImageDestinationFolder), mediaSubject.pIDMedia.ToString() + ".*");
                if (files.Length > 0)
                {
                    imgPageBanner.ImageUrl = string.Format("{0}{1}", Global.Constants.FOLDER_MEDIAS.Substring(1), System.IO.Path.GetFileName(files[0]));
                }
            }
            break;
        }

        case Subjects.BannerTypes.gallery:
        {
            imgPageBanner.Visible = false;
            rptGallery.Visible    = true;

            Subjects subjectGallery = new Subjects(Subject.pIDGallery);
            if (subjectGallery.RowCount > 0)
            {
                MediaSubjects mediaSubjects = new MediaSubjects();
                mediaSubjects.LoadByIDSubjectAndIDMediaSubjectType(subjectGallery.pIDSubject, (byte)MediaSubjectTypes.Enum.gallery);
                mediaSubjects.Sort = MediaSubjects.ColumnNames.Priority;
                if (mediaSubjects.RowCount > 0)
                {
                    System.Data.DataColumn dc = mediaSubjects.AddColumn("FilePath", Type.GetType("System.String"));
                    do
                    {
                        string[] files = System.IO.Directory.GetFiles(MapPath(Global.Constants.FOLDER_MEDIAS), mediaSubjects.pIDMedia.ToString() + ".*");
                        if (files.Length > 0)
                        {
                            mediaSubjects.SetColumn("FilePath", Global.Constants.FOLDER_MEDIAS.Substring(1) + System.IO.Path.GetFileName(files[0]));
                        }
                    }while (mediaSubjects.MoveNext());
                    mSetGalleryScript();

                    rptGallery.DataSource = mediaSubjects.DefaultView;
                    rptGallery.DataBind();
                }
            }
            break;
        }
        }
        uplBanner.Update();
    }
Exemplo n.º 60
0
 private void CreateIndex()
 {
     if (this.index == null)
     {
         if (this.nCandidates == 0)
         {
             this.index = new Index(this.table, this.IndexFields, this.recordStates, null);
             this.index.AddRef();
         }
         else
         {
             int  num;
             int  length = this.candidateColumns.Length;
             int  num5   = this.indexDesc.Length;
             bool flag   = true;
             for (num = 0; num < length; num++)
             {
                 if ((this.candidateColumns[num] != null) && !this.candidateColumns[num].equalsOperator)
                 {
                     flag = false;
                     break;
                 }
             }
             int num2 = 0;
             for (num = 0; num < num5; num++)
             {
                 ColumnInfo info4 = this.candidateColumns[DataKey.ColumnOrder(this.indexDesc[num])];
                 if (info4 != null)
                 {
                     info4.flag = true;
                     num2++;
                 }
             }
             int   num7     = num5 - num2;
             int[] ndexDesc = new int[this.nCandidates + num7];
             if (flag)
             {
                 num2 = 0;
                 for (num = 0; num < length; num++)
                 {
                     if (this.candidateColumns[num] != null)
                     {
                         ndexDesc[num2++] = num;
                         this.candidateColumns[num].flag = false;
                     }
                 }
                 for (num = 0; num < num5; num++)
                 {
                     ColumnInfo info = this.candidateColumns[DataKey.ColumnOrder(this.indexDesc[num])];
                     if ((info == null) || info.flag)
                     {
                         ndexDesc[num2++] = this.indexDesc[num];
                         if (info != null)
                         {
                             info.flag = false;
                         }
                     }
                 }
                 for (num = 0; num < this.candidateColumns.Length; num++)
                 {
                     if (this.candidateColumns[num] != null)
                     {
                         this.candidateColumns[num].flag = false;
                     }
                 }
                 IndexField[] zeroIndexField = DataTable.zeroIndexField;
                 if (0 < ndexDesc.Length)
                 {
                     zeroIndexField = new IndexField[ndexDesc.Length];
                     for (int i = 0; i < ndexDesc.Length; i++)
                     {
                         DataColumn column2      = this.table.Columns[DataKey.ColumnOrder(ndexDesc[i])];
                         bool       isDescending = DataKey.SortDecending(ndexDesc[i]);
                         zeroIndexField[i] = new IndexField(column2, isDescending);
                     }
                 }
                 this.index = new Index(this.table, ndexDesc, zeroIndexField, this.recordStates, null);
                 if (!this.IsOperatorIn(this.expression))
                 {
                     this.index.AddRef();
                 }
                 this.matchedCandidates = this.nCandidates;
             }
             else
             {
                 num = 0;
                 while (num < num5)
                 {
                     ndexDesc[num] = this.indexDesc[num];
                     ColumnInfo info3 = this.candidateColumns[DataKey.ColumnOrder(this.indexDesc[num])];
                     if (info3 != null)
                     {
                         info3.flag = true;
                     }
                     num++;
                 }
                 num2 = num;
                 for (num = 0; num < length; num++)
                 {
                     if (this.candidateColumns[num] != null)
                     {
                         if (!this.candidateColumns[num].flag)
                         {
                             ndexDesc[num2++] = num;
                         }
                         else
                         {
                             this.candidateColumns[num].flag = false;
                         }
                     }
                 }
                 IndexField[] indexFields = DataTable.zeroIndexField;
                 if (0 < ndexDesc.Length)
                 {
                     indexFields = new IndexField[ndexDesc.Length];
                     for (int j = 0; j < ndexDesc.Length; j++)
                     {
                         DataColumn column = this.table.Columns[DataKey.ColumnOrder(ndexDesc[j])];
                         bool       flag2  = DataKey.SortDecending(ndexDesc[j]);
                         indexFields[j] = new IndexField(column, flag2);
                     }
                 }
                 this.index             = new Index(this.table, ndexDesc, indexFields, this.recordStates, null);
                 this.matchedCandidates = 0;
                 if (this.linearExpression != this.expression)
                 {
                     int[] indexDesc = this.index.IndexDesc;
                     while (this.matchedCandidates < num2)
                     {
                         ColumnInfo info2 = this.candidateColumns[DataKey.ColumnOrder(indexDesc[this.matchedCandidates])];
                         if ((info2 == null) || (info2.expr == null))
                         {
                             break;
                         }
                         this.matchedCandidates++;
                         if (!info2.equalsOperator)
                         {
                             break;
                         }
                     }
                 }
                 for (num = 0; num < this.candidateColumns.Length; num++)
                 {
                     if (this.candidateColumns[num] != null)
                     {
                         this.candidateColumns[num].flag = false;
                     }
                 }
             }
         }
     }
 }