Products Datalist And Page Data To Display In A New Page?
Feb 23, 2010
I wanted to know peoples thoughts on ways of achieving the following:
1.I have a products page which is in a datalist.When i click the page how can i get the page data to display in a new page with all product details so customers can see everything about the product
2.Also i currently have an upload facility which allows admin users to upload products with descriptions and other info.But i have to add a colours option.My problem is how can i store this information for the product as there may be several colours available for the product.Would i have to create fields for different colours in the products table?
also how could i attach images for each colours when selected from dropdown? e.g when customer selects blue colour it will display the image attached to the blue product?
View 3 Replies
Similar Messages:
May 10, 2010
I am developing a website that display products and the users will be able to rate these products. At the end of the month a winner product will be highlighted on the website home page. What I need to know is how to determine the winner product if I have the following rating scenario, The user will rate for the product by choosing a value from 1 to 5 where 1 mean bad and 5 excellent.
If 10 users voted for the product A and the average rating was 4 and 1 user voted for product B and the average rating were 5 that mean product B will be the winner. I feel this is not the correct method to determine the winner. one has better method that take in consideration the number of voted users to determine the winner?
View 3 Replies
May 16, 2012
this is my last thread
[URL]
this is my code
<li><a href="Furniture.aspx?h_name=electric">Electric</a></li>
in Furniture.aspx will show all product that have H_name=electric
i have another Item
<li><a href="Furniture.aspx?h_name=?">show all</a></li>
i want when user click in this item on jquery menu in Furniture.aspx will show all product in this item H_name is'nt important i want show all product with different H_name
View 1 Replies
Feb 9, 2010
I have a datalist and want the results paged I have written a pager.ascx page and have an aspx and aspx.cs page to display the results. I have a stored procedure to pull the data out of the database and a class to talk between the stored procedure and presentation controls I have the pager being displayed when the results get over the limit I have set to 10 in the web.config file but when i click on the next link to display the next page of results it doesn't do anything. my aspx page is
<uc1:Pager ID="topPager" runat="server" Visible="False" />
<asp:DataList ID="newsList" runat="server" CssClass="List" align="center">
<ItemStyle CssClass="ItemList" />
<ItemTemplate>
<h2><%# Eval("Title") %></h2>
<p>Posted <%# Eval("Date") %></p>
<p><%# Eval("News").ToString().Replace("
", "<br />") %></p>
</ItemTemplate>
</asp:DataList>
<uc1:Pager ID="bottomPager" runat="server" Visible="False" />
my aspx.cs page is
protected void Page_Load(object sender, EventArgs e)
{
// Retreive page from the query string
string page = Request.QueryString["Page"];
if (page == null) page = "1";
// How many pages of posts
int howManyPages = 1;
// pager links format
string firstPageUrl = "";
string pagerFormat = "";
//DataAccess.GetNews returns a DataTable object containing news data which is read into datalist
newsList.DataSource = DataAccess.GetNews(page, out howManyPages);
// Bind the data to the data source
newsList.DataBind();
// have the current page as interger
int currentPage = Int32.Parse(page);
// Display pager controls
topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false);
bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true);
}
my pager.ascx page is
<p>
Page
<asp:Label ID="currentPagelabel" runat="server" />
of
<asp:Label ID="howManyPageLabel" runat="server" />
|
<asp:HyperLink ID="previousLink" runat="server">Previous</asp:HyperLink>
<asp:Repeater ID="pagesRepeater" runat="server">
<ItemTemplate>
<asp:HyperLink ID="hyperlink" runat="server" Text='<%# Eval("Page") %>' NavigateUrl='<%# Eval("Url") %>' />
</ItemTemplate>
</asp:Repeater>
<asp:HyperLink ID="nextLink" runat="server">Next</asp:HyperLink>
</p>
my pager.aspx.cs page is
using System;
// Simple struct that represents a (page number, url) association
public struct PageUrl
{
private string page;
private string url;
// Page property definition
public string Page
{
get
{
return page;
}
}
// Url property definition
public string Url
{
get
{
return url;
}
}
// Constructor
public PageUrl(string page, string url)
{
this.page = page;
this.url = url;
}
}
// The pager control
public partial class UserControls_Pager : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
// Show the pager
public void Show(int currentPage, int howManyPages, string firstPageUrl, string pageUrlFormat, bool showPages)
{
// Display paging controls
if (howManyPages > 1)
{
// make the pager visable
this.Visible = true;
// Display the current page
currentPagelabel.Text = currentPage.ToString();
howManyPageLabel.Text = howManyPages.ToString();
// Create the Previous link
if (currentPage == 1)
{
previousLink.Enabled = false;
}
else
{
previousLink.NavigateUrl = (currentPage == 2) ? firstPageUrl : String.Format(pageUrlFormat, currentPage - 1);
}
// Create the Next link
if (currentPage == howManyPages)
{
nextLink.Enabled = false;
}
else
{
nextLink.NavigateUrl = String.Format(pageUrlFormat, currentPage + 1);
}
// Create the page links
if (showPages)
{
// The list of pages and their URLs as an array
PageUrl[] pages = new PageUrl[howManyPages];
// Generate (page, url) elements
pages[0] = new PageUrl("1", firstPageUrl);
for (int i = 2; i <= howManyPages; i++)
{
pages[i - 1] = new PageUrl(i.ToString(), String.Format(pageUrlFormat, i));
}
// Do not generate a link for current page
pages[currentPage - 1] = new PageUrl((currentPage).ToString(), "");
// Feed the pages to the repeater
pagesRepeater.DataSource = pages;
pagesRepeater.DataBind();
}
}
}
}
my class file is
// Retreive the list of news posts
public static DataTable GetNews(string pageNumber, out int howManyPages)
{
// Get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// Set the stored procedure name
comm.CommandText = "GetNews";
// create a new parameter for page number
DbParameter param = comm.CreateParameter();
param.ParameterName = "@PageNumber";
param.Value = pageNumber;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter for products per page
param = comm.CreateParameter();
param.ParameterName = "@PostsPerPage";
param.Value = PlatiumMindProductionsConfiguration.PostsPerPage;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@HowManyPosts";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// Execute the stored procedure and saven the results in a DataTable
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
// Calculate how many pages of posts and set the out parameter
int howManyPosts = Int32.Parse(comm.Parameters["@HowManyPosts"].Value.ToString());
howManyPages = (int)Math.Ceiling((double)howManyPosts / (double)PlatiumMindProductionsConfiguration.PostsPerPage);
// return the page of posts
return table;
}
my stored procedure is
ALTER PROCEDURE [dbo].[GetNews]
(@PageNumber INT,
@PostsPerPage INT,
@HowManyPosts INT OUTPUT)
AS
-- Declare a new table
DECLARE @News TABLE
(RowNumber INT,
NewsID INT,
Title NVARCHAR(50),
Date DATETIME,
News NVARCHAR(MAX))
-- Populate the table with the complete list
INSERT INTO @News
SELECT ROW_NUMBER() OVER (ORDER BY NewsID desc),
NewsID, Title, Date, News
FROM News
-- return the total number of posts
SELECT @HowManyPosts = COUNT(NewsID) FROM News
-- extract the request page of posts
SELECT NewsID, Title, DATE, News
FROM @News
WHERE RowNumber > (@PageNumber - 1) * @PostsPerPage
AND RowNumber <= @PageNumber * @PostsPerPage
View 1 Replies
Feb 25, 2010
I have a datalist inside 1 datalist.In the first datalist i am binding the "advertisement posted" date field from sql server. In the second datalist i am binding the ads posted on that date using an object datasource. my pro is, i need to show a total of 100 ads in one page. This should not depend on the date. Total 100 postings in the page. For example
Todays date (02/25/2010)
50 postings
yesterdays date (02/24/2010)
if 75 postings are there,
50 postings
it should display only 50 postings under yesterday's date remaining 25 postings should display in next page(paging) with the format like this
yesterdays date (02/24/2010)
remaining 25 postings
(02/23/2010)
75 postings
how can i do the paging like this?
View 3 Replies
Feb 19, 2010
I have One site in which i have to show products using datalist and use of paging is must i have created the same but its not very effective i want the paging same as [URL]
View 4 Replies
Jan 11, 2010
How can i refresh(Asych) the contents of my Datalist on the parent page from a data change in a page that is displayed in an iFrame on the parent page.
I have movie names with image in the data list that is on parent page.
there another page is openend in the parent pages in an iFrame control.
in that sub page i upload image and other data related to a new movie.
What i want is that when i submit that information in an iFrame page, the DataList should update(Asych) itself on the parent page showing new updated info.
the structure is like;
[code]...
View 1 Replies
Nov 15, 2010
The problem is that i have a search page. Access Database holding the information. I have a Access Datasource on the page with a Datalist to show the data. I need to find a way on setting it up to says "Sorry no results found" when the is no results. i am unsure on how to do this though.
Below is my datasource and datalist
[Code]....
View 6 Replies
Feb 5, 2010
I'm trying to pull different product meta tags from a database onto a page. The problem I have is my DefaultValue="59" is the only product to be displayed if I change this value to another product id it displays just that products meta tags.
Below is my code:
[Code]....
[Code]....
[Code]....
View 4 Replies
Oct 6, 2010
I have a gridview which shows products from product table. I have 1000s of products in db and gridview shows 15 records per page. I want to fetch only 15 records from database at one time but page number should show as all products are in list and with page change next products should be displayed. grid has sorting enabled. on top of page there is a text box for records filtering so I need to keep sorting in mind as well.
View 1 Replies
Mar 5, 2010
I have a table which contains products with many different attributes (columns). Depending on which product the user looks at I want to present it differently as one product might have only a few attributes and others have a lot. I have been thinking a long the line of having a set of templates and associate each product with a template but can't figure out how implement that in a smart way. Some options I have been thinking of 1) One datasource and several formviews - doesn't work if I'm not misstaken 2) Several form views and datasoruces - this would however need programming to enable to right set. 3) Using the wizard control to separate different form views and data sources.
View 4 Replies
Sep 19, 2010
I'd like show a products list in one ListView. Each item is a product in the List<Productos>.
If a product quantity is 3, the list have 3 repeated items with the same product.
How can i do for display in the item of ListView the product description + quantity of this product?
This is my code:
[Code]....
View 7 Replies
Jul 9, 2010
I'm really new at asp.net 3.5 I'm comming from Classic ASP and I have been experimenting with ASP.NET. I'm trying to use the ListView Control to display a products catalog comming from a database. My first test was succesfull but I have a question.I want to be able to display the title of the product in Bold if certain conditions exists for that product. I tried using the ItemDataBound event but I don't know how I to get the value from the database field.I have the following code
ASPX PAGE
[Code]....
CODE BEHIND
Protected Sub productsList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) Handles productsList.ItemDataBound
View 3 Replies
Mar 19, 2010
I need to read data in DataGridView from page1.aspx, then these datas are display using label in another page as page2.aspx. I think here QueryString concept may be used in DataGridView.But i cant remember that coding now. i am new for asp.net how to get these data in another web page.
View 43 Replies
Jan 15, 2010
I have several datalist controls inside a panel control.
When I do a databind on the "movie" datalist, data is populated. I can see during the debugging on the aspx page that it goes into the label controls and binds the data.
When I do a databind on the "alacarte" datalist, the data isn't populated even though before doing the databind I validate that there is a record inside the generic collection that I use for each separate type of datalist. When the databind occurs, it goes thru the alacarte datalist and does the databinding to the fields, but when the page renders, it doesn't produce any output inside this datalist.
The code behind below is the databinding for the movie datalist.
DataList grdMovies = ShoppingCart1.FindControl("grdMovies") as DataList;
grdMovies.DataSource = lstMovies;
grdMovies.DataBind();
The code behind below is the databinding for the alacarte datalist. I verified that there is a record inside the lstAlacarte collection with the same field names that are in the html for the alacarte section during the databinding.
DataList grdCartAlaCartePgming = ShoppingCart1.FindControl("grdCartAlacartePgming") as DataList;
grdCartAlaCartePgming.DataSource = lstAlacarte;
grdCartAlaCartePgming.DataBind();
Below is the html on the aspx page for the above controls. I included all of the html so as to see if there is anything I'm doing wrong. I even placed the words "desc" and "price" to see if that would render and it did not.
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ShoppingCart.ascx.cs"
Inherits="DishRedesignClient.ShoppingCart" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>
<asp:Panel ID="pnlShoppingCart" runat="server" Height="400px" Width="300px"
[Code]....
View 5 Replies
Jul 13, 2010
below is my procedure and event for paging in datalist.First,next,previos is working fine.
but i need the last page here.
Procedure
[Code]....
Event
[Code]....
View 4 Replies
Sep 11, 2010
I need to display a list of products 1 below each other with a textbox, i will also need a checkbox that will hold the prodID. so i was thinking i need to do a loop but i am not sure how to do it. It needs to be like this
[checkbox(which will contain the prodID)] prodName Qty [textbox1] [textbox2]
so for each product in my products table i want to display it like above, now this is for a stock take module so the client will enter his values for each product in textbox1, when the client clicks the submit button, i will need to loop through the above products and calculate the difference if any so it will be (QTY - TEXTBOX1), if there is a difference the check the checkbox and display the difference in TEXTBOX2. so if the QTY = 10 and the client entered 8 in textbox1 then textbox2 should show you 2 and the checkbox should be checked. then the client will click the update button and it will loop through every product above and where the checkbox is checked, it should update the QTY of that product from the value entered in textbox1.
View 3 Replies
Aug 10, 2010
I have a web user control with DataList control in it. In my .aspx page, I have a report header, an empty panel as a place holder, a report footer.In my .aspx.vb file, I'll loop through a list of departments. Within each department, I'll load a label to display the department name and the user control for the data, and add both the label and user control to the panel. So there are two variables:
the number of departments and the number of records in a user control.
Now I need to display the current page number and the total page number in the report footer. Is it doable? How? I'm thinking of this approach: declare a page variable count, count the number of department name labels and the number of records in a user control. When the total count reaches a number, such as 20, I'll break the page. This way, I can get the the page current number and the total number of pages. But how to add a page break to an asp.net page?
View 8 Replies
Jul 23, 2010
if users press the browser's back button to reach the prior page..then page should display a message like "web page expired" in asp.net can i use javascript for this?
for example..
there are 4 pages in web sites. 1,2 and 3 can be back. but when the 4th page run then 4th page can not be back... when the user press browser's back button , diaplay ma message "weg page expired".
View 4 Replies
Jul 22, 2010
i want to use a Datalist to list products from sqldatasource. When i select the Product i would like to retrieve the associate Product value in the code behind page so that i may use it to display data in Grid.
View 8 Replies
Feb 12, 2011
I want to bind DataList on Masterapge
My datalist contains some Images
when i write DataList.DataBind(); then whole process is completed , dataset contains all the url of images.
but images cant displayed at runtime..
View 3 Replies
May 18, 2010
I've got a Datalist displaying entries from a table and I want to change the title of the page based on a field in the table.
So everytime the selected displayed entry is changed it would change the Title of the page to reflect the value of that field.
View 1 Replies
Jan 8, 2010
i want to bind data to html page using datalist control ...
or is there another way to bind data to simple html control ....where i am feching data from sql server ...
View 2 Replies
Sep 20, 2015
I have read and referred your range slider and loading infinite images on scroll.The issue is when combining both the article the data is appending to old one.
View 1 Replies
Dec 3, 2012
In my database having 50 records,i wnt to display the first 10 record on first page of gridview and next 20 record on second page and so on..
View 1 Replies
