1 to many in GridView

MRW · Sep 16, 2006

Hello!

I don't know if this is possible, but I have two tables in a
one-to-many relationship. I want one record to be displayed in a
GridView from table1 with a blue background, followed by all the
related records in table 2 in a white background, followed by the next
record in table1 in a blue background (for example). It should be nice
an simple. Back in the ASP Classic days, I would use response.write
and build a table, but I was wondering if there is an easier way to do
this in .NET. Oh yes, I'm using VB.

Thanks for any help!

MRW · Sep 16, 2006

Sorry... quick addition. Instead of going with an inner join, I could
use a DataSet with the two related tables. The question is how to
display them properly.

Ken Cox [Microsoft MVP] · Sep 16, 2006

Hi,

You can include a gridview inside a gridview row by using the RowDataBound
event. Each time you loop through a row, get the key field and use that to
query the inner gridview. Here's an example that might get you started.

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]

<%@ page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<script runat="server">

Protected Sub grdCustomers_RowDataBound _
(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.DataRow Then
Dim strcustomerID As String = _
DataBinder.Eval(e.Row.DataItem, "CustomerID")
Dim srcOrders As SqlDataSource = _
CType(e.Row.FindControl("SqlDataSource2"), SqlDataSource)
srcOrders.SelectParameters("CustomerID").DefaultValue = _
strcustomerID

End If
End Sub

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Nested Master/Detail</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:gridview id="grdCustomers"
runat="server"
autogeneratecolumns="False"
datasourceid="SqlDataSource1"
gridlines="None"
onrowdatabound="grdCustomers_RowDataBound"
showheader="False">
<columns>
<asp:templatefield>
<itemtemplate><br />
<h2 style="background-color: LightBlue; color: white"><%#
eval("companyname") %>(<%#Eval("CustomerID")%>)</h2>
<asp:gridview
id="grdOrders"
runat="server"
rowstyle-backcolor="white"
datasourceid="SqlDataSource2" />
<asp:sqldatasource id="SqlDataSource2"
runat="server"
connectionstring="<%$
ConnectionStrings:NorthwindConnectionString %>"
selectcommand="SELECT [CustomerID],[OrderID], [OrderDate],
[ShippedDate] FROM [Orders] WHERE ([CustomerID] = @CustomerID)">
<selectparameters>
<asp

arameter name="CustomerID" />
</selectparameters>
</asp:sqldatasource>
</itemtemplate>
</asp:templatefield>
</columns>
</asp:gridview>
<br />
<br />
<asp:sqldatasource
id="SqlDataSource1"
runat="server"
connectionstring="<%$
ConnectionStrings:NorthwindConnectionString %>"
selectcommand="SELECT [CustomerID], [CompanyName] FROM
[Customers]">
</asp:sqldatasource>
</div>
</form>
</body>
</html>

1 to many in GridView	2	Sep 16, 2006
How can I find out the id of the first record in a database table, assuming record 1 is deleted?	2	Aug 27, 2025
Database Manager: A C++ Console Application	14	May 12, 2025
Gridview button field only works on page 1 of grid	1	Mar 9, 2010
Can anyone please help? HTML - two tables applying different styles	4	Dec 1, 2020
Rich Text Format (RTF) Document Builder in C++: Code and Features	0	Sep 28, 2025
Question: Gridview question (displaying data from a related "many" table)	1	Nov 14, 2007
Can't execute php to delete multiple rows in database	3	May 14, 2023

1 to many in GridView

MRW

MRW

Ken Cox [Microsoft MVP]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads