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
538 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

809 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