How to calculate and show the leave balance and display it when user logs in ASP.Net

Provide your database structue and details

You should have the column with the name "AvailableLeave" in the table in the database.

Whenever the employee log in and apply for the leave and submit , just decrease the value of that column to one and just show the same column value as available leave balance.

Hope this may help u

thank u krish

fname varchar (40)

lname varchar(40)

noofdays int(30)

reason varchar(1000)

from datetime

to datetime

balanceleave int(20)

can u write one query for this?