datagrid controls for rows?

[jjr0319]

i have a datagrid that returns values from an Access DB. the first two columns are fields in the DB (ORDER and DESCRIPTION) that are supposed to concatenate downwards (which they do). however the next column i want each row to be a seperate field (DATE_1, DATE_2, DATE_3) and not concatenate the records. here's my datagrid code (red text implys what i want the datagrid to do, but have no idea how to do it):

<asp:datagrid id="stepInfo" runat="server"
BackColor="#ffffff" Width="100%"
HorizontalAlign="Center"
Font-Name="Verdana"
CellPadding="4"
Font-Size="8pt"
AutoGenerateColumns="False">

<HeaderStyle BackColor="#eaeaea" ForeColor="#000000" Font-Bold="True" HorizontalAlign="Left" />
<AlternatingItemStyle BackColor="#eaeaea" />

<Columns>
<asp:BoundColumn DataField="ORDER_NUM" HeaderText="Order" ReadOnly="True"/>
<asp:BoundColumn DataField="DESCRIPTION" HeaderText="Description" ReadOnly="True"/>

<asp:BoundColumn DataField="multiple fields (DATE_1, DATE_2, DATE_3)" HeaderText="Original Date"/>

</Columns>

</asp:datagrid>

when rendered, the datagrid should look like this.

Order Description Original Date
------------------------------------------------------
record1 record1 DATE_1 (field)
record2 record2 DATE_2 (field)
record3 record3 DATE_3 (field)

the DATE fields have to be seperate because there will be multiple instances of each one. i.e. - multiple dates stored in DATE_1, DATE_2, etc...

any ideas?

thanks in advance for the help.

[ajn1888]

I'm not sure I understand exactly how you are storing the data. Can you give an example of how the data is stored in the table(s) in the database?

Do you mean you have multiple instances of Order_ID=1 or do you have one instance of Order_ID=1 with multiple dates??

Are you storing the data like this:

OrderID Description Original Date
------------------------------------------------------
1 descript1 2006/06/05
2 descript2 2006/06/06
3 descript3 2006/06/07

??

AJN