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"]; } }
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; }
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(); }
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(); }
//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;} }
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(); }
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(); } }
//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); }
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"); }
//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; }
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; }
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(); }
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"); }
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; }
/// <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; }
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; }
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(); }
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(); }
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>(); }
//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;} }
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)); }
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; }
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); } }
/// <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); }
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); }
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++); } } }
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); }
/// <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))); } }
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); }
/// <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); }
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)); }
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); }
public DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn, bool createConstraints) : this(relationName, new DataColumn[] { parentColumn }, new DataColumn [] { childColumn }, createConstraints) { }
public DataRowPropertyDescriptor(DataColumn column) : base(column.ColumnName, null) { _col = column; }
public static Exception ExpressionAndConstraint(DataColumn column, Constraint constraint) => _Argument(SR.Format(SR.DataColumn_ExpressionAndConstraint, column.ColumnName, constraint.ConstraintName));
public static Exception ExpressionInConstraint(DataColumn column) => _Argument(SR.Format(SR.DataColumn_ExpressionInConstraint, column.ColumnName));
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);
public static Exception CannotSetToNull(DataColumn column) => _Argument(SR.Format(SR.DataColumn_CannotSetToNull, column.ColumnName));
/// <summary> /// Adds the column to the columns array. /// </summary> private void ArrayAdd(DataColumn column) { _list.Add(column); column.SetOrdinalInternal(_list.Count - 1); CheckIChangeTracking(column); }
public static Exception CannotSetMaxLength(DataColumn column, int value) => _Argument(SR.Format(SR.DataColumn_CannotSetMaxLength, column.ColumnName, value.ToString(CultureInfo.InvariantCulture)));
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); }
/// <summary> /// Checks if a given column can be removed from the collection. /// </summary> public bool CanRemove(DataColumn column) => CanRemove(column, false);
internal void InitializeColumnChangeEvent(DataColumn column, object value) { _column = column; _proposedValue = value; }
/// <summary> /// Adds the specified <see cref='System.Data.DataColumn'/> /// to the columns collection. /// </summary> public void Add(DataColumn column) { AddAt(-1, column); }
public DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn) : this(relationName, parentColumn, childColumn, true) { }
public static Exception LongerThanMaxLength(DataColumn column) => _Argument(SR.Format(SR.DataColumn_LongerThanMaxLength, column.ColumnName));
/// <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; }
private void ArrayAdd(int index, DataColumn column) { _list.Insert(index, column); CheckIChangeTracking(column); }
public static Exception HasToBeStringType(DataColumn column) => _Argument(SR.Format(SR.DataColumn_HasToBeStringType, column.ColumnName));
public static Exception CannotSetMaxLength2(DataColumn column) => _Argument(SR.Format(SR.DataColumn_CannotSetMaxLength2, column.ColumnName));
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(); }
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; } } } } } }