datacaching.asmx

东软内部材料（四）asp等相关的教学案例

<%@ WebService Language="C#" class="DataCachingExample" %>

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

public class DataCachingExample : WebService
{
  [WebMethod]
  public DataSet GetDataSet(string column)
  {
    Cache AppCache;

    AppCache = HttpContext.Current.Cache;

    if (AppCache[column] == null)
      AppCache[column] = LoadDataSet(column);

    return (DataSet)AppCache[column];
  }

  private DataSet LoadDataSet(string column)
  {
    SqlConnection myConnection;
    SqlDataAdapter myCommand;
    DataSet products;

    myConnection = new SqlConnection(ConfigurationSettings.AppSettings["DsnPubs"]);
    myCommand = new SqlDataAdapter("select " + column + " from Authors", myConnection);
    products = new DataSet();

    myCommand.Fill(products, "products");

    return products;
  }
}