hi,
I stuck with one query in sp. In my aspx page one Text box named txtMoney and two buttons
btnAdd and btnLess 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 btnLess button it should be minus from total cash..
can any one help me to create sp..
thanks and regards..
column in tblCash
tblCash contains cCash column so i want to update this column while adding and less..can any one suggest me..
how to create stored procedure for this and call it to in aspx.cs page..can any one suggest me?
please help me..
Loading
Kunal VaishyaPosted May 8, 2012, 5:21 AM
first in your data base
Create Table tblCash
and Column Money
and after if you want to less amount then insert in - Value
and if want to add amount then insert in + Value
finally to get sum of Money so you can get it
In Data Base
Table tblCash
Column Money
Column Date
1.First you want to add 100 then insert 100
2.if you want to add 1200 then Insert 1200
3.if you want to less 200 then insert -200
if you want to current amount so you can get like this
Select Sum(Money ) from tblCash
You can also get the track record when you add or less and Which amount