ousainou ceesay

ousainou ceesay

  • NA
  • 29
  • 3.4k

Query the sum of row values in sqlite on with Xamarin

Aug 12 2019 9:38 AM
Hello guys. Am trying to the sum of row values of sqlite database. My sqlite table has a row called Amount. So what I want is to sum all the Amount values on the table. This is my code :
 
public async Task SumItemAsync()
{
var data = await db.ExecuteScalarAsync("SELECT SUM(Amount) FROM Spent");
return data;
}
but it.s giving me an error saying "the type arguments for method sqliteAsyncConnection.ExecuteScalarAsync(string, param object[]) cannot be infered from the usage. Try specifying the type argument explicitly" . Any help.
 

Answers (1)

6
Pavan Ramamurthy

Pavan Ramamurthy

  • 0
  • 1k
  • 355.3k
Sep 12 2013 5:14 AM
asp.net ofcourse............
0
Suthish Nair

Suthish Nair

  • 0
  • 30.5k
  • 7.2m
Sep 13 2013 7:39 AM
If your thread got resolved, please "Accept the thread as Answer", that helped you.
0
selva kumar

selva kumar

  • 0
  • 557
  • 190.4k
Sep 12 2013 10:37 AM
Asp.net Mvc....
0
Suthish Nair

Suthish Nair

  • 0
  • 30.5k
  • 7.2m
Sep 12 2013 9:50 AM
There are lots of tools and open sources available to develop a web site. You need to just choose one that fits you and start learning. First go through the basics of asp.net, oops, design patterns, WCF, sql server... Enough for a starter...
0
Jignesh Trivedi

Jignesh Trivedi

  • 0
  • 62.3k
  • 46m
Sep 12 2013 6:31 AM
hi,

I think, currently ASP.net MVC is very popular to develop web application. MVC application has its own benefit over traditional web forms application. MVC is also support TDD model and SoC (separation of concern ) so as per me it is better to go with MVC. 

Silver light is also a good technology.

0
Muralidharan Deenathayalan

Muralidharan Deenathayalan

  • 167
  • 10.9k
  • 2.5m
Sep 12 2013 6:07 AM
You should learn the following,

ASP.net - MVC - Web client
WCF - To expose services to your client apps like (ASP.net MVC, windows app etc)
Entit framework / ADO.net - Database access
Class Library - To create layer based projects.


0
Abhineet Srivastava

Abhineet Srivastava

  • 0
  • 890
  • 95.3k
Sep 5 2013 10:43 PM
Wpf- It's for Window based option.

Wcf--It's all about to provide Services.


You need to choose from silverlight & Mvc.