Consume C#.net web service through sql server store proc

thanks for your answer and it is working fine
but when  call svc service(wcf service)  it generate the error 500 internal server error post , please provide the solution

Hi Gaurav,

Please check following link once 
http://www.codeproject.com/Articles/428200/How-to-invoke-a-Web-Service-from-a-Stored-Procedur