calculating values from one database table and the textbox value

Question

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

Sudhakar Chaudhary · Answer

create database demo1 use demo1 create table leve(userId intmaxLeve intTotalTakenLeve int) insert into leve values(1102) insert into leve values(2106) insert into leve values(3102) insert into leve values(4109) insert into leve values(5105) insert into leve values(6102) insert into leve values(7101) 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