how to Add and minus values?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

hi,

I stuck with one query in sp. In my aspx page one Text box named txtMoney and two buttons
btnAdd and btnUpdate this records is saving to tblCash.

think cash is 10000 i mean sample..while adding 5000 then it should add to that remaining amount 10000+5000=15000.it should update if i click btnadd button..and update button is to less amount from tblCash table so whenever i place some money and if i click btnupdate button it should be minus from total cash..

can any one help me to create sp..
thanks and regards..

i forgot to mention column in tblCash
tblCash contains cCash column so i want to update this column while adding and less..can any one suggest me..

or can any one suggest me to create simple query..
like in update tblCash(cCash)values(@Cash//so here wat have to give i mean mathematic query to add for same colum i mean update)

@Mohd Wasif how to call in aspx.cs page..i gave query like this

protected void btnAdd_Click(object sender, EventArgs e)
   {

       txtAmount.Text = "";

       SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["dbConnection"].ToString());
       con.Open();
       //SqlCommand cmd = new SqlCommand("Update tblCash set cCash=cCash+@Cash where cID=@ID");
       SqlCommand cmd = new SqlCommand();
       cmd.Connection = con;
       cmd.CommandType = CommandType.StoredProcedure;
       cmd.CommandText = "usp_InsertUpdateRecord";

       SqlParameter cash=new SqlParameter("@Cash",SqlDbType.Decimal);
       cash.Value =txtAmount.Text;
       cmd.Parameters.Add(cash);


       cmd.ExecuteNonQuery();

      lblMessage.Text = "Amount Added";
      txtAmount.Text = "";
      lblMessage.Text = "";
      con.Close();
      cmd.Dispose();

   }

but am Getting Error like Failed to convert parameter value from a String to a Decimal.
can u suggest me wat have to modify again..

Posted 2-May-12 19:47pm

ythisbug

Updated 7-May-12 23:04pm

v8

Add a Solution

Comments

Praveen Meghwal 3-May-12 1:58am

Does add/update functionality make separate entry in the table or they update an existing record.

ythisbug 3-May-12 2:52am

thanks for ur reply..
existing..in tblCash column name csCash..

Rahul Rajat Singh 3-May-12 2:53am

What have you tried so far?

ythisbug 3-May-12 2:59am

i knw updating query..but for numberic i don knw how to gv query..

ythisbug 9-May-12 2:06am

can any one help me.how to use this sp in aspx.cs page how to call .?

1 solution

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)

Mohd Wasif · Answer 1 · 2012-05-02T20:08:00

SQL

create proc my_sp_Insert_Update_Record
@status int,
@money numeric (18,2)
as
if(@status=1)
begin
update tblCash set Amount=Amount+@money
end
else if (@status=2)
begin
declare @balanceAmount numeric(18,2)
select @balanceAmount=Amount from tblCash
if(@money>@balanceAmount)
begin
Print 'You can not update amount as Balance amount is less than input Amount'
end
else
begin
update tblCash set Amount=Amount-@money
end
end

Pass @status=1 for insert and @status=2 for update.