How can I build a web app that sends email alerts with saved search results in ASP.NET and SQL Server?

use sql query: xp_sendmail and populate the parameter @query with the desired select sentence. It sends an e-mail message with the resultset attached. Look up sql books-online