Create API that can connect to SQL Server and ASP.Net Pages

Vishal says:

can u show me a simple demo that how to create  API in .aspx page(i.e my .aspx page should be act as API) with c# language.This API  should access data from SQL server  and other .aspx  should be able to access it.plz provide solution :-( this is very imp for me

You can create a Web Service for that. But still that won't be accessible in SQL Server

Hi Vishal..........

You can create a library that u can use in both cs and aspx pages . In library you can use connection string from web config file.