Solved

Entity Framework question  Part 3, asp.net

Posted on 2014-11-29
3
248 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 63

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 63

Accepted Solution

by:
Fernando Soto earned 500 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

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…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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