This question is locked. New answers and comments are not allowed.
Hi
Is it possible to use the Grouping feature in code-behind to make the result set from the query below look like the following: The primary reason but not my only reason for wanting this feature is to eliminate the viewing of redundant data and to make the column viewing area narrower which I think is better suited for smaller mobile devices.
Company Name | Contact Name | Contact Title
Order ID | Order Date
Unit Price | Quantity | Product Name
Unit Price | Quantity | Product Name
Order ID | Order Date
...
...
Thanks
Rich
...
...
USE
Northwind
SELECT
Customers.CompanyName,
Customers.ContactName,
Customers.ContactTitle,
Orders.OrderID,
Orders.OrderDate,
[Order Details].UnitPrice,
[Order Details].Quantity,
Products.ProductName
FROM
Customers INNER JOIN
Orders ON Orders.CustomerID = Customers.CustomerID INNER JOIN
[Order Details] ON [Order Details].OrderID = Orders.OrderID INNER JOIN
Products ON Products.ProductID = [Order Details].ProductID
Is it possible to use the Grouping feature in code-behind to make the result set from the query below look like the following: The primary reason but not my only reason for wanting this feature is to eliminate the viewing of redundant data and to make the column viewing area narrower which I think is better suited for smaller mobile devices.
Company Name | Contact Name | Contact Title
Order ID | Order Date
Unit Price | Quantity | Product Name
Unit Price | Quantity | Product Name
Order ID | Order Date
...
...
Thanks
Rich
...
...
USE
Northwind
SELECT
Customers.CompanyName,
Customers.ContactName,
Customers.ContactTitle,
Orders.OrderID,
Orders.OrderDate,
[Order Details].UnitPrice,
[Order Details].Quantity,
Products.ProductName
FROM
Customers INNER JOIN
Orders ON Orders.CustomerID = Customers.CustomerID INNER JOIN
[Order Details] ON [Order Details].OrderID = Orders.OrderID INNER JOIN
Products ON Products.ProductID = [Order Details].ProductID