protected void Page_Load(object sender, EventArgs e) { var createdColumn = new BoundField(); createdColumn.DataField = "Created"; createdColumn.HeaderText = "Datum"; createdColumn.DataFormatString = "{0:dd-MM-yyyy}"; var deliveryPriceColumn = new BoundField(); deliveryPriceColumn.HeaderText = "Verzendkosten"; deliveryPriceColumn.DataField = "DeliveryPrice"; deliveryPriceColumn.DataFormatString = "{0:C}"; var viewColumn = new HyperLinkField(); viewColumn.Text = "Bekijk"; viewColumn.Target = "_blank"; viewColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Order&order={0}"; viewColumn.DataNavigateUrlFields = new[] { "Id" }; var pdfColumn = new HyperLinkField(); pdfColumn.Text = "PDF"; pdfColumn.Target = "_blank"; pdfColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Order&method=Pdf&order={0}"; pdfColumn.DataNavigateUrlFields = new[] { "Id" }; this.GridViewOrders.Columns.Add(createdColumn); this.GridViewOrders.Columns.Add(deliveryPriceColumn); this.GridViewOrders.Columns.Add(viewColumn); this.GridViewOrders.Columns.Add(pdfColumn); this.GridViewOrders.AutoGenerateColumns = false; this.GridViewOrders.DataSource = new BusinessLogicLayer.Order().GetAll(); this.GridViewOrders.DataBind(); }
protected void GenerateColumns() { // remove all previous rows because we set EnableViewState="True" gvScholPrograms.Columns.Clear(); /* set ScholID as the primary keys of each row */ gvScholPrograms.DataKeyNames = new string[] { "ScholID" }; /* 1st column = Scholarship Name */ HyperLinkField hlf = new HyperLinkField(); hlf.HeaderText = TextCode(10421); hlf.HeaderStyle.CssClass = "leftAlign"; hlf.SortExpression = "ScholName"; hlf.DataTextField = "ScholName"; hlf.DataNavigateUrlFields = new string[] { "ScholID" }; hlf.DataNavigateUrlFormatString = "ScholAppDetailsPrinterFriendly.aspx?LoginID=" + LoginID + "&ScholID={0}"; hlf.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(hlf); /* 2nd column = Deadline */ BoundField bf2 = new BoundField(); bf2.HeaderText = TextCode(10422); bf2.SortExpression = "DeadlineSorting"; bf2.DataField = "Deadline"; bf2.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(bf2); /* 3rd column = Status */ BoundField bf3 = new BoundField(); bf3.HeaderText = TextCode(10423); bf3.SortExpression = "Status"; bf3.DataField = "Status"; bf3.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(bf3); }
protected override void CopyProperties(DataControlField newField) { base.CopyProperties(newField); HyperLinkField field = (HyperLinkField)newField; field.DataNavigateUrlFields = DataNavigateUrlFields; field.DataNavigateUrlFormatString = DataNavigateUrlFormatString; field.DataTextField = DataTextField; field.DataTextFormatString = DataTextFormatString; field.NavigateUrl = NavigateUrl; field.Target = Target; field.Text = Text; }
/// <summary> /// /// </summary> private HyperLinkField CreateHyperLinkField() { HyperLinkField hlField = new HyperLinkField(); hlField.Text = "详细"; hlField.DataNavigateUrlFields = new string[] { "WaterUserID" }; // url format string // string urlFormatString = string.Format("{0}?WaterUserID={{0}}&Begin={1}&End={2}", "pDataHistory.aspx", Server.UrlEncode(this.UCWaterUserListDTTwo1.Begin.ToString()), Server.UrlEncode(this.UCWaterUserListDTTwo1.End.ToString())); hlField.DataNavigateUrlFormatString = urlFormatString; return hlField; }
protected void GenerateColumns() { // remove all previous rows because we set EnableViewState="True" gvScholPrograms.Columns.Clear(); /* set ScholID as the primary keys of each row */ gvScholPrograms.DataKeyNames = new string[] { "ScholID" }; /* 1st column = Scholarship Name */ HyperLinkField hlf = new HyperLinkField(); hlf.HeaderText = TextCode(10421); hlf.HeaderStyle.CssClass = "leftAlign"; hlf.SortExpression = "ScholName"; hlf.DataTextField = "ScholName"; hlf.DataNavigateUrlFields = new string[] {"ScholID"}; hlf.DataNavigateUrlFormatString = "ScholarshipAppDetails.aspx?LoginID=" + LoginID + "&ScholID={0}"; hlf.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(hlf); /* 2nd column = Deadline */ BoundField bf2 = new BoundField(); bf2.HeaderText = TextCode(10422); bf2.SortExpression = "DeadlineSorting"; bf2.DataField = "Deadline"; bf2.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(bf2); /* 3rd column = Status */ BoundField bf3 = new BoundField(); bf3.HeaderText = TextCode(10423); bf3.SortExpression = "Status"; bf3.DataField = "Status"; bf3.ItemStyle.CssClass = "leftAlign"; gvScholPrograms.Columns.Add(bf3); /* 4 column = Options */ CommandField cf = new CommandField(); cf.HeaderText = TextCode(9234); cf.ButtonType = ButtonType.Image; cf.ShowDeleteButton = true; cf.DeleteImageUrl = "/media/shared/ico_delete.gif"; cf.DeleteText = TextCode(3488); cf.ShowEditButton = true; cf.EditImageUrl = "/media/shared/ico_edit.gif"; cf.EditText = TextCode(3489); gvScholPrograms.Columns.Add(cf); }
/** * Por si quiero iterar solo sobre el panel * ContentPlaceHolder cp = (ContentPlaceHolder)this.Master.FindControl("modalCarga"); **/ protected void GenerarColumnas(GridView gv) { if (gv.Columns.Count == 0) { Type tipoCompleto = gv.DataSource.GetType().GetGenericArguments()[0]; BindingFlags flags = BindingFlags.Public | BindingFlags.Instance; PropertyInfo[] properties = tipoCompleto.GetProperties(flags); string[] palabras = tipoCompleto.ToString().Split('.'); string tipo = palabras.Last(); int totalColumnas = 0; Unit u = new Unit("30px"); foreach (PropertyInfo property in properties) { var oTipo = property.PropertyType; if (!(oTipo.IsGenericType && (oTipo.GetGenericTypeDefinition() == typeof(List<>)))) { BoundField bf = new BoundField(); bf.HeaderText = property.Name; bf.DataField = property.Name; gv.Columns.Add(bf); } } HyperLinkField enlaceEdicion = new HyperLinkField(); enlaceEdicion.Text = "<span class='glyphicon glyphicon-edit'></span>"; enlaceEdicion.DataNavigateUrlFields = new string[] { "Id" }; enlaceEdicion.DataNavigateUrlFormatString = "Edit/" + tipo + "?Id={0}"; enlaceEdicion.ItemStyle.Width = u; gv.Columns.Add(enlaceEdicion); HyperLinkField enlaceBorrado = new HyperLinkField(); enlaceBorrado.Text = "<span class='glyphicon glyphicon-remove'></span>"; enlaceBorrado.DataNavigateUrlFields = new string[] { "Id" }; enlaceBorrado.DataNavigateUrlFormatString = "Remove/" + tipo + "?Id={0}"; enlaceBorrado.ItemStyle.Width = u; gv.Columns.Add(enlaceBorrado); totalColumnas = gv.Columns.Count; } }
/// <summary> /// 为PRPO的报表添加可查看PO详细信息的链接。 /// </summary> void BindPRPOGrid() { if (SPGridView1.Columns.Count > 0) { return; } BoundField BFPRNO = new BoundField(); BFPRNO.DataField = "PR Number"; BFPRNO.HeaderText = "PR Number"; SPGridView1.Columns.Add(BFPRNO); HyperLinkField HLFPONO = new HyperLinkField(); HLFPONO.HeaderText = "PO Number"; string[] pram = { "PO Number" }; HLFPONO.DataNavigateUrlFields = pram; HLFPONO.DataNavigateUrlFormatString = "PORedirct.aspx?PONO={0}";//PORedirct HLFPONO.DataTextField = "PO Number"; SPGridView1.Columns.Add(HLFPONO); BoundField BFCost = new BoundField(); BFCost.DataField = "PO Cost"; BFCost.HeaderText = "PO Cost"; SPGridView1.Columns.Add(BFCost); BoundField BFVendor = new BoundField(); BFVendor.DataField = "Vendor Name"; BFVendor.HeaderText = "Vendor Name"; SPGridView1.Columns.Add(BFVendor); BoundField BFIsGR = new BoundField(); BFIsGR.DataField = "Is Complete GR/SR"; BFIsGR.HeaderText = "Is Complete GR/SR"; SPGridView1.Columns.Add(BFIsGR); }
public override DataControlFieldsEditor.FieldItem CreateField() { HyperLinkField runtimeField = new HyperLinkField(); DataControlFieldsEditor.FieldItem item = new DataControlFieldsEditor.HyperLinkFieldItem(this._fieldsEditor, runtimeField) { Text = this.hyperLinkText }; item.LoadFieldInfo(); return item; }
private void FillMSARecommendationWorkQueue(SPWeb oSPWeb, SPUser currentUser) { try { if (oSPWeb != null) { string getName = string.Empty; DataTable dt = new DataTable(); dt.Columns.Add("ItemID", typeof(int)); dt.Columns.Add("RecommendationNo", typeof(string)); dt.Columns.Add("ResponsiblePerson", typeof(string)); dt.Columns.Add("TargetDate", typeof(string)); dt.Columns.Add("TaskName", typeof(string)); dt.Columns.Add("LinkFileName", typeof(string)); dt.Columns.Add("LinkDisplayText", typeof(string)); string listName = "MSARecommendation"; // Fetch the List SPList splistMSARecommendation = oSPWeb.GetList(string.Format("{0}/Lists/{1}/AllItems.aspx", oSPWeb.Url, listName)); SPQuery query = new SPQuery(); SPListItemCollection spListItems; // Include only the fields you will use. StringBuilder vf = new StringBuilder(); vf.Append("<FieldRef Name='ID' />") .Append("<FieldRef Name='MSARecommendationDescription'/>") .Append("<FieldRef Name='TargetDate'/>") .Append("<FieldRef Name='ResponsiblePerson'/>") .Append("<FieldRef Name='ApprovedBy'/>") .Append("<FieldRef Name='ResponsibleDepartment'/>") .Append("<FieldRef Name='AssigneeEmail'/>") .Append("<FieldRef Name='RecommendationNo'/>"); query.ViewFields = vf.ToString(); query.ViewFieldsOnly = true; query.Query = "<Where><And><And><Neq><FieldRef Name='Status' /><Value Type='Text'>Completed</Value></Neq><Eq><FieldRef Name='AssigneeEmail' /><Value Type='Text'>" + currentUser.Email + "</Value></Eq></And><Eq><FieldRef Name='IsSavedAsDraft' /><Value Type='Boolean'>0</Value></Eq></And></Where>"; //query.Query = "<Where><And><Eq><FieldRef Name='AssigneeEmail' /><Value Type='Text'>" + currentUser.Email + "</Value></Eq><Eq><FieldRef Name='IsSavedAsDraft' /><Value Type='Boolean'>0</Value></Eq></And></Where>"; spListItems = splistMSARecommendation.GetItems(query); DataRow dr; if (spListItems != null && spListItems.Count > 0) { foreach (SPListItem item in spListItems) { dr = dt.NewRow(); dr["ItemID"] = item["ID"]; dr["RecommendationNo"] = item["RecommendationNo"] != null ? Convert.ToString(item["RecommendationNo"]) : ""; string rpUsername = item["ResponsiblePerson"] != null ? Convert.ToString(item["ResponsiblePerson"]) : ""; SPUser responsiblePerson = null; if (!String.IsNullOrEmpty(rpUsername)) { responsiblePerson = Utility.GetUser(oSPWeb, rpUsername); if (responsiblePerson != null) { dr["ResponsiblePerson"] = responsiblePerson.Name; } } DateTime date; bool bValid = DateTime.TryParse(Convert.ToString(item["TargetDate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out date); if (bValid) { dr["TargetDate"] = date.ToShortDateString(); } else { try { dr["TargetDate"] = Convert.ToDateTime(Convert.ToString(item["TargetDate"])).ToShortDateString(); } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("WQ-TRGD:" + Convert.ToString(item["TargetDate"]), TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace); } } dr["TaskName"] = "MSA Recommendation"; string recommendationLink = Utility.GetRedirectUrl("MSARecommendationFormLink"); dr["LinkFileName"] = string.Format("{0}?MSARID=" + item["ID"], recommendationLink); if (String.IsNullOrEmpty(Convert.ToString(item["ApprovedBy"]))) { if (getHOD(oSPWeb, Convert.ToString(item["ResponsibleDepartment"]), responsiblePerson.Email)) { dr["LinkDisplayText"] = "View (for approval)"; } else { dr["LinkDisplayText"] = "View (for submission)"; } } else { if (Convert.ToString(item["ApprovedBy"]).Equals(Convert.ToString(item["AssigneeEmail"]),StringComparison.OrdinalIgnoreCase)) { dr["LinkDisplayText"] = "View (for approval)"; } else { dr["LinkDisplayText"] = "View (for submission)"; } } dt.Rows.Add(dr); } } BoundField bf = new BoundField(); bf.DataField = "ItemID"; bf.HeaderText = "ID #"; grdMSARecommendationTask.Columns.Add(bf); //RecommendationNo Column bf = new BoundField(); bf.DataField = "RecommendationNo"; bf.HeaderText = "Recommendation No"; grdMSARecommendationTask.Columns.Add(bf); bf = new BoundField(); bf.DataField = "ResponsiblePerson"; bf.HeaderText = "Responsible Person"; grdMSARecommendationTask.Columns.Add(bf); bf = new BoundField(); bf.DataField = "TargetDate"; bf.HeaderText = "Target Date"; grdMSARecommendationTask.Columns.Add(bf); HyperLinkField hyperlinkField = new HyperLinkField(); hyperlinkField.HeaderText = "View Recommendations"; hyperlinkField.DataNavigateUrlFields = new[] { "LinkFileName" }; //hyperlinkField.Text = "View"; hyperlinkField.DataTextField = "LinkDisplayText"; grdMSARecommendationTask.Columns.Add(hyperlinkField); grdMSARecommendationTask.DataSource = dt; grdMSARecommendationTask.DataBind(); } } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL(WorkQueue->FillMSARecommendationWorkQueue)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace); message_div.InnerHtml = "Something went wrong!!! Please Contact the administrator."; } }
/// <summary> /// Adds the column with a link to profile page. /// </summary> private void AddPersonProfileLinkColumn() { HyperLinkField hlPersonProfileLink = new HyperLinkField(); hlPersonProfileLink.ItemStyle.HorizontalAlign = HorizontalAlign.Center; hlPersonProfileLink.HeaderStyle.CssClass = "grid-columncommand"; hlPersonProfileLink.ItemStyle.CssClass = "grid-columncommand"; hlPersonProfileLink.DataNavigateUrlFields = new string[1] { "PersonId" }; hlPersonProfileLink.DataNavigateUrlFormatString = LinkedPageUrl( "PersonProfilePage", new Dictionary<string, string> { { "PersonId", "###" } } ).Replace( "###", "{0}" ); hlPersonProfileLink.DataTextFormatString = "<div class='btn btn-default'><i class='fa fa-user'></i></div>"; hlPersonProfileLink.DataTextField = "PersonId"; gGroupMembers.Columns.Add( hlPersonProfileLink ); }
public void HyperLinkField_AssignProperty () { HyperLinkField field = new HyperLinkField (); field.DataNavigateUrlFields = new string[] { "test1", "test2" }; Assert.AreEqual (2, ((Array) field.DataNavigateUrlFields).Length, "DataNavigateUrlFieldsCount"); Assert.AreEqual ("test1", field.DataNavigateUrlFields[0], "DataNavigateUrlFields#1"); Assert.AreEqual ("test2", field.DataNavigateUrlFields[1], "DataNavigateUrlFields#2"); field.DataNavigateUrlFormatString = "test"; Assert.AreEqual ("test", field.DataNavigateUrlFormatString, "DataNavigateUrlFormatString"); field.DataTextField = "test"; Assert.AreEqual ("test", field.DataTextField, "DataTextField"); field.DataTextFormatString = "test"; Assert.AreEqual ("test", field.DataTextFormatString, "DataTextFormatString"); field.NavigateUrl = "test"; Assert.AreEqual ("test", field.NavigateUrl, "NavigateUrl"); field.Target = "test"; Assert.AreEqual ("test", field.Target, "Target"); field.Text = "test"; Assert.AreEqual ("test", field.Text, "Text"); }
/// <summary> /// 添加自定义列到Grid的Column中 /// </summary> /// <param name="column"></param> void AddToGridColumn(GridColumn column) { FieldType type = column.type; switch (type) { case FieldType.LineNumberField: LineNumberField lnf = new LineNumberField(); lnf.IsContinuousArrange = true; lnf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; lnf.HeaderStyle.Width = column.unit; lnf.ItemStyle.Width = column.unit; lnf.ItemStyle.HorizontalAlign = HorizontalAlign.Center; this.Columns.Add(lnf); break; case FieldType.BoundField: BoundField bf = new BoundField(); bf.HeaderText = column.headerName; bf.HeaderStyle.Width = column.unit; bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; bf.DataField = column.fieldName; bf.ItemStyle.Width = column.unit; bf.ItemStyle.HorizontalAlign = column.hAlign; bf.SortExpression = column.fieldName; this.Columns.Add(bf); break; case FieldType.ButtonField: ButtonField btn = new ButtonField(); btn.HeaderText = column.headerName; btn.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; btn.HeaderStyle.Width = column.unit; btn.HeaderStyle.Wrap = false; btn.ButtonType = column.button; btn.ItemStyle.Width = column.unit; btn.ItemStyle.HorizontalAlign = column.hAlign; if (btn.ButtonType == ButtonType.Image) { btn.ImageUrl = column.fieldName; } else { btn.Text = column.fieldName; } btn.CommandName = column.commandName; this.Columns.Add(btn); break; case FieldType.RadioButtonField: RadioButtonField rbf = new RadioButtonField(); rbf.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; rbf.HeaderStyle.Width = column.unit; rbf.ItemStyle.Width = column.unit; this.Columns.Add(rbf); break; case FieldType.CheckBoxExField: CheckBoxExField cbef = new CheckBoxExField(); cbef.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; cbef.HeaderStyle.Width = column.unit; cbef.ItemStyle.Width = column.unit; cbef.CheckedValue = "1"; this.Columns.Add(cbef); break; case FieldType.CheckBoxField: CheckBoxField cbf = new CheckBoxField(); cbf.HeaderText = column.headerName; cbf.DataField = column.fieldName; cbf.ItemStyle.HorizontalAlign = column.hAlign; this.Columns.Add(cbf); break; case FieldType.HyperLinkField: HyperLinkField hf = new HyperLinkField(); //hf.Text = column.headerName; hf.HeaderText = column.headerName; if (string.IsNullOrEmpty(column.text)) { hf.DataTextField = column.fieldName; } else { hf.Text = column.text; } hf.ItemStyle.HorizontalAlign = column.hAlign; hf.Target = column.target; hf.DataNavigateUrlFields = column.dataNavigateUrlFields; hf.DataNavigateUrlFormatString = column.dataNavigateUrlFormatString; this.Columns.Add(hf); break; case FieldType.LinkButtonTemplate: LinkButtonTemplate lbt = column._linkButtonTemplate; TemplateField templateLinkButtonField = new TemplateField(); templateLinkButtonField.ItemTemplate = lbt; templateLinkButtonField.HeaderText = column.headerName; templateLinkButtonField.HeaderStyle.Width = templateLinkButtonField.ItemStyle.Width = column.unit; templateLinkButtonField.HeaderStyle.HorizontalAlign = templateLinkButtonField.ItemStyle.HorizontalAlign = column.hAlign; this.Columns.Add(templateLinkButtonField); break; case FieldType.DialogButtonTemplate: DialogButtonTemplate dialogButtonTemplate = column._dialogButtonTemplate; TemplateField templateField = new TemplateField(); templateField.ItemTemplate = dialogButtonTemplate; templateField.HeaderText = column.headerName; templateField.HeaderStyle.Width = templateField.ItemStyle.Width = column.unit; templateField.HeaderStyle.HorizontalAlign = templateField.ItemStyle.HorizontalAlign = column.hAlign; this.Columns.Add(templateField); break; case FieldType.TextBoxTemplate: TextBoxTemplate tb = column._textBoxTemplate; TemplateField ttb = new TemplateField(); ttb.ItemTemplate = tb; ttb.HeaderText = column.headerName; ttb.HeaderStyle.Width = ttb.ItemStyle.Width = column.unit; ttb.HeaderStyle.HorizontalAlign = ttb.ItemStyle.HorizontalAlign = column.hAlign; this.Columns.Add(ttb); break; case FieldType.ButtonTemplate: ButtonTemplate bt = column._buttonTemplate; TemplateField templateButtonField = new TemplateField(); templateButtonField.ItemTemplate = bt; templateButtonField.HeaderText = column.headerName; templateButtonField.HeaderStyle.Width = templateButtonField.ItemStyle.Width = column.unit; templateButtonField.HeaderStyle.HorizontalAlign = templateButtonField.ItemStyle.HorizontalAlign = column.hAlign; this.Columns.Add(templateButtonField); break; default: if (column._dataControlField != null) { this.Columns.Add(column._dataControlField); } break; } }
protected void Query_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(Database.SelectedValue)) return; if (string.IsNullOrEmpty(TableNames.SelectedValue)) return; var categoryData = ViewState["Category"] as List<Category>; var sub = categoryData.SelectMany(c => c.SubCategoryList).Where(sc => sc.Name == Database.SelectedValue).SingleOrDefault(); if (sub == null) return; var data = service.GetTableData(sub.DatabasePrefix, new List<string> { TableNames.SelectedValue }, DateTime.Parse(StartTime.Text), DateTime.Parse(EndTime.Text), 0, 10, null).First(); var pkColumn = ""; var dataTable = new DataTable(data.TableName); if (data.Data.Count > 0) { foreach (var column in data.Data.OrderByDescending(item => item.Values.Count).First()) { if (column.Key.StartsWith("#")) pkColumn = column.Key; dataTable.Columns.Add(column.Key); } foreach (var row in data.Data) { var dataRow = dataTable.NewRow(); foreach (var column in row) { dataRow[column.Key] = column.Value; } dataTable.Rows.Add(dataRow); } } GridView1.Columns.Clear(); GridView1.DataSource = dataTable; HyperLinkField objHC = new HyperLinkField(); objHC.DataNavigateUrlFields = new string[] { pkColumn }; objHC.DataTextField = pkColumn; objHC.DataNavigateUrlFormatString = "Detail.aspx?Id={0}" + "&DatabaseName=" + data.DatabaseName + "&TableName=" + data.TableName + "&pkColumnName=" + pkColumn.TrimStart('#') + "&databasePrefix=" + sub.DatabasePrefix; GridView1.Columns.Add(objHC); GridView1.DataBind(); }
private void Perfil( int perfil , string sql , string patron= null) { Conexion conn = new Conexion(); conn.IniciarConexion(); try { List<string> listacursos = new List<string>() ; MySqlDataAdapter adaptador_ = new MySqlDataAdapter(sql, conn.GetConexion); DataSet ds = new DataSet(); adaptador_.Fill(ds); DataTable dt_aux = ds.Tables[0]; DataTable dt = new DataTable(); int col = Grilla_datos.Columns.Count; if (dt_aux.Rows.Count <= 0) { cuadro_error.Visible = true; cuadro_error.InnerHtml = "<p align='center'> NO SE ENCONTRARON RESULTADOS , FAVOR INTENTAR DENUEVO </P>"; } else cuadro_error.Visible = false; Grilla_datos.Columns.Clear(); Grilla_datos.AutoGenerateColumns = false; dt.Columns.Add("imagen"); dt.Columns.Add("nombre"); dt.Columns.Add("estado"); dt.Columns.Add("docente"); dt.Columns.Add("fecha"); dt.Columns.Add("abierto"); dt.Columns.Add("registrar"); dt.Columns.Add("comentarios"); try { if (perfil == 0) { string query = "select id_curso from estudiante_curso where id_user like '" + id_usuario + "'"; List<object> list = conn.Get_Consulta(query); if (list.Count != 0) { for (int i = 0; i < list.Count; i++) { object[] objeto_lista = (object[])list[i]; listacursos.Add(objeto_lista[0].ToString()); } } } else if (perfil == 1) { string query = "select id_curso from estudiante_curso where id_user like '" + id_usuario + "'"; List<object> list = conn.Get_Consulta(query); if (list.Count != 0) { for (int i = 0; i < list.Count; i++) { object[] objeto_lista = (object[])list[i]; listacursos.Add(objeto_lista[0].ToString()); } } } } catch { } foreach (DataRow rows in dt_aux.Rows) { object[] obj = rows.ItemArray; obj[0] = Seguridad.HttpUrl + "/images/cursos/" + obj[0]; if (Convert.ToInt32(obj[2]) == 1) obj[2] = "Activo"; else obj[2] = "No activo"; if (Convert.ToInt32(obj[5]) == 0) { obj[5] = Seguridad.HttpUrl + "/images/icons/candado1.png"; obj[7] = "Curso exclusivo "; } else { obj[5] = Seguridad.HttpUrl + "/images/icons/candado0.png"; obj[7] = "Curso para todo publico "; } int bandera = 0; if (listacursos.Count != 0) { foreach (string cursos_actuales in listacursos) { if (cursos_actuales != obj[6].ToString()) { bandera = 0; continue; } else { bandera = 1; break; } } } if (bandera == 1) { obj[7] += " , [Ya estas registrado]"; obj[6] = null; } else obj[6] = "" + Encriptador.Encriptar_Md5(obj[6].ToString()); dt.Rows.Add(obj); } ImageField img = new ImageField(); DataControlField Dcontrol; img.ShowHeader = true; img.HeaderText = ""; img.DataImageUrlField = "imagen"; img.ControlStyle.Width = 100; img.ControlStyle.Height = 100; Dcontrol = img; Grilla_datos.Columns.Add(img); BoundField Bcampo = new BoundField(); Bcampo.HeaderText = "NOMBRE CURSO "; Bcampo.DataField = "nombre"; Dcontrol = Bcampo; Grilla_datos.Columns.Add(Bcampo); Bcampo = new BoundField(); Bcampo.HeaderText = "ESTADO "; Bcampo.DataField = "estado"; Dcontrol = Bcampo; Grilla_datos.Columns.Add(Bcampo); Bcampo = new BoundField(); Bcampo.HeaderText = "DOCENTE DEL CURSO "; Bcampo.DataField = "docente"; Dcontrol = Bcampo; Grilla_datos.Columns.Add(Bcampo); Bcampo = new BoundField(); Bcampo.HeaderText = "INICIO EL "; Bcampo.DataField = "fecha"; Dcontrol = Bcampo; Grilla_datos.Columns.Add(Bcampo); img = new ImageField(); img.ShowHeader = true; img.HeaderText = "ENTRADA "; img.DataImageUrlField = "abierto"; img.ControlStyle.Width = 25; img.ControlStyle.Height =25; Dcontrol = img; Grilla_datos.Columns.Add(img); HyperLinkField link = new HyperLinkField(); link.HeaderText = "REGISTRAR CURSO"; link.Text = "Registrar"; link.DataNavigateUrlFields = new string[] { "registrar" }; link.DataNavigateUrlFormatString = "RegistrarCurso.aspx?id={0}"; link.NavigateUrl = "hola.aspx"; Dcontrol = link; Grilla_datos.Columns.Add(link); Bcampo = new BoundField(); Bcampo.HeaderText = "COMENTARIOS "; Bcampo.DataField = "comentarios"; Dcontrol = Bcampo; Grilla_datos.Columns.Add(Bcampo); Grilla_datos.DataSource = dt; Grilla_datos.DataBind(); conn.CerrarConexion(); return; } catch (Exception ex) { try { Log.Set_Log_Error(ex.Message , "buscar cursos " , id_usuario); conn.CerrarConexion(); } catch {} } cuadro_error.Visible = true; cuadro_error.InnerHtml = "<p align='center'> NO SE ENCONTRARON RESULTADOS , FAVOR INTENTAR DENUEVO </P>"; return; }
/// <summary> /// The page_ load. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void Page_Load(object sender, EventArgs e) { if (this.Products.Count == 0) { this.Response.Redirect("/"); } this.FirstNameDelivery.Text = this.User.ShippingAddress.Address.FirstName; this.FirstNameInvoice.Text = this.User.InvoiceAddress.Address.FirstName; this.LastNameDelivery.Text = this.User.ShippingAddress.Address.LastName; this.LastNameInvoice.Text = this.User.InvoiceAddress.Address.LastName; this.CompanyNameDelivery.Text = this.User.ShippingAddress.Address.CompanyName; this.CompanyNameInvoice.Text = this.User.InvoiceAddress.Address.CompanyName; this.PostalCodeDelivery.Text = this.User.ShippingAddress.Address.PostalCode; this.PostalCodeInvoice.Text = this.User.InvoiceAddress.Address.PostalCode; this.AddressNumberDelivery.Text = this.User.ShippingAddress.Address.AddressNumber; this.AddressNumbeInvoice.Text = this.User.InvoiceAddress.Address.AddressNumber; var nameColumn = new HyperLinkField(); nameColumn.DataTextField = "Name"; nameColumn.HeaderText = "Naam"; nameColumn.Target = "_blank"; nameColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Product&product={0}"; nameColumn.DataNavigateUrlFields = new[] { "Id" }; var amountColumn = new BoundField(); amountColumn.DataField = "Amount"; amountColumn.HeaderText = "Aantal"; var priceColumn = new BoundField(); priceColumn.DataField = "Price"; priceColumn.HeaderText = "Prijs"; priceColumn.DataFormatString = "{0:C}"; priceColumn.FooterText = "<strong>Totaal</strong>"; var totalColumn = new BoundField(); totalColumn.DataField = "Total"; totalColumn.HeaderText = "Totaal"; totalColumn.DataFormatString = "{0:C}"; totalColumn.FooterText = this.Products.Sum(x => x.Total).ToString("C"); this.GridViewProducts.ShowFooter = true; this.GridViewProducts.AutoGenerateColumns = false; this.GridViewProducts.Columns.Clear(); this.GridViewProducts.Columns.Add(nameColumn); this.GridViewProducts.Columns.Add(amountColumn); this.GridViewProducts.Columns.Add(priceColumn); this.GridViewProducts.Columns.Add(totalColumn); this.GridViewProducts.DataSource = this.Products; this.GridViewProducts.DataBind(); }
void atualizarGrelha() { //limpar grelha GridView1.Columns.Clear(); DataTable dados = bd.devolveConsulta("SELECT * FROM produto"); if (dados == null || dados.Rows.Count == 0) return; //adicionar coluna remover DataColumn cRemover = new DataColumn(); cRemover.ColumnName = "Remover"; cRemover.DataType = Type.GetType("System.String"); dados.Columns.Add(cRemover); //adicionar coluna editar DataColumn cEditar = new DataColumn(); cEditar.ColumnName = "Editar"; cEditar.DataType = Type.GetType("System.String"); dados.Columns.Add(cEditar); //associar datatable GridView1.DataSource = dados; GridView1.AutoGenerateColumns = false; //definir as colunas manualmente //coluna remover HyperLinkField lnkRemover = new HyperLinkField(); lnkRemover.HeaderText = "Remover"; lnkRemover.DataTextField = "Remover"; //nome da coluna no datatable lnkRemover.Text = "Remover"; lnkRemover.DataNavigateUrlFormatString = "removerproduto.aspx?id={0}"; lnkRemover.DataNavigateUrlFields = new string[] {"id" }; GridView1.Columns.Add(lnkRemover);//////////////////////////////////// //coluna editar HyperLinkField lnkEditar = new HyperLinkField(); lnkEditar.HeaderText = "Editar"; lnkEditar.DataTextField = "Editar"; lnkEditar.Text = "Editar"; lnkEditar.DataNavigateUrlFormatString = "editarproduto.aspx?id={0}"; lnkEditar.DataNavigateUrlFields = new string[] { "id" }; GridView1.Columns.Add(lnkEditar); //coluna id BoundField bfId = new BoundField(); bfId.DataField = "id"; bfId.HeaderText = "Id"; GridView1.Columns.Add(bfId); //coluna descrição BoundField bfDesc = new BoundField(); bfDesc.DataField = "descricao"; bfDesc.HeaderText = "Descrição"; GridView1.Columns.Add(bfDesc); //coluna preço BoundField bfPreco = new BoundField(); bfPreco.DataField = "preco"; bfPreco.HeaderText = "Preço"; GridView1.Columns.Add(bfPreco); //coluna quantidade BoundField bfQuant = new BoundField(); bfQuant.DataField = "quantidade"; bfQuant.HeaderText = "Quantidade"; GridView1.Columns.Add(bfQuant); //Imagem ImageField imagem = new ImageField(); imagem.DataImageUrlFormatString = "~/Imagens/{0}.jpg"; imagem.DataImageUrlField = "id"; imagem.HeaderText = "Imagem"; imagem.ControlStyle.Width = 100; GridView1.Columns.Add(imagem); //refresh/bind GridView1.DataBind(); }
private void FillMSAScheduleWorkQueue(SPWeb oSPWeb, SPUser currentUser) { try { DataTable dt = new DataTable(); dt.Columns.Add("AreaAudited", typeof(string)); dt.Columns.Add("StartTime", typeof(string)); dt.Columns.Add("EndTime", typeof(string)); dt.Columns.Add("LinkFileName", typeof(string)); SPSecurity.RunWithElevatedPrivileges(delegate() { using (SPSite oSPSite = new SPSite(SPContext.Current.Web.Url)) { using (SPWeb pSPWeb = oSPSite.OpenWeb()) { SPList spList = pSPWeb.Lists["MSA Schedule"]; SPQuery spQuery = new SPQuery(); StringBuilder sb = new StringBuilder(); sb.Append("<Where>") .Append("<And>") .Append("<Eq>") .Append("<FieldRef Name='FFLScheduleName' />") .Append("<Value Type='User'>" + currentUser.Name + "</Value>") .Append("</Eq>") .Append("</Where>"); string strQuery = "<Where><And><And><Eq><FieldRef Name='FFLScheduleName' LookupId='TRUE' /><Value Type='Integer' >" + currentUser.ID + "</Value></Eq><Geq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='FALSE'><Today /></Value></Geq></And><Eq><FieldRef Name='MSAStatus' /><Value Type='Choice'>Not Started</Value></Eq></And></Where>"; //"<Where><Eq><FieldRef Name='FFLScheduleName' LookupId='TRUE' /><Value Type='Integer' >" + currentUser.ID + "</Value></Eq></Where>"; spQuery.Query = strQuery; //sb.ToString(); // <UserID /> SPListItemCollection spListItems = spList.GetItems(spQuery); if (spListItems != null && spListItems.Count > 0) { DataRow dr; string recommendationLink = Utility.GetRedirectUrl("MSAFormLink"); SPFieldUrlValue link; foreach (SPListItem item in spListItems) { dr = dt.NewRow(); string name = Convert.ToString(item["FFLScheduleName"]); if (Convert.ToString(item["FFLArea"]) != null) { string[] areas = Convert.ToString(item["FFLArea"]).Split('#'); if (areas.Length > 1) { dr["AreaAudited"] = areas[1]; } } //dr["AreaAudited"] = item["FFLArea"] != null ? Convert.ToString(item["FFLArea"]) : ""; if (!String.IsNullOrEmpty(Convert.ToString(item["EventDate"]))) { DateTime StartTime; bool bValid = DateTime.TryParse(Convert.ToString(item["EventDate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out StartTime); if (bValid) { dr["StartTime"] = StartTime.ToShortDateString(); } else { dr["StartTime"] = Convert.ToDateTime(StartTime).ToShortDateString(); } } else { dr["StartTime"] = ""; } if (!String.IsNullOrEmpty(Convert.ToString(item["EndDate"]))) { DateTime EndTime; bool bValid = DateTime.TryParse(Convert.ToString(item["EndDate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out EndTime); if (bValid) { dr["EndTime"] = EndTime.ToShortDateString(); } else { dr["EndTime"] = Convert.ToDateTime(EndTime).ToShortDateString(); ; } } else { dr["EndTime"] = ""; } link = new SPFieldUrlValue(Convert.ToString(item["MSAFormLink"])); dr["LinkFileName"] = link.Url; //.Format("{0}?SID=" + item["ID"], recommendationLink); dt.Rows.Add(dr); } BoundField bf = new BoundField(); //RecommendationNo Column bf = new BoundField(); bf.DataField = "AreaAudited"; bf.HeaderText = "Area To Be Audited"; grdMSAScheduled.Columns.Add(bf); bf = new BoundField(); bf.DataField = "StartTime"; bf.HeaderText = "Start Date"; grdMSAScheduled.Columns.Add(bf); bf = new BoundField(); bf.DataField = "EndTime"; bf.HeaderText = "End Date"; grdMSAScheduled.Columns.Add(bf); //bf = new BoundField(); //bf.DataField = "MSADate"; //bf.HeaderText = "MSA Date"; //grdMSATask.Columns.Add(bf); //bf = new BoundField(); //bf.DataField = "AuditedBy"; //bf.HeaderText = "Audited By"; //grdMSATask.Columns.Add(bf); HyperLinkField hyperlinkField = new HyperLinkField(); hyperlinkField.HeaderText = "View MSA"; hyperlinkField.DataNavigateUrlFields = new[] { "LinkFileName" }; hyperlinkField.Text = "View"; grdMSAScheduled.Columns.Add(hyperlinkField); grdMSAScheduled.DataSource = dt; grdMSAScheduled.DataBind(); } } } }); } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL->FillMSASchedule)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace); message_div.InnerHtml = "Something went wrong!!! Please Contact the administrator."; } }
public void queryMakeAndDisplay(string guild, string material, string type, string order) { browseGrid.Columns.Clear(); string aQuery = "SELECT Products.productID, Products.ProductName, Products.ProductDescription, Products.ProductCost, Artisans.ShopName, ProductPhotos.PhotoLocation FROM Products JOIN ProductPhotos ON Products.ProductID = ProductPhotos.ProductID JOIN Artisans ON Products.ArtisanID = Artisans.ArtisanID"; string whereClause = " WHERE "; if (guild != "0") //creates query and binds to grid. { whereClause += "Products.Guild = " + guild; if (type != "0") { whereClause += " AND Products.ProductType = " + type; if (material != "0") { whereClause += " AND Products.Materials = " + material; } } else { if (material != "0") { whereClause += " AND Products.Materials = " + material; } } aQuery += whereClause; } string orderBy = ""; switch (order) { case "0": orderBy = " ORDER BY Products.DateAdded"; break; case "1": orderBy = " ORDER BY Products.DateAdded DESC"; break; case "2": orderBy = " ORDER BY Products.ProductCost"; break; case "3": orderBy = " ORDER BY Products.ProductCost DESC"; break; case "4": orderBy = " ORDER BY Products.ProductName"; break; case "5": orderBy = " ORDER BY Products.ProductName DESC"; break; } aQuery += orderBy; try { SqlConnection aConnection = new SqlConnection(); SqlCommand aCommand = new SqlCommand(); string aConnectionString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True"; DataSet aDataSet = new DataSet(); SqlDataAdapter aDataAdapter = new SqlDataAdapter(); aConnection.ConnectionString = aConnectionString; aCommand = new SqlCommand(aQuery, aConnection); aDataAdapter.SelectCommand = aCommand; aDataAdapter.SelectCommand.Connection.Open(); aDataAdapter.Fill(aDataSet, "Results"); browseGrid.DataSource = aDataSet.Tables["Results"]; // Create an ImageField object to display a photo. ImageField photoImageField = new ImageField(); photoImageField.DataImageUrlField = "PhotoLocation";//the name of the column in the database photoImageField.AlternateText = "Product Photos"; photoImageField.NullDisplayText = "No image on file."; photoImageField.ControlStyle.Height = 120; photoImageField.HeaderText = "Product Photos"; photoImageField.ReadOnly = true; // Create a BoundField object to display text. BoundField productDescriptionField = new BoundField(); productDescriptionField.DataField = "ProductDescription"; productDescriptionField.NullDisplayText = "No description."; productDescriptionField.HeaderText = "Description"; browseGrid.DataSource = aDataSet.Tables["Results"]; BoundField costField = new BoundField(); costField.DataField = "ProductCost"; costField.NullDisplayText = "Price Unknown"; costField.DataFormatString = "{0:C0}"; costField.HeaderText = "Price"; browseGrid.DataSource = aDataSet.Tables["Results"]; // Create an HyperlinkField object to redirect to a page. HyperLinkField productHyperLinkField = new HyperLinkField(); productHyperLinkField.DataTextField = "ProductName"; productHyperLinkField.DataNavigateUrlFields = new string[] { "productID" }; productHyperLinkField.DataNavigateUrlFormatString = "ProductProfile.aspx?id={0}";//the name of the profile page to go to for example productHyperLinkField.HeaderText = "Product Name"; browseGrid.DataSource = aDataSet.Tables["Results"]; HyperLinkField artisanHyperLinkField = new HyperLinkField(); artisanHyperLinkField.DataTextField = "ShopName"; artisanHyperLinkField.DataNavigateUrlFields = new string[] { "productID" }; artisanHyperLinkField.DataNavigateUrlFormatString = "Storefront.aspx?id={0}"; artisanHyperLinkField.NavigateUrl = "#";//the name of the profile page to go to for example artisanHyperLinkField.HeaderText = "Artisan"; browseGrid.DataSource = aDataSet.Tables["Results"]; // Add the field columns to the Fields collection of the // GridView control. browseGrid.Columns.Add(photoImageField); browseGrid.Columns.Add(costField); browseGrid.Columns.Add(productDescriptionField); browseGrid.Columns.Add(artisanHyperLinkField); browseGrid.Columns.Add(productHyperLinkField); browseGrid.DataBind(); aConnection.Close(); browseGrid.AllowPaging = true; } catch (SqlException) { } }
public void HyperLinkField_CopyProperty () { PokerHyperLinkField field = new PokerHyperLinkField (); HyperLinkField copy = new HyperLinkField (); field.DataNavigateUrlFields = new string[] { "test1", "test2" }; field.DataNavigateUrlFormatString = "test"; field.DataTextField = "test"; field.DataTextFormatString = "test"; field.NavigateUrl = "test"; field.Target = "test"; field.Text = "test"; field.DoCopyProperties (copy); Assert.AreEqual (2, ((Array) copy.DataNavigateUrlFields).Length, "DataNavigateUrlFieldsCount"); Assert.AreEqual ("test1", copy.DataNavigateUrlFields[0], "DataNavigateUrlFields#1"); Assert.AreEqual ("test2", copy.DataNavigateUrlFields[1], "DataNavigateUrlFields#2"); Assert.AreEqual ("test", copy.DataNavigateUrlFormatString, "DataNavigateUrlFormatString "); Assert.AreEqual ("test", copy.DataTextField, "DataTextField"); Assert.AreEqual ("test", copy.DataTextFormatString, "DataTextFormatString"); Assert.AreEqual ("test", copy.NavigateUrl, "NavigateUrl"); Assert.AreEqual ("test", copy.Target, "Target"); Assert.AreEqual ("test", copy.Text, "Text"); }
protected override DataControlField SaveValues(string headerText) { HyperLinkField field = new HyperLinkField { HeaderText = headerText }; if (this._staticTextRadio.Checked) { field.Text = this._textBox.Text; } else { field.DataTextFormatString = this._textFSBox.Text; if (base._haveSchema) { field.DataTextField = this._dataTextFieldList.Text; } else { field.DataTextField = this._dataTextFieldBox.Text; } } if (this._staticUrlRadio.Checked) { field.NavigateUrl = this._linkBox.Text; return field; } field.DataNavigateUrlFormatString = this._dataNavFSBox.Text; if (base._haveSchema) { field.DataNavigateUrlFields = new string[] { this._dataNavFieldList.Text }; return field; } field.DataNavigateUrlFields = new string[] { this._dataNavFieldBox.Text }; return field; }
//creates grid, creates columns, binds columns. private void query() { searchGrid.Columns.Clear(); string searchItem = searchTB.Text; DataSet aDataSet = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); aConnection.ConnectionString = aConnectionString; aCommand = new SqlCommand(); if (advancedSearch.Checked == false) { //Basic search. aCommand = basicQuery(searchItem); aCommand.CommandText += " ORDER BY Products.ProductName"; aCommand.Connection = aConnection; } else { string shopTerm = artisanSearchTB.Text; aCommand = advancedQuery(searchItem, shopTerm, guildDrop.SelectedValue, typesDrop.SelectedValue, materialsDrop.SelectedValue, lowPriceRange.Text, highPriceRange.Text, locationDrop.SelectedValue, orderByDrop.SelectedValue); aCommand.Connection = aConnection; } // Create an ImageField object to display a photo. ImageField photoImageField = new ImageField(); photoImageField.DataImageUrlField = "PhotoLocation";//the name of the column in the database photoImageField.AlternateText = "Product Photos"; photoImageField.NullDisplayText = "No image on file."; photoImageField.ControlStyle.Height = 120; photoImageField.HeaderText = "Product Photos"; photoImageField.ReadOnly = true; // Create a BoundField object to display text. BoundField productDescriptionField = new BoundField(); productDescriptionField.DataField = "ProductDescription"; productDescriptionField.NullDisplayText = "No description."; productDescriptionField.HeaderText = "Description"; searchGrid.DataSource = aDataSet.Tables["Results"]; BoundField costField = new BoundField(); costField.DataField = "ProductCost"; costField.DataFormatString = "{0:C0}"; costField.NullDisplayText = "Price Unknown"; costField.HeaderText = "Price"; searchGrid.DataSource = aDataSet.Tables["Results"]; // Create an HyperlinkField object to redirect to a page. HyperLinkField productHyperLinkField = new HyperLinkField(); productHyperLinkField.DataTextField = "ProductName"; productHyperLinkField.DataNavigateUrlFields = new string[] { "ProductID" }; productHyperLinkField.DataNavigateUrlFormatString = "ProductProfile.aspx?id={0}"; //the name of the profile page to go to for example productHyperLinkField.HeaderText = "Product Name"; searchGrid.DataSource = aDataSet.Tables["Results"]; HyperLinkField artisanHyperLinkField = new HyperLinkField(); artisanHyperLinkField.DataTextField = "ShopName"; artisanHyperLinkField.DataNavigateUrlFields = new string[] { "ProductID" };//the name of the profile page to go to for example artisanHyperLinkField.DataNavigateUrlFormatString = "Storefront.aspx?id={0}"; artisanHyperLinkField.HeaderText = "Artisan"; searchGrid.DataSource = aDataSet.Tables["Results"]; // Add the field columns to the Fields collection of the // GridView control. searchGrid.Columns.Add(photoImageField); searchGrid.Columns.Add(costField); searchGrid.Columns.Add(productDescriptionField); searchGrid.Columns.Add(artisanHyperLinkField); searchGrid.Columns.Add(productHyperLinkField); try { da.SelectCommand = aCommand; da.SelectCommand.Connection.Open(); //if the user enters " " or something like " John " they will recieve as a reply to their query every item. da.Fill(aDataSet, "Results"); searchGrid.DataSource = aDataSet.Tables["Results"]; searchGrid.DataBind(); aConnection.Close(); } catch (SqlException) { } }
public void HyperLinkField_DefaultProperty () { HyperLinkField field = new HyperLinkField (); Assert.AreEqual (0, ((Array) field.DataNavigateUrlFields).Length, "DataNavigateUrlFields"); Assert.AreEqual ("", field.DataNavigateUrlFormatString, "DataNavigateUrlFormatString"); Assert.AreEqual ("", field.DataTextField, "DataTextField"); Assert.AreEqual ("", field.DataTextFormatString, "DataTextFormatString"); Assert.AreEqual ("", field.NavigateUrl, "NavigateUrl"); Assert.AreEqual ("", field.Target, "Target"); Assert.AreEqual ("", field.Text, "Text"); }
/// <summary> /// Se agregan las columnas iniciales del calendario en este caso los /// días de la semana /// </summary> protected void crearColumnasIniciales() { HyperLinkField columnaActividad = new HyperLinkField(); columnaActividad.DataTextField = "Actividad"; columnaActividad.HeaderText = cld_resources.ResourceManager.GetString("Actividad"); BoundField columnaLunes = new BoundField(); columnaLunes.DataField = "Lunes"; columnaLunes.HeaderText = cld_resources.ResourceManager.GetString("Lunes"); BoundField columnaMartes = new BoundField(); columnaMartes.DataField = "Lunes"; columnaMartes.HeaderText = cld_resources.ResourceManager.GetString("Martes"); BoundField columnaMiercoles = new BoundField(); columnaMiercoles.DataField = "Lunes"; columnaMiercoles.HeaderText = cld_resources.ResourceManager.GetString("Miercoles"); BoundField columnaJueves = new BoundField(); columnaJueves.DataField = "Lunes"; columnaJueves.HeaderText = cld_resources.ResourceManager.GetString("Jueves"); BoundField columnaViernes = new BoundField(); columnaViernes.DataField = "Lunes"; columnaViernes.HeaderText = cld_resources.ResourceManager.GetString("Viernes"); BoundField columnaSabado = new BoundField(); columnaSabado.DataField = "Lunes"; columnaSabado.HeaderText = cld_resources.ResourceManager.GetString("Sabado"); BoundField columnaDomingo = new BoundField(); columnaDomingo.DataField = "Lunes"; columnaDomingo.HeaderText = cld_resources.ResourceManager.GetString("Domingo"); this.grvCalendario.Columns.Add(columnaActividad); this.grvCalendario.Columns.Add(columnaLunes); this.grvCalendario.Columns.Add(columnaMartes); this.grvCalendario.Columns.Add(columnaMiercoles); this.grvCalendario.Columns.Add(columnaJueves); this.grvCalendario.Columns.Add(columnaViernes); this.grvCalendario.Columns.Add(columnaSabado); this.grvCalendario.Columns.Add(columnaDomingo); ArrayList lista = new ArrayList(); lista.Add(new clsAsignacion("valor",1)); lista.Add(new clsAsignacion("valor", 1)); lista.Add(new clsAsignacion("valor", 1)); lista.Add(new clsAsignacion("valor", 1)); lista.Add(new clsAsignacion("valor", 1)); lista.Add(new clsAsignacion("valor", 1)); this.grvCalendario.DataSource = lista; this.grvCalendario.DataBind(); //Se agregan las columnas a la lista de columnas this.columnas.Add(columnaActividad); this.columnas.Add(columnaLunes); this.columnas.Add(columnaMartes); this.columnas.Add(columnaMiercoles); this.columnas.Add(columnaJueves); this.columnas.Add(columnaViernes); this.columnas.Add(columnaSabado); this.columnas.Add(columnaDomingo); }
public void HyperLinkField_InitializeCell () { HyperLinkField field = new HyperLinkField (); DataControlFieldCell cell = new DataControlFieldCell (null); field.Text = "Text"; field.NavigateUrl = "NavigateUrl"; field.Target = "Target"; field.InitializeCell (cell, DataControlCellType.DataCell, DataControlRowState.Normal, 0); Assert.AreEqual(1,cell.Controls.Count , "CellControlsCountAfterCreation"); if (cell.Controls[0] is HyperLink) { Assert.AreEqual ("Text", ((HyperLink) cell.Controls[0]).Text, "HyperLinkText"); Assert.AreEqual ("NavigateUrl", ((HyperLink) cell.Controls[0]).NavigateUrl, "HyperLinkNavigateUrl"); Assert.AreEqual ("Target", ((HyperLink) cell.Controls[0]).Target, "Target"); } else Assert.Fail ("HyperLink was not been created"); }
public static void AddGridListColumn(GridView gv, DataTable ColItem, string LangID) { string fieldname = string.Empty; string str2 = string.Empty; string str3 = string.Empty; foreach (DataRow row in ColItem.Rows) { BoundField field3; if (!Convert.ToBoolean(row["IsVisible"])) { continue; } fieldname = row["ColName"].ToString( ); str3 = row["ColDataType"].ToString( ).ToLower( ); str2 = row["ColCaption_Cn"].ToString( ); switch (str3) { case "datetime": case "smalldatetime": { TemplateField field = new TemplateField { SortExpression = fieldname }; field.ItemStyle.Wrap = false; field.HeaderStyle.Wrap = false; //field.ItemTemplate = new iDateColumnTemplate(fieldname); field.HeaderText = str2; gv.Columns.Add(field); continue; } default: { if (row["Link_Str"].ToString( ).Trim( ) != string.Empty) { HyperLinkField field2 = new HyperLinkField { HeaderText = str2, DataNavigateUrlFormatString = row["Link_Str"].ToString( ), DataNavigateUrlFields = row["Link_Field"].ToString( ).Split(new char[] { ',' }), SortExpression = fieldname, DataTextField = fieldname }; field2.HeaderStyle.Wrap = false; field2.ItemStyle.Wrap = false; gv.Columns.Add(field2); continue; } field3 = new BoundField { HeaderText = str2, DataField = fieldname, SortExpression = fieldname }; field3.HeaderStyle.Wrap = false; field3.ItemStyle.Wrap = false; int num = Utilities.ToInt(row["ColWidth"]); field3.ItemStyle.Width = new Unit((num > 40) ? num : 40); string str4 = str3; if (str4 != null) { if (!(str4 == "money")) { if (str4 == "numeric") { break; } if (str4 == "int") { goto Label_02E6; } } else { field3.DataFormatString = "{0:c" + DIGITS_Sum.ToString( ) + "}"; field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right; } } goto Label_02F3; } } field3.DataFormatString = "{0:f" + DIGITS_Qty.ToString( ) + "}"; field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right; goto Label_02F3; Label_02E6: field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right; Label_02F3: gv.Columns.Add(field3); } }
public static void RenderingHyperLinkField (Page p) { LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG); LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG); GridView grid = new GridView (); grid.AutoGenerateColumns = false; grid.ShowFooter = true; p.Form.Controls.Add (lcb); p.Form.Controls.Add (grid); p.Form.Controls.Add (lce); HyperLinkField hyperlinkfield = new HyperLinkField (); hyperlinkfield.DataTextField = STRINGFIELD; string[] str = new string[] { STRINGFIELD }; hyperlinkfield.DataNavigateUrlFields = str; hyperlinkfield.HeaderText = "HeaderText"; hyperlinkfield.FooterText = "FooterText"; grid.DataSource = GridViewTest.CreateDataSource (); grid.Columns.Add (hyperlinkfield); grid.DataBind (); }
public static void InsertGridListColumn(GridView gv, int SeqNo, DataTable ColItem, string LangID, bool IsFixWidth) { gv.Attributes.Add("style ", "table-layout:fixed "); int num = 100; string fieldname = string.Empty; string str2 = string.Empty; string str3 = string.Empty; foreach (DataRow row in ColItem.Rows) { TemplateField field; BoundField field3; if (Convert.ToBoolean(row["IsVisible"])) { fieldname = row["ColName"].ToString( ); num = Utilities.ToInt(row["ColWidth"]); str3 = row["ColDataType"].ToString( ).ToLower( ); str2 = row["ColCaption_Cn"].ToString( ); switch (str3) { case "datetime": case "smalldatetime": { field = new TemplateField { SortExpression = fieldname, //ItemTemplate = new iDateColumnTemplate(fieldname), HeaderText = str2 }; field.HeaderStyle.Width = new Unit(num); field.ItemStyle.Width = new Unit(num); gv.Columns.Insert(SeqNo, field); continue; } } if (row["Link_Str"].ToString( ).Trim( ) != string.Empty) { HyperLinkField field2 = new HyperLinkField { HeaderText = str2, DataNavigateUrlFormatString = row["Link_Str"].ToString( ), DataNavigateUrlFields = row["Link_Field"].ToString( ).Split(new char[] { ',' }), SortExpression = fieldname, DataTextField = fieldname }; field2.HeaderStyle.Width = new Unit(num); field2.ItemStyle.Width = new Unit(num); gv.Columns.Insert(SeqNo, field2); } else { string str4 = str3; if (str4 == null) { goto Label_03EA; } if (!(str4 == "money")) { if (str4 == "numeric") { goto Label_02FB; } if (str4 == "int") { goto Label_038B; } goto Label_03EA; } field3 = new BoundField { HeaderText = str2, DataField = fieldname, SortExpression = fieldname }; field3.ItemStyle.Wrap = false; field3.DataFormatString = "{0:c" + DIGITS_Sum.ToString( ) + "}"; field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right; field3.HeaderStyle.Width = new Unit(num); field3.ItemStyle.Width = new Unit(num); gv.Columns.Insert(SeqNo, field3); } } continue; Label_02FB: field3 = new BoundField( ); field3.HeaderText = str2; field3.DataField = fieldname; field3.SortExpression = fieldname; field3.ItemStyle.Wrap = false; field3.DataFormatString = "{0:f" + DIGITS_Qty.ToString( ) + "}"; field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right; field3.HeaderStyle.Width = new Unit(num); field3.ItemStyle.Width = new Unit(num); gv.Columns.Insert(SeqNo, field3); continue; Label_038B: field3 = new BoundField( ); field3.HeaderText = str2; field3.DataField = fieldname; field3.SortExpression = fieldname; field3.ItemStyle.Wrap = false; field3.HeaderStyle.Width = new Unit(num); field3.ItemStyle.Width = new Unit(num); field3.ItemStyle.HorizontalAlign = HorizontalAlign.Right; continue; Label_03EA: field = new TemplateField( ); field.SortExpression = fieldname; field.HeaderStyle.Width = new Unit(num); field.ItemStyle.Width = new Unit(num); //field.ItemTemplate = new iTextColumnTemplate(fieldname, num); field.HeaderText = str2; gv.Columns.Insert(SeqNo, field); } }
protected override void OnInit(EventArgs e) { base.OnInit(e); var sf = new SelectionField(); sf.ItemStyle.CssClass = "GridViewIcon"; InternalGridView.Columns.Add(sf); var nf = new System.Web.UI.WebControls.BoundField(); nf.DataField = "Number"; nf.ItemStyle.CssClass = "GridViewIcon"; InternalGridView.Columns.Add(nf); var imgf = new ImageField(); imgf.DataImageUrlField = "EntityType"; imgf.DataImageUrlFormatString = "~/Icons/Small/{0}.gif"; imgf.ItemStyle.CssClass = "GridViewIcon"; InternalGridView.Columns.Add(imgf); var namefield = new HyperLinkField(); namefield.HeaderText = "Name"; namefield.DataTextField = "Name"; namefield.ItemStyle.CssClass = "GridViewSpan"; namefield.DataNavigateUrlFields = new[] { "EntityType", "Guid" }; namefield.DataNavigateUrlFormatString = "~/" + entityGroup.ToString() + "/{0}Details.aspx?guid={1}"; InternalGridView.Columns.Add(namefield); foreach (DataControlField col in columns) { InternalGridView.Columns.Add(col); } }
public HyperLinkFieldItem(DataControlFieldsEditor fieldsEditor, HyperLinkField runtimeField) : base(fieldsEditor, runtimeField, 8) { }
/// <summary> /// The load grid view. /// </summary> protected void LoadGridView() { var nameColumn = new HyperLinkField(); nameColumn.DataTextField = "Name"; nameColumn.HeaderText = "Naam"; nameColumn.Target = "_blank"; nameColumn.DataNavigateUrlFormatString = this.Request.Url.AbsolutePath + "?page=Product&product={0}"; nameColumn.DataNavigateUrlFields = new[] { "Id" }; var amountColumn = new BoundField(); amountColumn.DataField = "Amount"; amountColumn.HeaderText = "Aantal"; var decreaseColumn = new ButtonField(); decreaseColumn.Text = "-"; decreaseColumn.CommandName = "Decrease"; var increaseColumn = new ButtonField(); increaseColumn.Text = "+"; increaseColumn.CommandName = "Increase"; var priceColumn = new BoundField(); priceColumn.DataField = "Price"; priceColumn.HeaderText = "Prijs"; priceColumn.DataFormatString = "{0:C}"; priceColumn.FooterText = "<strong>Totaal</strong>"; var totalColumn = new BoundField(); totalColumn.DataField = "Total"; totalColumn.HeaderText = "Totaal"; totalColumn.DataFormatString = "{0:C}"; totalColumn.FooterText = this.Products.Sum(x => x.Total).ToString("C"); this.GridViewCart.Columns.Clear(); this.GridViewCart.Columns.Add(nameColumn); this.GridViewCart.Columns.Add(amountColumn); this.GridViewCart.Columns.Add(decreaseColumn); this.GridViewCart.Columns.Add(increaseColumn); this.GridViewCart.Columns.Add(priceColumn); this.GridViewCart.Columns.Add(totalColumn); this.GridViewCart.DataSource = this.Products; this.GridViewCart.DataBind(); }
private void FillMSAWorkQueue(SPWeb oSPWeb_, SPUser currentUser) { try { SPSecurity.RunWithElevatedPrivileges(delegate() { using (SPSite oSPsite = new SPSite(SPContext.Current.Web.Url)) { using (SPWeb oSPWeb_EP = oSPsite.OpenWeb()) { string getName = string.Empty; DataTable dt = new DataTable(); dt.Columns.Add("AreaAudited", typeof(string)); dt.Columns.Add("StartTime", typeof(string)); dt.Columns.Add("MSADate", typeof(string)); dt.Columns.Add("EndTime", typeof(string)); dt.Columns.Add("AuditedBy", typeof(string)); dt.Columns.Add("LinkFileName", typeof(string)); string listName = "MSA"; // Fetch the List SPList splistMSARecommendation = oSPWeb_EP.GetList(string.Format("{0}/Lists/{1}/AllItems.aspx", oSPWeb_EP.Url, listName)); SPQuery query = new SPQuery(); SPListItemCollection spListItems; // Include only the fields you will use. string vf = "<FieldRef Name='ID' /><FieldRef Name='Author' /><FieldRef Name='MSADate' /><FieldRef Name='AuditedBy' /><FieldRef Name='AreaAudited' /><FieldRef Name='AccompaniedBy' /><FieldRef Name='StartTime' /><FieldRef Name='EndTime' />"; query.ViewFields = vf; query.ViewFieldsOnly = true; StringBuilder sb = new StringBuilder(); sb.Append("<Where>") .Append("<And>") .Append("<Eq>") .Append("<FieldRef Name='IsSavedAsDraft' />") .Append("<Value Type='Boolean'>1</Value>") .Append("</Eq>") .Append("<Eq>") .Append("<FieldRef Name='Author' />") .Append("<Value Type='User'>" + currentUser.Name + "</Value>") .Append("</Eq>") .Append("</And>") .Append("</Where>"); query.Query = sb.ToString(); spListItems = splistMSARecommendation.GetItems(query); DataRow dr; if (spListItems != null && spListItems.Count > 0) { foreach (SPListItem item in spListItems) { dr = dt.NewRow(); SPUser author = null; if (item["Author"] != null) { string authorStr = Convert.ToString(item["Author"]); var temp = authorStr.Split('#'); if (temp.Length > 1) { temp = temp[0].Split(';'); if (temp.Length > 1) { author = Utility.GetUser(oSPWeb_EP, null, null, Int32.Parse(temp[0])); } } } dr["AreaAudited"] = item["AreaAudited"] != null ? Convert.ToString(item["AreaAudited"]) : ""; dr["StartTime"] = item["StartTime"] != null ? Convert.ToString(item["StartTime"]) : ""; dr["EndTime"] = item["EndTime"] != null ? Convert.ToString(item["EndTime"]) : ""; string auditedBy = item["AuditedBy"] != null ? Convert.ToString(item["AuditedBy"]) : ""; if (!String.IsNullOrEmpty(auditedBy)) { SPUser auditedByUser = Utility.GetUser(oSPWeb_EP, auditedBy); if (auditedByUser != null) { dr["AuditedBy"] = auditedByUser.Name; } } DateTime date; bool bValid = DateTime.TryParse(Convert.ToString(item["MSADate"]), new CultureInfo("en-GB"), DateTimeStyles.AssumeLocal, out date); if (bValid) { dr["MSADate"] = date.ToShortDateString(); } else { try { dr["MSADate"] = Convert.ToDateTime(Convert.ToString(item["MSADate"])).ToShortDateString(); } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("WQ-MSAD:" + Convert.ToString(item["MSADate"]), TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace); } } string recommendationLink = Utility.GetRedirectUrl("MSAFormLink"); dr["LinkFileName"] = string.Format("{0}?MSAID=" + item["ID"], recommendationLink); if (author != null && Utility.CompareUsername(author.LoginName, currentUser.LoginName)) { dt.Rows.Add(dr); } } } BoundField bf = new BoundField(); //RecommendationNo Column bf = new BoundField(); bf.DataField = "AreaAudited"; bf.HeaderText = "Area Audited"; grdMSATask.Columns.Add(bf); bf = new BoundField(); bf.DataField = "StartTime"; bf.HeaderText = "Start Time"; grdMSATask.Columns.Add(bf); bf = new BoundField(); bf.DataField = "EndTime"; bf.HeaderText = "End Time"; grdMSATask.Columns.Add(bf); bf = new BoundField(); bf.DataField = "MSADate"; bf.HeaderText = "MSA Date"; grdMSATask.Columns.Add(bf); bf = new BoundField(); bf.DataField = "AuditedBy"; bf.HeaderText = "Audited By"; grdMSATask.Columns.Add(bf); HyperLinkField hyperlinkField = new HyperLinkField(); hyperlinkField.HeaderText = "View MSA"; hyperlinkField.DataNavigateUrlFields = new[] { "LinkFileName" }; hyperlinkField.Text = "View"; grdMSATask.Columns.Add(hyperlinkField); grdMSATask.DataSource = dt; grdMSATask.DataBind(); } } }); } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL(WorkQueue->FillMSAWorkQueue)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace); message_div.InnerHtml = "Something went wrong!!! Please Contact the administrator."; } }