Solved

How to use LiveView in C# webform to display some fields vertically and some horizontally within in one table as a fill out form?

Posted on 2014-09-14
6
545 Views
Last Modified: 2014-10-16
I have a ListView (or GridView) draft table like this:


My SQL Server table has the following fields:

- UPC (bigint)
- Description (varchar)
- Promo_Type_AmountOrPercentage (varchar)
- Discount_Amount (float, decimal(2))
- Monthly_AdType (varchar)
- Weekly_AdType (varchar)
- Month_Number (int)
- Week_Number (int)

I need to enable the Edit function on this ListView (or GridView) for users to input the values of these 4 fields.
- Promo_Type_AmountOrPercentage (varchar)
- Discount_Amount (float, decimal(2))
- Monthly_AdType (varchar)
- Weekly_AdType (varchar)

Only the Month columns (Jan - Dec) can have the Monthly_AdType value;
and only the Week columns (1 - 52) can have the Weekly_AdType value.

The Promo_Type_AmountOrPercentage field only has two values (the dollar sign or percentage). User selects $ or % from the DropDownList.


The Monthly_AdType and Weekly_AdType also are in DropDownList.

Only the Discount Amount is as textbox for users to input the amount (in 2 decimals).

The headers highlighted in lightblue is vertial. The top headers are horizontal.

If more UPC numbers exist, there are more records displayed.

Questions:
1.
Is this kind of ListView (GridView) possible to create?

2.
Do I need to combine ListView and Repeater and JavaScript to accomplish?

3.
I know in the front-end HTML side, UPC and Description can be set to not editable. Are there any examples or references that have both vertical and horizontal headers in the same table?

Please let me know if more detail need to be provided.
Thanks.
0
Comment
Question by:Daniel Chen
  • 3
6 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 250 total points
ID: 40344026
You should be able to embed any control in a TemplateField, as in this example:

 <asp:TemplateField HeaderText="columnItems">
        <ItemTemplate>
            <asp:ListView ID="listOfItems" runat="server" DataSourceID="MyObjectDataSource >
                <ItemTemplate>
                    <asp:LinkButton ID="MyLinkButton" Runat="Server" Text='item'></asp:LinkButton>
                </ItemTemplate>
            </asp:ListView>
            <asp:ObjectDataSource ID="MyObjectDataSource" runat="server"   
                TypeName="MyTypeName.Whatever" SelectMethod="GetItems">
                <SelectParameters>
                    <asp:Parameter Name="requestId" Type="String" DefaultValue='<%# Eval("ID")'/>
                </SelectParameters>
            </asp:ObjectDataSource>
        </ItemTemplate>
    </asp:TemplateField>

Open in new window


and bind the ListView in the GridView_RowDataBound, as here:

if(e.Row.RowType != DataControlRowType.DataRow)
{
    return;
}

ListView listView = (ListView)e.Row.FindControl("listOfItems");
listView.DataSource = ??
listView.DataBind();

Open in new window

0
 
LVL 40

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 250 total points
ID: 40344124
there is an

<asp:GridView> control which can do what you're looking for.

Within the columns, using the template fields as TheLearnedOne suggested is the correct way to go.

No need for a repeater.

A horizontal header to me would just be an additional column.  You can use events like the onRowDatabound to set that column to whatever value you need it to be.

Feel free to ask more questions if you need further explanation.
0
 

Author Comment

by:Daniel Chen
ID: 40344228
Thank you for the long-awaited tips.
I'm still quite new in the ASP.NET area.
Could you provide a simple demo example (code and screenshot)?

I am under the trail 30-day account so please provide more detailed answers that can really help me solve my question.
so i may consider if it's really worth it to pay monthly fees to use this website.

a simple tutorial or example like this would be appreciated:
http://aspsnippets.com/Articles/Enable-Disable-ASPNet-Validator-Client-Side-Validation-using-JavaScript-or-jQuery.aspx
http://www.aspforums.net/Threads/197148/How-to-use-ConfirmButtonExtender-conditionally-in-aspnet/
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 40344250
Can you gives us more of an idea of what you're looking for?  

Even if you doodle up something in paint and post a clip we can better answer your question.

This shows you how to style the gridview for a more professional look and feel:

http://www.etechpulse.com/2013/08/asp-gridview-css-style-sample-user.html


and a good article on using template fields:
http://msdn.microsoft.com/en-us/library/bb288032.aspx
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 40368603
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

820 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