Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicates in DataList ????????????????????????

Status
Not open for further replies.
qberta1

qberta1

Programmer
Joined
Apr 27, 2005
Messages
4
Location
US
Hello,

I created a datalist and populate it with products from a proc. Problem is that when I run the application it lists the same product multiple times. I have checked the proc and it does not render duplicates. I cannot figure out why the datalist repeats the products.

It used to work when I had limited data in my tables, but once I appended more data to the tables this problem started. I then went back and deleted the appended data and I still get duplicates.

Any obvious reason why this might be occuring?

Thanks for the help!

Q!
 
Sort by date Sort by votes
can i have the code???

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
page cacheing?

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."
 
Upvote 0 Downvote
Okay The Code:

<%@ OutputCache Duration="6000" VaryByParam="CategoryID" %>
<%@ Register TagPrefix="ASPNETCommerce" TagName="Header" Src="_Header.ascx" %>
<%@ Register TagPrefix="ASPNETCommerce" TagName="Menu" Src="_Menu.ascx" %>
<%@ Page Language="vb" EnableViewState="false" CodeBehind="ProductsList.aspx.vb" AutoEventWireup="false" Inherits="ASPNET.StarterKit.Commerce.ProductsList" %>

<HTML>
<HEAD>
</HEAD>
<body>
<table>
<tr>
<td colspan="2">
code.....
</td>
</tr>
<tr>
<td valign="top">
code...... </td>
<td> <table>
<tr valign="top">
<td nowrap>
<br>
<asp:DataList id="MyList"
RepeatColumns="2" runat="server">
<ItemTemplate>
<table>
<tr>
<td width="25">
</td>
<td>
<a href='ProductDetails.aspx?productID=<%# DataBinder.Eval(Container.DataItem, "ProductID") %>'>

<img src='ProductImages/thumbs/<%# DataBinder.Eval(Container.DataItem, "ProductImage") %>' width="100" height="75" border="0"></a>
</td>
<td>
<a href='ProductDetails.aspx?productID=<%# DataBinder.Eval(Container.DataItem, "ProductID") %>'>
<span class="ProductListHead">
<%# DataBinder.Eval(Container.DataItem, "ModelName") %>
</span>
<br></a>
<span class="ProductListItem">
<b>Special Price: </b>
<%# DataBinder.Eval(Container.DataItem, "UnitCost", "{0:c}") %>
</span>
<br>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>............................

Code Behind:

Public Class ProductsList
Inherits System.Web.UI.Page
Protected WithEvents MyList As System.Web.UI.WebControls.DataList

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

' Obtain categoryId from QueryString
Dim categoryId As Integer = CInt(Request.Params
("CategoryID"))

' Obtain products and databind to an asp:datalist control
Dim productCatalogue As
ASPNET.StarterKit.Commerce.ProductsDB = New
ASPNET.StarterKit.Commerce.ProductsDB()
MyList.DataSource = productCatalogue.GetProducts
(categoryId)
MyList.DataBind()

End Sub

End Class


-----

Sorry for the mess!

Thanks!


 
Upvote 0 Downvote
Within the productCatalogue.GetProducts Function you may need to check if the returned object is already populated.

Within my applications I use something like this...
Code: 
' Ensure the Dataset is not populated more than once.
If (Not IsNothing(DatasetName.Tables("tablename"))) Then
DatasetName.Tables("tablename").Clear()
End If


--
Not until I became a Network Administrator did the error message "See your Network Administrator for assistance" become petrifying.
 
Upvote 0 Downvote
You know this was driving me just about insane. The problem was with the proc. I had it as follows:

exec CMRC_GetPriceRange

Select c.ProductID,
c.ModelName,
UnitCost,
c.ProductImage
from CMRC_Products c
Left Join PriceRange p ON c.ProductID = p.ProductID
WHERE
c.CategoryID = @CategoryID
ORDER BY
ModelName,
ModelNumber

----

Even though it didn't return duplicate values when running through query analyzer it returned duplicates to the datalist. Anyway, I changed it and it now works.

Thanks for the help.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JohnB33
  • Locked
  • Question Question
int type causes error
Replies
0
Views
1K
JohnB33
JohnB33
a6green
  • Locked
  • Question Question
How to configure AT&T / Avaya Definity G3 incoming ISDN trunk
Replies
2
Views
1K
a6green
a6green
WIREMESH
  • Locked
  • Question Question
Play mp4 files in asp.net 2.0 webforms application
Replies
0
Views
442
WIREMESH
WIREMESH
sugu1
  • Locked
  • Question Question
sound editing in web site to record, cut/trim, paste and save as wav file
Replies
0
Views
1K
sugu1
sugu1
thep1
  • Locked
  • Question Question
dynamic pivot data to display in gridview
Replies
3
Views
809
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top