public void ImageField_AssignProperty () { ImageField field = new ImageField (); field.AlternateText = "test"; Assert.AreEqual ("test", field.AlternateText, "AlternateText "); field.ConvertEmptyStringToNull = false; Assert.AreEqual (false, field.ConvertEmptyStringToNull, "ConvertEmptyStringToNull"); field.DataAlternateTextField = "test"; Assert.AreEqual ("test", field.DataAlternateTextField, "DataAlternateTextField"); field.DataImageUrlField = "test"; Assert.AreEqual ("test", field.DataImageUrlField, "DataImageUrlField"); field.DataImageUrlFormatString = "test"; Assert.AreEqual ("test", field.DataImageUrlFormatString, "DataImageUrlFormatString"); field.NullDisplayText = "test"; Assert.AreEqual ("test", field.NullDisplayText, "NullDisplayText"); field.NullImageUrl = "test"; Assert.AreEqual ("test", field.NullImageUrl, "NullImageUrl"); field.ReadOnly = true; Assert.AreEqual (true, field.ReadOnly, "ReadOnly"); }
public void ImageField_CopyProperties () { PokerImageField field = new PokerImageField (); ImageField copy = new ImageField (); field.AlternateText = "test"; field.ConvertEmptyStringToNull = true; field.DataAlternateTextField = "test"; field.DataAlternateTextFormatString = "test"; field.DataImageUrlField = "test"; field.DataImageUrlFormatString = "test"; field.NullDisplayText = "test"; field.NullImageUrl = "test"; field.ReadOnly = true; field.DoCopyProperties (copy); Assert.AreEqual ("test", copy.AlternateText, "AlternateText"); Assert.AreEqual (true, copy.ConvertEmptyStringToNull, "ConvertEmptyStringToNull"); Assert.AreEqual ("test", copy.DataAlternateTextField, "DataAlternateTextField"); Assert.AreEqual ("test", copy.DataImageUrlField, "DataImageUrlField"); Assert.AreEqual ("test", copy.DataAlternateTextFormatString, "DataAlternateTextFormatString"); Assert.AreEqual ("test", copy.DataImageUrlField, "DataImageUrlField"); Assert.AreEqual ("test", copy.DataImageUrlFormatString, "DataImageUrlFormatString"); Assert.AreEqual ("test", copy.NullDisplayText, "NullDisplayText"); Assert.AreEqual ("test", copy.NullImageUrl, "NullImageUrl"); Assert.AreEqual (true, copy.ReadOnly, "ReadOnly"); }
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 void ImageField_DefaultProperty () { ImageField field = new ImageField (); Assert.AreEqual ("!", ImageField.ThisExpression, "ThisExpression"); Assert.AreEqual ("", field.AlternateText, "AlternateText "); Assert.AreEqual (true, field.ConvertEmptyStringToNull, "ConvertEmptyStringToNull"); Assert.AreEqual ("", field.DataAlternateTextField, "DataAlternateTextField"); Assert.AreEqual ("", field.DataImageUrlField, "DataImageUrlField"); Assert.AreEqual ("", field.DataImageUrlFormatString, "DataImageUrlFormatString"); Assert.AreEqual ("", field.NullDisplayText, "NullDisplayText"); Assert.AreEqual ("", field.NullImageUrl, "NullImageUrl"); Assert.AreEqual (false, field.ReadOnly, "ReadOnly"); }
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; }
public static void RenderingImageField (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); ImageField imagefield = new ImageField (); imagefield.HeaderText = "HeaderText"; imagefield.FooterText = "FooterText"; imagefield.DataImageUrlField = STRINGFIELD; imagefield.DataAlternateTextField = STRINGFIELD; grid.DataSource = GridViewTest.CreateDataSource (); grid.Columns.Add (imagefield); grid.DataBind (); }
public override DataControlFieldsEditor.FieldItem CreateField() { ImageField runtimeField = new ImageField(); DataControlFieldsEditor.FieldItem item = new DataControlFieldsEditor.ImageFieldItem(this._fieldsEditor, runtimeField); item.LoadFieldInfo(); return item; }
private void AddDataboundControls(Control parent) { SqlDataSource ds = new SqlDataSource(); ds.ID = "ProductsSqlDataSource"; ds.ConnectionString = ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString"].ConnectionString; ds.SelectCommand = "SELECT Production.ProductDescription.Description, Production.Product.Name, Production.ProductPhoto.ThumbnailPhotoFileName, " + "Production.Product.ProductID " + "FROM Production.Product INNER JOIN " + "Production.ProductProductPhoto ON Production.Product.ProductID = Production.ProductProductPhoto.ProductID INNER JOIN " + "Production.ProductPhoto ON Production.ProductProductPhoto.ProductPhotoID = Production.ProductPhoto.ProductPhotoID INNER JOIN " + "Production.ProductModelProductDescriptionCulture ON " + "Production.Product.ProductModelID = Production.ProductModelProductDescriptionCulture.ProductModelID INNER JOIN " + "Production.ProductDescription ON " + "Production.ProductModelProductDescriptionCulture.ProductDescriptionID = Production.ProductDescription.ProductDescriptionID"; GridView gv = new GridView(); gv.ID = "ProductsGridView"; gv.DataSourceID = ds.ID; gv.AutoGenerateColumns = false; gv.DataKeyNames = new string[] { "ProductID" }; gv.GridLines = GridLines.None; gv.HeaderStyle.BackColor = Color.LightGray; gv.AlternatingRowStyle.BackColor = Color.LightBlue; gv.AllowPaging = true; gv.PageSize = _pageSize; gv.RowCommand += this.GridView_RowCommand; ImageField if1 = new ImageField(); if1.HeaderText = "Product"; if1.DataImageUrlField = "ThumbnailPhotoFileName"; if1.DataImageUrlFormatString = @"..\images\thumbnails\{0}"; BoundField bf1 = new BoundField(); bf1.HeaderText = "Name"; bf1.DataField = "Name"; BoundField bf2 = new BoundField(); bf2.HeaderText = "Description"; bf2.DataField = "Description"; ButtonField btf1 = new ButtonField(); btf1.Text = "Add"; btf1.CommandName = "AddToCart"; ButtonField btf2 = new ButtonField(); btf2.Text = "Remove"; btf2.CommandName = "RemoveFromCart"; gv.Columns.Add(if1); gv.Columns.Add(bf1); gv.Columns.Add(bf2); gv.Columns.Add(btf1); gv.Columns.Add(btf2); parent.Controls.Add(new LiteralControl("<br />")); parent.Controls.Add(gv); parent.Controls.Add(new LiteralControl("<br />")); parent.Controls.Add(ds); }
protected override DataControlField SaveValues(string headerText) { ImageField field = new ImageField { HeaderText = headerText }; if (base._haveSchema) { field.DataImageUrlField = this._imageUrlFieldList.Text; } else { field.DataImageUrlField = this._imageUrlFieldBox.Text; } field.ReadOnly = this._readOnlyCheckBox.Checked; field.DataImageUrlFormatString = this._urlFormatBox.Text; return field; }
public ImageFieldItem(DataControlFieldsEditor fieldsEditor, ImageField runtimeField) : base(fieldsEditor, runtimeField, 14) { }
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 FillGridView(string p, bool reloadFile) { if (Unified == null || reloadFile) Unified = new ResXUnified(p); gridView.Columns.Clear(); SortedList<string, string> langs = Unified.GetLanguages(); Unit columnSize = new Unit(Math.Round((gridView.Width.Value) / (langs.Values.Count)), UnitType.Percentage); ImageField keyColumn = new ImageField(); keyColumn.HeaderText = "Key"; keyColumn.DataAlternateTextField = "Key"; keyColumn.DataImageUrlField = "Key"; keyColumn.DataImageUrlFormatString = "~/App_Themes/" + Page.Theme + "/images/information.png"; // ignore key //keyColumn.DataField = "Key"; //keyColumn.ItemStyle.BackColor = Color.Gray; //keyColumn.ItemStyle.ForeColor = Color.White; keyColumn.ReadOnly = true; keyColumn.ItemStyle.Width = new Unit(30); keyColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Left; keyColumn.ControlStyle.Width = new Unit(16, UnitType.Pixel); gridView.Columns.Add(keyColumn); foreach (string lang in langs.Values) { CultureInfo culture = null; try { culture = new CultureInfo(lang); } catch { } BoundField field = new BoundField { HeaderText = culture != null ? culture.DisplayName : @"Default", DataField = lang, ReadOnly = (culture == null) && !Roles.IsUserInRole("Administrator") }; field.ControlStyle.Width = new Unit(99,UnitType.Percentage); if (culture != null) { if (culture.TextInfo.IsRightToLeft) { field.ItemStyle.HorizontalAlign = HorizontalAlign.Right; field.ControlStyle.CssClass = "rtl"; } } if (lang == "Default") gridView.Columns.Insert(1,field); else if (culture.TwoLetterISOLanguageName.ToLower() == currEditLang.ToLower()) { currCultureName = culture.TextInfo.CultureName; gridView.Columns.Add(field); } } if (gridView.Columns.Count < 3 && !String.IsNullOrEmpty(currEditLang)) { try { if (!String.IsNullOrEmpty(currCultureName)) ddLanguage.SelectedValue = currCultureName; } catch (Exception) { //don't throw an error if it doesn't exist in the list } pnlAddLang.Visible = true; } else { pnlAddLang.Visible = false; } gridView.DataSource = Unified.ToDataTable(true); gridView.DataBind(); }
//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 static void _ImageFieldInit (Page p) { // This also tested DataAlternateTextField LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG); LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG); GridView grid = new GridView(); grid.AutoGenerateColumns = false; grid.ID = "Grid"; grid.DataSource = CreateDataSource (DatatableType.stringDS); ImageField field = new ImageField(); field.DataImageUrlField = "Field"; field.DataAlternateTextField = "Field"; field.DataAlternateTextFormatString = "Item: {0}"; field.ReadOnly = true; field.HeaderText = "Data" ; grid.Columns.Add (field); p.Form.Controls.Add (lcb); p.Form.Controls.Add (grid); p.Form.Controls.Add (lce); grid.DataBind (); }
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 static void _ConvertEmptyStringToNull (Page p) { LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG); LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG); GridView grid = new GridView (); grid.DataSource = CreateDataSource (DatatableType.emptyDS); ImageField field = new ImageField (); field.NullDisplayText = "NullDisplayText"; field.DataImageUrlField = "Field"; field.ConvertEmptyStringToNull = false; field.ReadOnly = true; field.HeaderText = "Data"; grid.Columns.Add (field); p.Form.Controls.Add (lcb); p.Form.Controls.Add (grid); p.Form.Controls.Add (lce); grid.DataBind (); }
static private ImageField CreateImageField(string apanUrlNavigateVar, string apanUrl) { ImageField lcImageField = new ImageField(); lcImageField.DataImageUrlField = apanUrlNavigateVar; lcImageField.DataImageUrlFormatString = apanUrl; return lcImageField; }