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