counting records in a <asp:repeater>

tdaustin · December 4th, 2003, 10:28 PM

Hi everyone,

Im still working around the new features of .net and have created a dataset and i use the repeater to dynamically create a table. It all works fine, but now i need some logic to not display the repeater if not records are found. How do findout how many records are found.

Thanks Tim

***CODE BELOW***

<script language="vb" runat="server">
Sub Page_Load
If Not Page.IsPostBack Then
Dim objConn, strSQL, DBComm, DBRead, TID, CollectionName, CollectionImageLarge
TID = Request.Form("TID")
ViewState("CollectionName") = Request.Form("CollectionName")
ViewState("CollectionImageLarge") = Request.Form("CollectionImageLarge")
objConn = New OledbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\veroniqueparis\database\ VeroniqueParisDB.mdb")
objConn.Open()
strSQL = "SELECT * FROM tblTasselItems WHERE TasselCollectionID = " & TID & " ORDER BY TasselItemID"
    DBComm = New OleDbCommand(strSQL,objConn)
    DBRead = DBComm.ExecuteReader()
    tassel.DataSource = DBRead
    tassel.DataBind()
    DBRead.Close()
    objConn.Close()

End If
End Sub
</script>

*** Repeater Code ****

<asp:Repeater ID="tassel" runat="server">
<headertemplate>
<table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#000000"><tr class="pageheaders">
<th width="15%" scope="col"><span class="style11">ITEM No. </span></th>
<th width="55%" scope="col"><span class="style11">Description</span></th>
<th width="15%" scope="col"><span class="style11">No. per pack </span></th>
<th width="15%" scope="col"><span class="style11">size</span></th>
</tr>

</headertemplate>
<itemtemplate>

<tr bgcolor="#FDFCF2">
<td width="15%"><span class="style19"><%# Container.DataItem"TasselItem") %></span></td>
<td width="52%"><span class="style19"><%# Container.DataItem("TasselDescription") %></span></td>
<td width="18%" align="center"><span class="style19"><%# Container.DataItem("TasselPack") %></span></td>
<td width="15%" align="center"><span class="style19"><%# Container.DataItem("TasselSize") %></span></td>
</tr>
</itemtemplate>
<footertemplate></table></footertemplate>
</asp:Repeater>

TDA

planoie · December 5th, 2003, 10:28 AM

Check the OleDbDataReader.HasRows property.
Set the repeater visibility based on that.

Peter
------------------------------------------------------
Work smarter, not harder.

Imar · December 5th, 2003, 03:05 PM

Alternatively (if you're using the .NET Framework version 1.0), you can check the Items collection of the Control you have bound your data to. Something like this should work:

Code:

// Bind Data Here
if (myDataGrid.Items.Count > 0)
{
  // There are Items
}
else
{
  // There are no Items
  // Display a Label, or whatever.
}

This has always worked for me, before HasRows was introduced.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

tdaustin · December 7th, 2003, 08:46 PM

Thanks guys,

All worked out well. I used the .Items.Count

Just for future interest how do you use the OleDbDataReader.HasRows property. I kept getting
'HasRows' is not a member of 'System.Data.OleDb.OleDbDataReader'.

Thanks again
Tim

TDA

Imar · December 8th, 2003, 02:58 AM

HasRows was introduced in the .NET Framework version 1.1. Which version are you using?

Imar

(Edited this post. I said HasRows is available as of version 1.0, while I should have said 1.1)

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

tdaustin · December 8th, 2003, 04:29 AM

I am using
Version:1.0.3705.0

will this prevent the HasRows working? Could you show me a quick reference how you would use this property.

Thanks

TDA

Imar · December 8th, 2003, 04:49 AM

Right, I thought so. This is version 1.0

To be able to use HasRows, you'll need the .NET Framework version 1.1 (this forum is supposed to discuss 1.1 issues only, but the differences between the versions are not always clear).

You can download version 1.1 from the Microsoft site at: http://msdn.microsoft.com/netframework/

Check here and here for more information about the HasRows property.

Cheers,

Imar

(Sorry for the confusion. In an earlier post I said HasRows is available in version 1.0, while I meant 1.1.)

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

tdaustin · December 8th, 2003, 05:49 AM

Thanks Imar,

I didn't relise my version was out of date

Tim :)

TDA