hi friends ,
i have created one windows form for leaves in this i have taken two textboxes and one for number of leaves taken and one for leaves left for you, in this i have to take data from database table that have column (maximum leaves) which i had you used it in another form textbox(maximum leaves) having for different leave types(textbox). And i have to calculate maximum leaves - (minus) number of leaves, that should give reaming leaves which you had left, when i select leave type and entering number of leaves it should calculate maximum leaves - number of leaves (which i entered). please give some suggestion how to do.
thanks
Loading
Sudhakar ChaudharyPosted Jul 25, 2012, 8:36 AM
use demo1
create table leve(userId int,maxLeve int,TotalTakenLeve int)
insert into leve values(1,10,2)
insert into leve values(2,10,6)
insert into leve values(3,10,2)
insert into leve values(4,10,9)
insert into leve values(5,10,5)
insert into leve values(6,10,2)
insert into leve values(7,10,1)
select * from leve
--get maximum leve
select maxleve from leve where userid='1'
--get remaining leve
select (maxLeve-(TotalTakenLeve+Textbox.text))as remainingLeve from leve where userid='1'--textbox.text is no of day given from Winform
--for example textbox.text=2 then
select (maxLeve-(TotalTakenLeve+2)) as remainingLeve from leve where userid='1'
--result remaining leve is::::: 6
--if result is 0 then there are no leve for give user or employee