GridViewRowCollection Class
Assembly: System.Web (in system.web.dll)
The GridViewRowCollection class is used to store and manage a collection of GridViewRow objects in a GridView control. Each row in a GridView control is represented by a GridViewRow object. The GridView control stores all of its data rows in the Rows collection.
The GridViewRowCollection class supports several ways to access the items in the collection:
-
Use the Item indexer to directly retrieve a GridViewRow object at a specific zero-based index.
-
Use the GetEnumerator method to retrieve an enumerator that can be used to iterate through the collection.
-
Use the CopyTo method to copy the items in the collection into an System.Array object, which can then be used to access the items in the collection.
To determine the total number of items in the collection, use the Count property
The following example demonstrates how to iterate through the Rows collection of a GridView control and display the values of a column on the page.
<%@ Page language="VB" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> Sub AuthorsGridView_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs) If e.Row.RowType = DataControlRowType.Footer Then ' Get the number of items in the Rows collection. Dim count As Integer = AuthorsGridView.Rows.Count ' If the GridView control contains any records, display ' the last name of each author in the GridView control. If count > 0 Then Message.Text = "The authors are:<br />" Dim row As GridViewRow For Each row In AuthorsGridView.Rows Message.Text &= row.Cells(0).Text & "<br />" Next End If End If End Sub </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>GridViewRowCollection Example</title> </head> <body> <form id="form1" runat="server"> <h3>GridViewRowCollection Example</h3> <table> <tr> <td> <asp:gridview id="AuthorsGridView" datasourceid="AuthorsSqlDataSource" autogeneratecolumns="false" onrowcreated="AuthorsGridView_RowCreated" runat="server"> <columns> <asp:boundfield datafield="au_lname" headertext="Last Name"/> <asp:boundfield datafield="au_fname" headertext="First Name"/> </columns> </asp:gridview> </td> <td> <asp:label id="Message" forecolor="Red" runat="server"/> </td> </tr> </table> <!-- This example uses Microsoft SQL Server and connects --> <!-- to the Pubs sample database. --> <asp:sqldatasource id="AuthorsSqlDataSource" selectcommand="SELECT [au_lname], [au_fname] FROM [authors] WHERE [state]='CA'" connectionstring="server=localhost;database=pubs;integrated security=SSPI" runat="server"> </asp:sqldatasource> </form> </body> </html>
- AspNetHostingPermission for operating in a hosted environment. Demand value: LinkDemand; Permission value: Minimal.
- AspNetHostingPermission for operating in a hosted environment. Demand value: InheritanceDemand; Permission value: Minimal.