How to get access to the current row number being output from database.

[Justin]

I'm a newby to C#, but in ColdFusion I've used <cfif #currentrow# Mod 2 is 1>.
Here is my C# code that's looping through the data.
Do I have to write my own counter or is there some way to access the row number?

while (objDataReader.Read() == true)
{
strResultsHolder += "<li><a href='customer_info.aspx?ID=";
strResultsHolder += objDataReader["AID"];
strResultsHolder += "'>";
strResultsHolder += objDataReader["Customer_Name"];
strResultsHolder += "</a></li>";
}

Thanks,

Justin

 

[Sherif ElMetainy]

Hello

Yes, you have to do your own counter. But a much better way is to use
Repeater, DataList or DataGrid with ItemTemplate and
AlternatingItemTemplate.
Here are some urls that may help.
http://www.dotnetjunkies.com/quickstart/aspplus/doc/webdatabinding.aspx
http://msdn.microsoft.com/library/l...fSystemWebUIWebControlsRepeaterClassTopic.asp
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemWebUIWebControlsDataListClassTopic.asp
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemWebUIWebControlsDataGridClassTopic.asp

Best regards,
Sherif

 

[Justin Jolley]

I ended up using the code below.
I looked at the repeater, but didn't see how it would give me the
flexability I wanted (to list 10 items in each cell).

int i = 0;

while (objDataReader.Read() == true)
{
strResultsHolder += "<li><a href='customer_info.aspx?ID=";
strResultsHolder += objDataReader["AID"];
strResultsHolder += "'>";
strResultsHolder += objDataReader["Customer_Name"];
strResultsHolder += "</a></li>";

if ( i % 10 == 9 )
{
strResultsHolder += "</td><td valign=top>";
}

i++;
}

Thanks,

Justin

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Sherif ElMetainy]

Hello

Here is how you can do it with a repeater

<asp:Repeater runat="server" id="myRep">
<itemtemplate>
<li>
<a href='customer_info.aspx?Id=<%# DataBinder.Eval(Container.DataItem,
"AID")%>'>
<%# DataBinder.Eval(Container.DataItem, "AID")%>
</a>
</li>
<asplaceholder runat="server" visible="<%# Container.ItemIndex % 10 ==
9%>">
</td><td valign="top">
</asplaceholder>
</itemtemplate>
</asp:repeater>


You may also want to look at DataList, it can't do what you want, but it is
close. If you still want to user string concatenation, then use
StringBuilder, which would have a better performance.

Best regards,
Sherif