DetailsView formatting

[Mike P]

The default format for the DetailsView control is for there to be a row
per field. Is it possible set it to show more than one column per row
(see below)?

ID ... Name ...
Address ... Country ...

etc. I have tried to add <tr>'s and <td>'s within the DetailsView to do
this, but it just causes errors.

Anybody know if this can be done, and if so how?

*** Sent via Developersdex http://www.developersdex.com ***

[clickon]

Just use Template fields, you could put every column repeated 15 times in one
row if you want. E.g.

<asp:DetailsVie w ID="dvwCustomer Details" runat="server"
DataSourceID="s dsCustomerDetai ls" AutoGenerateRow s="False">
<Fields>
<asp:TemplateFi eld HeaderText="Rou nd Number">
<ItemStyle CssClass="detai ls-view-cells" />
<HeaderStyle CssClass="detai ls-view-header" />
<ItemTemplate >
<asp:TextBox ID="txbRoundNum ber"
runat="server" Text='<%#Bind(" analysis_codes1 ") %>' MaxLength="10">

</asp:TextBox>
<asp:HiddenFiel d id="hdnPriceLis t"
runat="server" Value='<%#Bind( "price_list ") %>'>
</asp:HiddenField >
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Dri ver Number">
<ItemStyle CssClass="detai ls-view-cells" />
<HeaderStyle CssClass="detai ls-view-header" />
<ItemTemplate >
<asp:TextBox ID="txbDriverNu mber"
runat="server" Text='<%#Bind(" analysis_codes3 ") %>' MaxLength="10">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateFie ld>
</Fields>
</asp:DetailsView >

"Mike P" wrote:

The default format for the DetailsView control is for there to be a row
per field. Is it possible set it to show more than one column per row
(see below)?

ID ... Name ...
Address ... Country ...

etc. I have tried to add <tr>'s and <td>'s within the DetailsView to do
this, but it just causes errors.

Anybody know if this can be done, and if so how?

*** Sent via Developersdex http://www.developersdex.com ***

[Mike P]

Hi,

I am using Template fields, but it seems that they are automatically put
on different rows :

<asp:DetailsVie w ID="DetailsView 1" runat="server"
DataSourceID="S qlDataSource1"
DataKeyNames="O pportunityID"
AutoGenerateRow s="False">
<Fields>
<asp:BoundFie ld HeaderText="ID"
DataField="Oppo rtunityID" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:TemplateFi eld HeaderText="Pro duct Type"
SortExpression= "ProductTyp e">
<ItemTemplate >
<asp:Label ID="lblProductT ype"
Text='<%# Eval("ProductTy pe") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st
ID="ddlProductT ype" runat="server" DataSourceID="S qlDataSource2"

DataTextField=" ProductType" DataValueField= "ProductTyp eID"
SelectedValue=' <%#
Bind("ProductTy peID") %>'></asp:DropDownLis t>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Opp ortunity
Type" SortExpression= "OpportunityTyp e">
<ItemTemplate >
<asp:Label ID="lblOpportun ityType"
Text='<%# Eval("Opportuni tyType") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="ddlOpportun ityType"
DataSourceID="S qlDataSource3" Runat="Server"
DataTextField=" OpportunityType "
DataValueField= "OpportunityTyp eID" SelectedValue=' <%#
Bind("Opportuni tyTypeID") %>'/>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Val ue (£)"
SortExpression= "MonetaryValue" >
<ItemTemplate >
<asp:Label ID="lblValue" Text='<%#
Eval("MonetaryV alue") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtValue" Text='<%#
Bind("MonetaryV alue") %>' runat="server"> </asp:TextBox>
<asp:RequiredFi eldValidator
ID="RequiredFie ldValidator1" runat="server"
ControlToValida te="txtValue"
Display="None" ErrorMessage="P lease enter a Value" />
<asp:RangeValid ator ID="RangeValida tor1"
runat="server"
ControlToValida te="txtValue"
Type="Double" MaximumValue="4 000000"
MinimumValue="0 " Display="None"
ErrorMessage="V alue must be numeric" />
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Des cription"
SortExpression= "Descriptio n">
<ItemTemplate >
<asp:Label ID="lblDescript ion" Text='<%#
Eval("Descripti on") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtDescript ion"
Text='<%# Bind("Descripti on") %>' runat="server"
TextMode="Multi Line" Rows="10"
Columns="50"></asp:TextBox>
<asp:RequiredFi eldValidator
ID="RequiredFie ldValidator2" runat="server"
ControlToValida te="txtDescript ion"
Display="None" ErrorMessage="P lease enter a Description" />
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Pro bability
(%)" SortExpression= "Probabilit y" >
<ItemTemplate >
<asp:Label ID="lblProbabil ity" Text='<%#
Eval("Probabili ty") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="ddlProbabil ity"
DataSourceID="S qlDataSource4" Runat="Server"
DataTextField=" Probability"
DataValueField= "Probabilit yID" SelectedValue=' <%# Bind("Probabili tyID")
%>'/>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Loc ation"
SortExpression= "Location">
<ItemTemplate >
<asp:Label ID="lblLocation " Text='<%#
Eval("Location" ) %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtLocation " Text='<%#
Bind("Location" ) %>' runat="server"> </asp:TextBox>
<asp:RequiredFi eldValidator
ID="RequiredFie ldValidator3" runat="server"
ControlToValida te="txtLocation "
Display="None" ErrorMessage="P lease enter a Location" />
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:BoundFie ld HeaderText="Com pany Name"
DataField="Comp anyName" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:BoundFie ld HeaderText="Dat e Created"
DataField="Date Created" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:TemplateFi eld HeaderText="Sta tus"
SortExpression= "OpportunitySta tus">
<ItemTemplate >
<asp:Label ID="lblOpportun ityStatus"
Text='<%# Eval("Opportuni tyStatus") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st
id="ddlOpportun ityStatus" DataSourceID="S qlDataSource5" Runat="Server"
DataTextField=" OpportunityStat us"
DataValueField= "OpportunitySta tusID" SelectedValue=' <%#
Bind("Opportuni tyStatusID") %>'/>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:BoundFie ld HeaderText="Dat e Won/Lost"
DataField="Date WonOrLost" NullDisplayText ="N/A" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:CommandFie ld ShowEditButton= "True"
ButtonType="Ima ge" EditImageUrl="~/Images/btnEdit.jpg"
CancelImageUrl= "~/Images/btnCancel.jpg"
UpdateImageUrl= "~/Images/btnUpdate.jpg" >
<ItemStyle Height="10px" />
</asp:CommandFiel d>

</Fields>
</asp:DetailsView >
*** Sent via Developersdex http://www.developersdex.com ***

[clickon]

Yes but there is nothing stopping you putting whatever you want within
however many or few template fierlds as you want. The markup below looks
like what gets generated when you turn BoundFields into TemplateFields. Now
edit it to be how you want it. If you want two items in one template field
simply cut and paste the contents of each ItemTemplate, UpdateTemplate and
InsertTemplate from one templatefield to another and delete the extra
templatefield. The dta is bound to the controls within the templatefield,
the templatefield it's self is just a container and does not have any data
bound to it.

"Mike P" wrote:

Hi,

I am using Template fields, but it seems that they are automatically put
on different rows :

<asp:DetailsVie w ID="DetailsView 1" runat="server"
DataSourceID="S qlDataSource1"
DataKeyNames="O pportunityID"
AutoGenerateRow s="False">
<Fields>
<asp:BoundFie ld HeaderText="ID"
DataField="Oppo rtunityID" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:TemplateFi eld HeaderText="Pro duct Type"
SortExpression= "ProductTyp e">
<ItemTemplate >
<asp:Label ID="lblProductT ype"
Text='<%# Eval("ProductTy pe") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st
ID="ddlProductT ype" runat="server" DataSourceID="S qlDataSource2"

DataTextField=" ProductType" DataValueField= "ProductTyp eID"
SelectedValue=' <%#
Bind("ProductTy peID") %>'></asp:DropDownLis t>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Opp ortunity
Type" SortExpression= "OpportunityTyp e">
<ItemTemplate >
<asp:Label ID="lblOpportun ityType"
Text='<%# Eval("Opportuni tyType") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="ddlOpportun ityType"
DataSourceID="S qlDataSource3" Runat="Server"
DataTextField=" OpportunityType "
DataValueField= "OpportunityTyp eID" SelectedValue=' <%#
Bind("Opportuni tyTypeID") %>'/>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Val ue (#)"
SortExpression= "MonetaryValue" >
<ItemTemplate >
<asp:Label ID="lblValue" Text='<%#
Eval("MonetaryV alue") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtValue" Text='<%#
Bind("MonetaryV alue") %>' runat="server"> </asp:TextBox>
<asp:RequiredFi eldValidator
ID="RequiredFie ldValidator1" runat="server"
ControlToValida te="txtValue"
Display="None" ErrorMessage="P lease enter a Value" />
<asp:RangeValid ator ID="RangeValida tor1"
runat="server"
ControlToValida te="txtValue"
Type="Double" MaximumValue="4 000000"
MinimumValue="0 " Display="None"
ErrorMessage="V alue must be numeric" />
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Des cription"
SortExpression= "Descriptio n">
<ItemTemplate >
<asp:Label ID="lblDescript ion" Text='<%#
Eval("Descripti on") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtDescript ion"
Text='<%# Bind("Descripti on") %>' runat="server"
TextMode="Multi Line" Rows="10"
Columns="50"></asp:TextBox>
<asp:RequiredFi eldValidator
ID="RequiredFie ldValidator2" runat="server"
ControlToValida te="txtDescript ion"
Display="None" ErrorMessage="P lease enter a Description" />
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Pro bability
(%)" SortExpression= "Probabilit y" >
<ItemTemplate >
<asp:Label ID="lblProbabil ity" Text='<%#
Eval("Probabili ty") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="ddlProbabil ity"
DataSourceID="S qlDataSource4" Runat="Server"
DataTextField=" Probability"
DataValueField= "Probabilit yID" SelectedValue=' <%# Bind("Probabili tyID")
%>'/>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:TemplateFi eld HeaderText="Loc ation"
SortExpression= "Location">
<ItemTemplate >
<asp:Label ID="lblLocation " Text='<%#
Eval("Location" ) %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtLocation " Text='<%#
Bind("Location" ) %>' runat="server"> </asp:TextBox>
<asp:RequiredFi eldValidator
ID="RequiredFie ldValidator3" runat="server"
ControlToValida te="txtLocation "
Display="None" ErrorMessage="P lease enter a Location" />
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:BoundFie ld HeaderText="Com pany Name"
DataField="Comp anyName" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:BoundFie ld HeaderText="Dat e Created"
DataField="Date Created" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:TemplateFi eld HeaderText="Sta tus"
SortExpression= "OpportunitySta tus">
<ItemTemplate >
<asp:Label ID="lblOpportun ityStatus"
Text='<%# Eval("Opportuni tyStatus") %>' Runat="Server" />
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st
id="ddlOpportun ityStatus" DataSourceID="S qlDataSource5" Runat="Server"
DataTextField=" OpportunityStat us"
DataValueField= "OpportunitySta tusID" SelectedValue=' <%#
Bind("Opportuni tyStatusID") %>'/>
</EditItemTemplat e>
<ItemStyle Height="24px" />
</asp:TemplateFie ld>

<asp:BoundFie ld HeaderText="Dat e Won/Lost"
DataField="Date WonOrLost" NullDisplayText ="N/A" ReadOnly="True" >
<ItemStyle Height="24px" />
</asp:BoundField>

<asp:CommandFie ld ShowEditButton= "True"
ButtonType="Ima ge" EditImageUrl="~/Images/btnEdit.jpg"
CancelImageUrl= "~/Images/btnCancel.jpg"
UpdateImageUrl= "~/Images/btnUpdate.jpg" >
<ItemStyle Height="10px" />
</asp:CommandFiel d>

</Fields>
</asp:DetailsView >
*** Sent via Developersdex http://www.developersdex.com ***

[Mike P]

How does this work if you have mixture of Bound Fields and Template
Fields, since you are not allowed to put Bound Fields within Template
Fields?

*** Sent via Developersdex http://www.developersdex.com ***

[clickon]

Boundfields are of faily limited use, i rarely use them at all. There is
never a circumstance where it would be usefull to put a boundfield inside a
templatefield. If you want the value from a bound field to be inside a
template field. simply delete the boundfield put another control in
itemtemplate, edittemplate and/or inserttemplate sections of the the
templatefield as apropraite. Then bind that control to the relevent column
within your table using the following syntax.

<asp:textbox id="MyTextBox" runat="server" text='<%#
Bind("FieldName ")%>'></asp:textbox>

Remember, BoundFields are just a quick way of displaying data from a
database, they are almost useless for updateing and inserting data and are of
only limited use for displaying data, as you have discovered.

"Mike P" wrote:

How does this work if you have mixture of Bound Fields and Template
Fields, since you are not allowed to put Bound Fields within Template
Fields?

*** Sent via Developersdex http://www.developersdex.com ***