Nested detailsview

James Page · Oct 20, 2009

Hi all
I have a nested detailsView in a gridView.
What Iâ€™m trying to do is display values derived from the row in the gridview
and pass the row id to the detailsview to produce something like:

Gridview item 1
Detailsviewitem1
Detailsviewitem2
Detailsviewitem3
GridviewItem 2
Detailsviewitem1
Detailsviewitem2
Etc...

The data (SQL) is stored like so:
GridView data

Id
Name

DetailsView Data
Id
GridviewId
Text

What i need to do is pass the gridviewRow id to the detailsview and display
matching data without the need for using selected row.
Iâ€™m sure i need a for each loop but how do I retrieve the gridview row id
and pass this variable to the datasource for the detailsview and show only
data where the gridview id matches the gridviewId in the detailsview table?

Thanks

James Page · Oct 21, 2009

Hi again

I've managed to sort out how to databind the nested listView (changed from
detailsView) but how do I reference the label in the list view?

Aspx page:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb"
Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#
Eval("name") %>'></asp:Label>

<asp:Label ID="Label3" runat="server" Text='<%#
Eval("id") %>' Visible="False"></asp:Label>
<div>

<asp

ataList ID="DataList1" runat="server">
<ItemTemplate>
<asp:Label ID="Label4" runat="server"
Text='<%# Eval("test") %>'></asp:Label>
</ItemTemplate>
</asp

ataList>
</div>
</ItemTemplate>
</asp:TemplateField>

</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [BizNames] ORDER BY [name]">
</asp:SqlDataSource>

</div>
</form>
</body>
</html>

Code:

Imports System.Linq

Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As
System.EventArgs) Handles GridView1.DataBound
Dim x As New DataClassesDataContext
For Each row As GridViewRow In GridView1.Rows
Dim s As Label = row.FindControl("Label3")
Dim txt As String = s.Text

Dim dl As DataList = row.FindControl("DataList1")

'Dim lbl As Label = dl.FindControl("Label4")
'lbl.BackColor = Drawing.Color.Aquamarine

'This is where I'm getting the null reference warning

dl.DataSource = x.StoredProcedure1(txt)
dl.DataBind()

Next
End Sub
End Class

Hope someone can advise

Thanks

DetailsView	0	Jan 16, 2009
Nested GridViews plus DetailsView	0	Apr 27, 2006
how can we make detailsview movable?	1	Jun 2, 2006
Button click event	1	Jan 19, 2010
DetailsView programmatically enter Insert Mode	3	Feb 21, 2008
Gridview interaction with Detailsview	2	Aug 7, 2006
Wizard question	0	Dec 8, 2008
DataGrid and DetailsView...	0	Apr 18, 2008

Nested detailsview

James Page

James Page

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads