.NET Framework Class Library
DetailsView.Rows Property
Gets a collection of DetailsViewRow objects that represent the data rows in a DetailsView control.
Assembly: System.Web (in System.Web.dll)
Syntax
Visual Basic
<BrowsableAttribute(False)> _ Public Overridable ReadOnly Property Rows As DetailsViewRowCollection
C#
[BrowsableAttribute(false)] public virtual DetailsViewRowCollection Rows { get; }
Visual C++
[BrowsableAttribute(false)] public: virtual property DetailsViewRowCollection^ Rows { DetailsViewRowCollection^ get (); }
F#
[<BrowsableAttribute(false)>] abstract Rows : DetailsViewRowCollection [<BrowsableAttribute(false)>] override Rows : DetailsViewRowCollection
Property Value
Type: System.Web.UI.WebControls.DetailsViewRowCollectionA DetailsViewRowCollection that contains all the data rows in a DetailsView control.
Remarks
The Rows property (collection) is used to store the data rows in a DetailsView control. The DetailsView control automatically populates the Rows collection by creating a DetailsViewRow object for each record in the data source and then adding the object to the collection. This property is commonly used to access a specific row in the control or to iterate though the entire collection of rows.
Note
|
|---|
|
Only data rows are stored in the Rows collection. The DetailsViewRow objects that represent the header, footer, and pager rows are not included in the collection. |
Examples
The following code example demonstrates how to use the Rows property to access a data row in a DetailsView control. The data row is used to retrieve the value of a field from the DetailsView control.
Visual Basic
<%@ 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 CustomerDetailView_ItemCommand(ByVal sender As Object, ByVal e As DetailsViewCommandEventArgs) ' Use the CommandName property to determine which button ' was clicked. If e.CommandName = "Add" Then ' Add the current store to the contact list. ' Get the row that contains the store name. In this ' example, the store name is in the second row (index 1) ' of the DetailsView control. Dim row As DetailsViewRow = CustomerDetailView.Rows(1) ' Get the store's name from the appropriate cell. ' In this example, the store name is in the second cell ' (index 1) of the row. Dim name As String = row.Cells(1).Text ' Create a ListItem object with the store's name. Dim item As New ListItem(name) ' Add the ListItem object to the ListBox, if the ' item doesn't already exist. If Not ContactListBox.Items.Contains(item) Then ContactListBox.Items.Add(item) End If End If End Sub </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title> DetailsView ItemCommand Example</title> </head> <body> <form id="Form1" runat="server"> <h3> DetailsView ItemCommand Example</h3> <asp:DetailsView ID="CustomerDetailView" DataSourceID="DetailsViewSource" AutoGenerateRows="false" DataKeyNames="CustomerID" AllowPaging="true" OnItemCommand="CustomerDetailView_ItemCommand" runat="server"> <FieldHeaderStyle BackColor="Navy" ForeColor="White" /> <Fields> <asp:BoundField DataField="CustomerID" HeaderText="Store ID" /> <asp:BoundField DataField="CompanyName" HeaderText="Store Name" /> <asp:BoundField DataField="City" HeaderText="City" /> <asp:ButtonField CommandName="Add" Text="Add Contact" /> </Fields> </asp:DetailsView> <hr /> Contacts:<br /> <asp:ListBox ID="ContactListBox" runat="server" /> <!-- This example uses Microsoft SQL Server and connects --> <!-- to the Northwind sample database. Use an ASP.NET --> <!-- expression to retrieve the connection string value --> <!-- from the web.config file. --> <asp:SqlDataSource ID="DetailsViewSource" runat="server" ConnectionString= "<%$ ConnectionStrings:NorthWindConnectionString%>" InsertCommand="INSERT INTO [Customers]([CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country]) VALUES (@CustomerID, @CompanyName, @Address, @City, @PostalCode, @Country)" SelectCommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"> </asp:SqlDataSource> </form> </body> </html>
C#
<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> void CustomerDetailView_ItemCommand(Object sender, DetailsViewCommandEventArgs e) { // Use the CommandName property to determine which button // was clicked. if (e.CommandName == "Add") { // Add the current store to the contact list. // Get the row that contains the store name. In this // example, the store name is in the second row (index 1) // of the DetailsView control. DetailsViewRow row = CustomerDetailView.Rows[1]; // Get the store's name from the appropriate cell. // In this example, the store name is in the second cell // (index 1) of the row. String name = row.Cells[1].Text; // Create a ListItem object with the store's name. ListItem item = new ListItem(name); // Add the ListItem object to the ListBox, if the // item doesn't already exist. if (!ContactListBox.Items.Contains(item)) { ContactListBox.Items.Add(item); } } } </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title> DetailsView ItemCommand Example</title> </head> <body> <form id="Form1" runat="server"> <h3> DetailsView ItemCommand Example</h3> <asp:DetailsView ID="CustomerDetailView" DataSourceID="DetailsViewSource" AutoGenerateRows="false" DataKeyNames="CustomerID" AllowPaging="true" OnItemCommand="CustomerDetailView_ItemCommand" runat="server"> <FieldHeaderStyle BackColor="Navy" ForeColor="White" /> <Fields> <asp:BoundField DataField="CustomerID" HeaderText="Store ID" /> <asp:BoundField DataField="CompanyName" HeaderText="Store Name" /> <asp:BoundField DataField="City" HeaderText="City" /> <asp:ButtonField CommandName="Add" Text="Add Contact" /> </Fields> </asp:DetailsView> <hr /> Contacts:<br /> <asp:ListBox ID="ContactListBox" runat="server" /> <!-- This example uses Microsoft SQL Server and connects --> <!-- to the Northwind sample database. Use an ASP.NET --> <!-- expression to retrieve the connection string value --> <!-- from the web.config file. --> <asp:SqlDataSource ID="DetailsViewSource" runat="server" ConnectionString= "<%$ ConnectionStrings:NorthWindConnectionString%>" InsertCommand="INSERT INTO [Customers]([CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country]) VALUES (@CustomerID, @CompanyName, @Address, @City, @PostalCode, @Country)" SelectCommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"> </asp:SqlDataSource> </form> </body> </html>
Version Information
.NET Framework
Supported in: 4, 3.5, 3.0, 2.0Platforms
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
See Also