Click here to Skip to main content
15,907,497 members

Comments by Murugesan22 (Top 49 by date)

Murugesan22 4-Jul-14 7:10am View    
Deleted
Try this

select Emp_code,isnull(BASIC,0) as BASIC,isnull(CNVAL,0) as CNVAL,isnull(DEPRE,0) as DEPRE,
isnull(HNBL,0) as HNBL,isnull(HRA,0) as HRA,isnull(INSNP,0) as INSNP,isnull(KAR,0) as KAR,
isnull(WMA,0) as WMA,isnull(WSAR,0) as WSAR,
(isnull(BASIC,0)+isnull(CNVAL,0)+isnull(DEPRE,0) +
isnull(HNBL,0)+isnull(HRA,0)+isnull(INSNP,0)+isnull(KAR,0) +
isnull(WMA,0) +isnull(WSAR,0)) as Total
from ( Select emp_code,element_Code,amount from CTC123 ) AS s PIVOT (sum(amount) for element_Code in (BASIC,CNVAL,DEPRE,HNBL,HRA,INSNP,KAR,WMA,WSAR)) AS d
Murugesan22 4-Jul-14 6:17am View    
You cant call response inside webmethod

Check here

http://stackoverflow.com/questions/17073362/cant-call-response-redirect-inside-a-static-method
Murugesan22 3-Jul-14 5:58am View    
google not help you?
Murugesan22 3-Jul-14 5:46am View    
Please check with b.loanAmount/b.term datatypes
If any varchar datatype means you have convert to datatype which you want
Murugesan22 3-Jul-14 5:35am View    
try this, If i am not wrong

Can you please add form load event in if(!ispostback)

Because everytime load form means it give countryid is zero thats why you cant get correct value in state

I will you post same content with ispostback option