hi i stuck with my query..
in my sql table contains tblCash
column name cCash and cDate
in aspx page
txtCash
btnAdd and btnLess
when i add cash it should add to cCash column and update with that remaining amoung..for example cash in cCash column is 5000 when i add 1000 and if i click btnadd it shuld add to tat column and update the record and like for less it should less from cCash column can any one suggest me how to give query..o stored procedure..
and this cash amount i want to add in another table
in tblCashUpdate with date and amount please help me..thank u
Loading

Kunal VaishyaPosted May 7, 2012, 2:32 AM
cCash
cDate
Alway insert in table no need to update
when you want to increase then insert + Value Like +5000
when you want to decrease then insert - Value Like -5000
Get Sum in to get final amount of cCash