How to connect my web application with sms API?

I am developing web application using C#,ASP.net and MS sQl. now i want to connect with SMS API application.
i am going to hire or buy sms API code from the service provider. but how do i connect it with my application.
any one who knows this connection please show me? i just want to send sms alerts from web application to client everyholiday. so how do i do this? help me please

I think it will depends on the provider of your API if their API can connect to your ms sql database.

The API code will allow you to send SMS. You need to make sure that you can the use the API code in the language you're developing.