Create the stored procedure on the server where the linked server is created. Access all the data from the linked server in the stored procedure. Call the stored procedure from asp.net.

If I have understood your question correctly this should do the trick.

Yash