• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • Last Modified:

ASP.net 2.0 Custom formatting of results inside a FormView.

I'm doing a query such as the following:
SELECT TOP(3) ItemName FROM Items WHERE merchantCategory='Travel' ORDER BY NEWID()
to display inside a formview. I would like the results to display as follows:
Item1 | Item2 | Item3
However, they're automatically going to display like this inside the formview:
Item1
Item2
Item3
How do I custom format the results using the formview?
0
jumpstart0321
Asked:
jumpstart0321
  • 2
2 Solutions
 
maXXXeECommented:
if your main purpose is to display, then you should use listView, since it will give better control over presentation
0
 
maXXXeECommented:
Sorry, I meant DataList not listView
you can specify RepeatDirection="Horizontal" , for horizontal alignment of data
0
 
ashishkaithiCommented:
you can use it like this.
you shud knw abt HEADER_TEMPLATE and FOOTER_TEMPLATE

I m attaching the code.
U must convert form view into template mode .
By default Item template get displayed. I m attaching only that code .
It will make u'r FORMVIEW READONLY.
Let me know if u've any difficulty.
Regards
Ashish

<asp:FormView ID="FormView1" runat="server" DataSourceID="testFormView">
        <HeaderTemplate>
           <table ><th>USERNAME</th><th>ROLL</th>
        </HeaderTemplate> 
            <ItemTemplate>
             
                    <tr>
                        <td>
                            <asp:Label ID="UserNameLabel" runat="server" Text='<%# Bind("UserName") %>' />
                        </td>
                        <td>
                          
                            <asp:Label ID="UserIdLabel" runat="server" Text='<%# Bind("UserId") %>' />
                        </td>
                    </tr>
              
            </ItemTemplate>
          <FooterTemplate></table></FooterTemplate>
        </asp:FormView>
        <asp:SqlDataSource ID="testFormView" runat="server" 
            ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" 
            SelectCommand="SELECT [UserName], [UserId] FROM [Login]">
        </asp:SqlDataSource>

Open in new window

0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now