Pivot data in editable datagrid. Possible or not?

[Brian Pittman]

Hi,

I would like to have a datagrid pivoted and also editable. How can this be
accomplished. I know I can pivot the data using an asp template column.
But making it editable is becoming quite a task. Below is the code to pivot
the data. If someone could show me how to also make it editable; it would
be much appreciated. In the meantime I'll keep trying. Thanks.

Brian

<asp:datagrid id="dgProfile" ShowHeader="False" CellPadding="3"
BackColor="White" BorderWidth="1px"
BorderStyle="Solid" BorderColor="#CCCCCC" Width="399px" Runat="server"
AutoGenerateColumns="False"
GridLines="None">
<SelectedItemStyle Font-Bold="True" ForeColor="White"
BackColor="#669999"></SelectedItemStyle>
<ItemStyle ForeColor="#000066"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="White"
BackColor="#006699"></HeaderStyle>
<FooterStyle ForeColor="#000066" BackColor="White"></FooterStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<TABLE>
<TR>
<TD><b>First Name:</b></TD>
<TD>
<%#Container.DataItem("FirstName")%></TD>
</TR>
<TR>
<TD><b>Last Name:</b></TD>
<TD><%#Container.dataitem("LastName")%></TD>
</TR>
<TR>
<TD><b>User Name:</b></TD>
<TD><%#Container.dataitem("Username")%></TD>
</TR>
<TR>
<TD><b>Password:</b></TD>
<TD><%#Container.dataitem("Password")%></TD>
</TR>
<TR>
<TD><b>Employer:</b></TD>
<TD><%#Container.dataitem("Employer")%></TD>
</TR>
<TR>
<TD><b>Division:</b></TD>
<TD><%#Container.dataitem("Division")%></TD>
</TR>
<TR>
<TD><b>Certificat:</b></TD>
<TD><%#Container.dataitem("Certificate")%></TD>
</TR>
<TR>
<TD><b>Experience:</b></TD>
<TD><%#Container.dataitem("Experience")%></TD>
</TR>
<TR>
<TD><b>Grade Level:</b></TD>
<TD><%#Container.dataitem("Grade Level")%></TD>
</TR>
<TR>
<TD><b>Specialty:</b></TD>
<TD><%#Container.dataitem("Specialty")%></TD>
</TR>
<TR>
<TD><b>Degrees:</b></TD>
<TD><%#Container.dataitem("Degrees")%></TD>
</TR>
<TR>
<TD><b>Email:</b></TD>
<TD><%#Container.dataitem("Email")%></TD>
</TR>
<TR>
<TD><b>Birth Date:</b></TD>
<TD><%#Left(Container.dataitem("BirthDate"),10)%></TD>
</TR>
<TR>
<TD><b>Gender:</b></TD>
<TD><%#Container.dataitem("Gender")%></TD>
</TR>
<TR>
<TD><b>Last Visit:</b></TD>
<TD><%#Container.dataitem("LastVisit")%></TD>
</TR>
<TR>
<TD><b>District:</b></TD>
<TD><%#Container.dataitem("District")%></TD>
</TR>
<TR>
<TD><b>City:</b></TD>
<TD><%#Container.dataitem("City")%></TD>
</TR>
<TR>
<TD><b>Address:</b></TD>
<TD><%#Container.dataitem("Address")%></TD>
</TR>
<TR>
<TD><b>Province:</b></TD>
<TD><%#Container.dataitem("Province")%></TD>
</TR>
<TR>
<TD><b>Postal Code:</b></TD>
<TD><%#Container.dataitem("Postal")%></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle HorizontalAlign="Left" ForeColor="#000066" BackColor="White"
Mode="NumericPages"></PagerStyle>
</asp:datagrid>