how to store amount in a variable and perform calculation

Question

1.00/5 (3 votes)

See more:

select sum(amount) from table1 select sum(amt) from table 2
temp-> X temp-> Y

how to store the SUM to X and Y .

( Y - X )= -+Z
if
Z(amount) is in positive then( insert/update of data )
else
close connection
response("Budget Amount is less , cannot allow more transaction");

I am working in a project using ASP.Net (C#)

please help me with this problem

Posted 11-Sep-14 1:46am

10923679

Add a Solution

Comments

KaushalJB 11-Sep-14 7:52am

Its your homework right ?... Search how to develop CRUD operations in C#. You would get some guidance. Here we are not for providing logics or codes.

10923679 12-Sep-14 2:46am

You are not are to provide logics or code..
then how will help people here.. ??

this is not my homework .
i am working in a project ..
and i got stuck in this place..
anyway people out here.. helped me ..
and thanks to you as well for your guidance
"develop CRUD operations in C#."
have a nice day .

Nandakishore G N 11-Sep-14 10:18am

Paste, What have you done till now? and come back if needed with some guidance.

10923679 12-Sep-14 0:08am

okay thank you.. i have tried .. but i am getting on the value of x and y..

i am here to know that how should i do this in asp.net(c#) and backend is sql server .

if you can please help me with this.

3 solutions

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)

Kishore Pogaru · Accepted Answer · 2014-09-11T03:39:00

Solution 1

If you are writing thls logic in a stored procedure then you can create variables in T-SQL and assign the totals to the variables

SQL

select @x = sum(amount) from table1

Posted 11-Sep-14 3:39am

Kishore Pogaru

Comments

10923679 12-Sep-14 0:09am

alright.. i am not working in T-SQL.
i am using SQL Server.. if u can please tell me how to use this process in asp.net(c#) and backend is sql server .

/\jmot · Accepted Answer · 2014-09-11T07:46:00

Solution 2

SQL

set @z=0

set @x = select sum(isnull(amount,0)) from table1
set @y = select sum(isnull(amount,0)) from table2
set @z=@y-@x

id @z<0
begin
"Failed Result"
end

else
begin
"Success Result"
end

Posted 11-Sep-14 7:46am

/\jmot

Updated 11-Sep-14 8:23am

v2

Comments

10923679 12-Sep-14 0:09am

thank you.. let me try with this.

10923679 12-Sep-14 1:33am

it is not working....

/\jmot 12-Sep-14 1:42am

what's the error??

10923679 12-Sep-14 1:43am

There is insufficient result space to convert a money value to int.

10923679 12-Sep-14 1:47am

i want to perform this steps in Charp(ASP.net) backend sqlserver

variable = x, y, z, A;

x= total sum from table1

y total sum from table2

y-x=z(some amount )

if (Z>A)
{
then query =update/delete/ msg etc
}
else
response.write ("cant update.. amount is more..");
}
con.close();

can u tell me this in Charp (asp.net )

/\jmot 12-Sep-14 1:48am

declare all variable @x,@y,@z as decimal(18,2)

10923679 12-Sep-14 1:57am

declare @x decimal(18,2)
declare @y decimal(18,2)
declare @z decimal(18,2)
select @x= sum(amount) from table1
select @y= sum(amount) from table2

IF(@y<@x)
BEGIN
PRINT 'SO SOMETHING WHEN Y < X'
END
ELSE
BEGIN
PRINT 'SO SOMETHING WHEN Y > X'
END

this is working
but how to set Z=Y-X???

/\jmot 12-Sep-14 1:59am

use z=y-x

because left side of an assignment must be a variable..
then try..

10923679 12-Sep-14 2:02am

okay. so what should i try now...??

set z=y-x is not working even z=y-x .

any other thing which is right for this.

/\jmot 12-Sep-14 2:03am

My working Code..

decimal x = 212131;
decimal y = 24454545;
decimal z = 0;
decimal a = 1;
z = y - x;
if (z > a)
{
lblResult.Text = z.ToString();
}
else
{
lblResult.Text = "Not Working!";
}

10923679 12-Sep-14 2:07am

okay dude..

10923679 12-Sep-14 2:11am

decimal x = 212131;
decimal y = 24454545;
decimal z = 0;
decimal a = 1;
but this value i have to get from table(sql)
u have taken it directly...

....................
declare @x decimal(18,2)
declare @y decimal(18,2)
declare @z decimal(18,2)
declare @A decimal(18,2)
select @x= sum(amount) from table1
select @y= sum(amount) from table2
select @A=sum(amount) from table3

10923679 12-Sep-14 2:36am

Thank You so Much for your help..

i have done it..
it is working....

You made my day..

it is working perfectly

10923679 · Accepted Answer · 2014-09-11T20:41:00

try
{
SqlConnection con = new SqlConnection(con_str);
con.Open();

decimal z = 0;

SqlCommand cmd10 = new SqlCommand("select SUM(Amount) from table1", con);
decimal x = cmd10.ExecuteNonQuery();

SqlCommand cmd11 = new SqlCommand("select SUM(Amount) from table2 ", con);
decimal y = cmd11.ExecuteNonQuery();

SqlCommand cmd12 = new SqlCommand("select SUM(Amount) from table3 ", con);
decimal a = cmd12.ExecuteNonQuery();

z = y - x;
if (z > a)
{
Label2.Text = "Rs."+z.ToString();

SqlCommand cmd3 = new SqlCommand("update query ", con);
int l = cmd3.ExecuteNonQuery();
Response.Write("Record is updated");
}
else
{
Label2.Text = "Not Working!";
}
con.Close();

}
catch (Exception ex)
{
Response.Write(ex.Message);

}
finally
{

}

how to store amount in a variable and perform calculation

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us