<%@ WebService Class="FeaturedService" Language="C#" %>

using System;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;

[WebService( Namespace="http://yourdomain.com/webservices" )]
public class FeaturedService : WebService {
	[WebMethod] 
	public string GetFeatured() {
		string strSelect;
		SqlConnection conPubs;
		SqlDataAdapter dadPubs;
		DataSet dstTitles;
		DataRow drowTitle;
		Random objRanNum;
		int intRanNum;
		
		strSelect = "SELECT Title, isNull( Notes, '' ) Notes From Titles";
		conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Pubs" );
		dadPubs = new SqlDataAdapter( strSelect, conPubs );
		dstTitles = new DataSet();
		dadPubs.Fill( dstTitles, "Titles" );
		objRanNum = new Random();
		intRanNum = objRanNum.Next( 0, dstTitles.Tables["Titles"].Rows.Count );
		drowTitle = dstTitles.Tables["Titles"].Rows[intRanNum];
		return drowTitle["Title"] + " - " + drowTitle["Notes"];
	}
}