Click here to Skip to main content
15,885,767 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
Hello everyone 
I have some problems in programming the following algorithm in ASP.NET which I’ll be so thankful anyone can help. 
I have a store procedure by the name of Sp_SumProblem  that takes@ S_date (Start Date), @F_date(Final Date) and a @personnel Code, as input variables and should print out type of foods and some bad factors of that particular food (For example Calorie, Fat, Salt etc.) as a number.
Example:
Food type          Problem                           Count
1                  Calorie                             5
2                  Salt                                6
3                  Calorie and Salt                    11
. 

In C#, I have two Text boxes that take a start and finish time and I should extract data from that store procedure at the meantime.

What I have tried:

I have programmed this store procedure by EDMX. Now, I am wondering how I can write down this values in C# and illustrate the percentage values in a Pie Chart (high charts). By percentage value, I mean the fraction of counts to total reserved food for every individual (extracted from another store procedure so-called Sp_Reservedfoodcount)
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900