DropDownList in DataGrid and SQL Query with Child Rows

[John Bonds]

I have made a Template column in my DataGrid that contains a DropDownList.
My main SQL query that is bound to this datagrid joins with another table in
the following way:

SELECT * FROM Customer
INNER JOIN Orders ON Orders.Customer ID = Customer.Custom erID

So I will get multiple rows returned for each customer per their orders.
I want to only show the customer once and have the DropDownList contain that
customer's orders. How do I do this?

Thanks,

John

[Morten]

You can user Group by.

This is from Northwind:
SELECT dbo.Customers.C ustomerID, dbo.Customers.C ompanyName,
dbo.Customers.C ontactName, dbo.Customers.C ontactTitle,
dbo.Customers.A ddress,
dbo.Customers.C ity, dbo.Customers.R egion,
dbo.Customers.P ostalCode, dbo.Customers.C ountry, dbo.Customers.P hone,
dbo.Customers.F ax
FROM dbo.Customers INNER JOIN
dbo.Orders ON dbo.Orders.Cust omerID =
dbo.Customers.C ustomerID
GROUP BY dbo.Customers.C ustomerID, dbo.Customers.C ompanyName,
dbo.Customers.C ontactName, dbo.Customers.C ontactTitle,
dbo.Customers.A ddress,
dbo.Customers.C ity, dbo.Customers.R egion,
dbo.Customers.P ostalCode, dbo.Customers.C ountry, dbo.Customers.P hone,
dbo.Customers.F ax

Morten

"John Bonds" <jo*******@hotm ail.com> wrote in message
news:en******** ******@TK2MSFTN GP12.phx.gbl...

I have made a Template column in my DataGrid that contains a DropDownList.
My main SQL query that is bound to this datagrid joins with another table in the following way:

SELECT * FROM Customer
INNER JOIN Orders ON Orders.Customer ID = Customer.Custom erID

So I will get multiple rows returned for each customer per their orders.
I want to only show the customer once and have the DropDownList contain that customer's orders. How do I do this?

Thanks,

John

[Morten]

You can user Group by.

This is from Northwind:
SELECT dbo.Customers.C ustomerID, dbo.Customers.C ompanyName,
dbo.Customers.C ontactName, dbo.Customers.C ontactTitle,
dbo.Customers.A ddress,
dbo.Customers.C ity, dbo.Customers.R egion,
dbo.Customers.P ostalCode, dbo.Customers.C ountry, dbo.Customers.P hone,
dbo.Customers.F ax
FROM dbo.Customers INNER JOIN
dbo.Orders ON dbo.Orders.Cust omerID =
dbo.Customers.C ustomerID
GROUP BY dbo.Customers.C ustomerID, dbo.Customers.C ompanyName,
dbo.Customers.C ontactName, dbo.Customers.C ontactTitle,
dbo.Customers.A ddress,
dbo.Customers.C ity, dbo.Customers.R egion,
dbo.Customers.P ostalCode, dbo.Customers.C ountry, dbo.Customers.P hone,
dbo.Customers.F ax

Morten

"John Bonds" <jo*******@hotm ail.com> wrote in message
news:en******** ******@TK2MSFTN GP12.phx.gbl...

I have made a Template column in my DataGrid that contains a DropDownList.
My main SQL query that is bound to this datagrid joins with another table in the following way:

SELECT * FROM Customer
INNER JOIN Orders ON Orders.Customer ID = Customer.Custom erID

So I will get multiple rows returned for each customer per their orders.
I want to only show the customer once and have the DropDownList contain that customer's orders. How do I do this?

Thanks,

John