Adding the values of one fields and display in a textbox

Question

i want to add up the total calls made my "Local" call type. So 20+1 = 21 for total calls made locally and i want to display the result in a textbox or whatever. can anybody help me how to do this as i m very begineer with the coding.

Answer 1

Have a look at this post, Michael shows you how to do what you are looking for. (http://lightswitchhelpwebsite.com/Blog/tabid/61/EntryId/17/It-Is-Easy-To-Display-Counts-And-Percentages-In-LightSwitch.aspx)

Answer 2

Hi glen, example is in C# but i am building my application in visual basic.  I could not understand it as it was slightly harder for me . Any other suggestions?

Thanks

Answer 3

Follow this link to convert the code to vb.

http://www.developerfusion.com/tools/convert/vb-to-csharp/

Answer 4

This wont help because my application is quite big, i dont know what to do now. I just need to know how i can add up the values of one field together...

Answer 5

If you take michaels code and drop it into the app it will convert it so you can see what it looks like in VB. You do not need to drop the complete file, the app will take code snippets.

Answer 6

I tried doing it but my count of calls are showing as 0.

Here is my code :

Public

Class LocalDetails

 

 

Private Sub LocalDetails_InitializeDataWorkspace(saveChangesTo As System.Collections.Generic.List(Of Microsoft.LightSwitch.IDataService))

' Write your code here.

Dim Calls As Double = LocalDetailsAll.Count()

CountOfCalls = Calls.ToString()

End Sub

End Class

Answer 7

Answer 8

I might suggest you look at using a View in SQL Server to do this as the calculation isn't complex but the selection criteria are. It looks like you're trying to calculate a phone bill by employee, call type and some time period (probably a month). You won't naturally have any database table for this combination so you'll have to invent one. A SQL Server View would be a good way to do this. You can then import that view into your LightSwitch application to show it. A straightforward view would just give you a list of employee, call type, month, total cost which is not the presentation you want. You actually want to change the call type from rows to columns. Look at the SQL Server PIVOT command to do this.

---

Simon Jones
If you found this post helpful, please "Vote as Helpful". If it actually answered your question, please remember to "Mark as Answer". This will help other people find answers to their problems more quickly.

Answer 9

You dont need to use SQL for combining tables. I was having problem with this situation before but there is a way you can combine multiple tables. There was a little error in my code but it is working now. Thanks for your help Simon...Cheers