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