can i display the data GROUPED in a datagrid?

[tmashley]

hello,

i have a dataset of values,
i need to group these values,

but can i display the data GROUPED in a datagrid?

sql:
SELECT * FROM Table1 ORDER BY CathodeTypeName DESC"

dataset:
CoilIDNum
CoilID
StartDate
TestDate
Operator
CathodeTypeName - group by this field
QuantTestType
PPM_Al
PPM_Sb
PPM_As
BadSample

thanks,
tom

[MrGTI]

Use the GROUP BY feature of SQL.

[tmashley]

yes, but how do i display the grouped field value as a sort of title for each change in group?

thanks,
tom