I have a desire to be able to have a separate table for each record from a database. Please see http://www.switchboard.com/bin/cgidir.dll?mem=1301&FUNC= FORMATSEARCH&from=SBYP&C=Spas+%26+Hot+Tubs-Dealers&a mp;T=Tucson&S=AZ for an example. I want tables with individual records. I have tried doing this with a datagrid, but I have failed.
There are two problems. The first problem is I want the name of the store to be on the header along with the web address. The second problem is I want all of the records to have a separate table.
Here's my code:
<ASP:DATAGRID id=dtgSpa runat="server"
Width="500px"
ForeColor="Black"
Font-Bold="True"
Font-Size="8pt"
Font-Name="Verdana, San-Serif"
CellPadding="7"
BorderWidth="1"
BorderColor="#666666"
BorderStyle="None"
BackColor="White"
ShowFooter="False"
ShowHeader="True"
AutoGenerateColumns="False"
EnableViewState="False">
<Columns>
<asp:HyperLinkColumn HeaderText="SpaStoreName" (Not Happy with this) DataTextField="SpaStoreName" datanavigateurlformatstring="SpaStoreInfo.aspx?ID={0}" datanavigateurlfield="SpaStoreID" /> (I don't want this to go on the next line. I want all of this to be on the header.)
</Columns>
<HeaderStyle
ForeColor="White"
BorderStyle="Solid"
BorderColor="#333333"
BackColor="#333399" />
<AlternatingItemStyle
ForeColor="#333366"
BorderColor="#333333"
BackColor="#99ccff" />
<ItemStyle
Font-Bold="True"
ForeColor="#000000" />
</ASP:DATAGRID>