Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Entity Framework question  Part 3, asp.net

Posted on 2014-11-29
3
Medium Priority
?
262 Views
Last Modified: 2014-12-09
I am trying to replace SoftwareID (under Title column) with tblSoftware.Title. Likewise, put tblSoftware.UnitPrice in this field (temporarily it is showing the value from Quantity field). Lastly, have a calculated field S. Total (Quantity * UnitPrice).

If this was a single gridview, I would cycle through the gv and multiply Quantity * UnitPrice values and place it in S. Total. But here the situation is different. We have three nested grid view which makes it a bit complicated.

Question: How to pull Title and UntiPrices from tblSowtware (using EF); and adding S. Total calculated field?

FYI: The project solution (EF_YouTube.zip about 1.1 MB with db file in it is at:  https://onedrive.live.com/?cid=420CDD6A13807C9B&id=420CDD6A13807C9B%21116 for additional information. It is developed in vs2012 and uses SQLEXPRESS12) EF7EF6
0
Comment
Question by:Mike Eghtebas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 64

Expert Comment

by:Fernando Soto
ID: 40471823
Hi Mike;

When I download the above project it downloads the project from Part 2 so the extra column, Total Purchase, is not there. Can you upload the latest please.
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40471836
Sorry about that. I uploaded right one.

Mike
0
 
LVL 64

Accepted Solution

by:
Fernando Soto earned 2000 total points
ID: 40473030
Hi Mike;

I am looking at it but seeming I have not worked much with the EntityDataSource control I am finding it limiting. I can not see how to configure it to calculate the total column for you. I am thinking of some how getting a reference to the data context and calculate it that way but then I need to figure out how to fill the column.

You may want to place a Request For Attention and have EE send out some emails to others to see if they can help with this.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

609 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