how can i add values which is present in a var type variable

Question

0.00/5 (No votes)

See more:

var prices= from st in obj.Wishlist_tables
join X in obj.movie_details on st.movie_id equals X.Id
where st.username == Session["user"].ToString()
select new { X.price }
now i have some prices of some products and i want to add them and want to show in a label

Posted 16-Sep-13 20:29pm

Omprakash Kukana

Add a Solution

Comments

Harshil_Raval 17-Sep-13 2:41am

Just cast it to integer and add other prices to it, and display in label. What problem you face here?

Omprakash Kukana 17-Sep-13 2:45am

int x = prices.Count();

foreach(var objdata1 in prices)
{
int[] ary = new int[x];
for (int i = 0; i < x ; i++ )
{
ary[i] = convert.toint32(objdata);
}

Omprakash Kukana 17-Sep-13 2:48am

and this erroe is ngenerting
Unable to cast object of type '<>f__AnonymousType2`1[System.Nullable`1[System.Int32]]' to type 'System.IConvertible'.

Harshil_Raval 17-Sep-13 2:51am

So, here numb is list of integer. Right? You want to count these numbers?

Omprakash Kukana 17-Sep-13 2:53am

i update there is not numb where is prices which is having the values from linq query and now i want to add these prices to find out total price

Harshil_Raval 17-Sep-13 3:01am

Hi, try this,
var prices= from st in obj.Wishlist_tables
join X in obj.movie_details on st.movie_id equals X.Id
where st.username == Session["user"].ToString()
select new { X.price }.DefaultIfEmpty();

And your rest of code.

Harshil_Raval 17-Sep-13 3:03am

int count=0;
foreach(var objdata1 in prices) {
count+=Convert.ToInt32(objdata1);
}

Omprakash Kukana 17-Sep-13 3:23am

this error is generating
Unable to cast object of type '<>f__AnonymousType2`1[System.Nullable`1[System.Int32]]' to type 'System.IConvertible'.
at here
count += Convert.ToInt32(objdata1);

Harshil_Raval 17-Sep-13 3:36am

OK, try to change your linq query to this,
var prices= from st in obj.Wishlist_tables
join X in obj.movie_details on st.movie_id equals X.Id
where st.username == Session["user"].ToString()
select X.price;

And then count it..
int count=0;
foreach(var objdata1 in prices)
{
count+=Convert.ToInt32(objdata1);
}

Harshil_Raval 17-Sep-13 3:39am

I am posting it to answers. Check it..

CodeBlack 17-Sep-13 3:02am

Let me make my self clear : in your prices variable you have list of prices in string datatype and you want to convert it in int datatype right ?

Omprakash Kukana 17-Sep-13 3:16am

no i want to add values which is present in prices var type variable as u can do u can either u can add them by put in array and thenm u can add them or u can directly add the values of var type variable

3 solutions

Solution 1

basically var is new keyword which compiler set at run time. so it depened wht you are expecting that var to be. If you are expecting var as list you can use the normal syntax used for list and can add value to that.
-SG

Posted 16-Sep-13 21:00pm

Singh Gyan

Comments

Omprakash Kukana 17-Sep-13 3:09am

how can i add values of var type variable i put brakpoint and checked then i found that here is two values in a var type variable prices now i want to add them

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Harshil_Raval · Accepted Answer · 2013-09-16T21:40:00

Solution 3

OK,
try to change your linq query to this,

C#

var prices= from st in obj.Wishlist_tables 
            join X in obj.movie_details on st.movie_id equals X.Id 
            where st.username == Session["user"].ToString() 
            select X.price; 

And then count it.. 

int count=0; 
foreach(var objdata1 in prices) 
{ 
    count+=Convert.ToInt32(objdata1); 
}

or

count = prices.Sum();

Hope it helps you..

Posted 16-Sep-13 21:40pm

Harshil_Raval

Updated 16-Sep-13 21:43pm

v2

Comments

Omprakash Kukana 17-Sep-13 3:54am

yues its working 10nx mr. Harshil_raval

JOE Heart Under Blade 17-Sep-13 4:16am

the reason why my vote of 5 is...
this is what i m looking for....tq.

Ashishmau · Accepted Answer · 2013-09-16T21:04:00

Solution 2

do this

int totalPrices = prices.Sum();

Posted 16-Sep-13 21:04pm

Ashishmau

Comments

Omprakash Kukana 17-Sep-13 3:14am

not working error:
AnonymousType#1[]' does not contain a definition for 'Sum' and the best extension method overload 'System.Linq.Queryable.Sum(System.Linq.IQueryable<int>)' has some invalid arguments