Solved

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

Posted on 2008-10-15
3
545 Views
Last Modified: 2012-05-05
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
Comment
Question by:jumpstart0321
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
maXXXeE earned 250 total points
ID: 22729145
if your main purpose is to display, then you should use listView, since it will give better control over presentation
0
 
LVL 7

Expert Comment

by:maXXXeE
ID: 22729167
Sorry, I meant DataList not listView
you can specify RepeatDirection="Horizontal" , for horizontal alignment of data
0
 
LVL 1

Assisted Solution

by:ashishkaithi
ashishkaithi earned 250 total points
ID: 22729184
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now