playerservice.cs

ASP.NET2.0(C#篇)经典教程的源码...本源码很好的实现了购物车....编码规范和类的设计具有很好的借鉴性！

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

[WebService(Namespace = "http://wroxunited.net/"), 
 WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class PlayerService : WebService
{
  [WebMethod]
  public DataSet Players()
  {
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WroxUnited"].ConnectionString);
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT PlayerID, (FirstName + ' ' + LastName) As Player FROM Players ORDER BY FirstName, LastName", conn);
    DataSet ds = new DataSet();
    adapter.Fill(ds, "Players");
    return ds;
  } 
}