ASP.net webservice with parameterized function or method (C#) and like clause in C# SQL Server

 https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/web-services-in-Asp-Net-C-Sharp/