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

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.
Daniel ChenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob LearnedCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kyle AbrahamsSenior .Net DeveloperCommented:
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
Daniel ChenAuthor Commented:
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
Kyle AbrahamsSenior .Net DeveloperCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.