Fórum Duvidas Relativo á aula XI do curso #5863

Olá Fabio Galante - Boa Tarde      Como eu não estou recebendo as categorias em produtos via webusercontrol Menu.asxc e sim via dropdownlist dentro da pagina de Produtos do meu front end gostaria de saber como usar corretamente a diretiva do CacheDependency já que a coloquei desta forma direto na pagina, já que não usarei o controle mas o dropdownlist e deu o erro citado mais abaixo   Aqui o Source da Pagina produtos.aspx do frontend   <%@ Page Language="C#" MasterPageFile="~/Home.master" AutoEventWireup="true" CodeFile="produtos.aspx.cs" Inherits="produtos" Title="Untitled Page" ViewStateEncryptionMode="Always" EnableViewStateMac="true" ValidateRequest="true" %> <%@ OutputCache Duration="99999" Shared="true" VaryByParam="CategoryID" SqlDependency="WebProdutos:dev_Categories" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentCenter" Runat="Server"> <asp:DropDownList ID="ddlCategorias" runat="server" DataSourceID="dsCategory" DataTextField="Title" DataValueField="CategoryID" AutoPostBack="True"> </asp:DropDownList> <asp:ObjectDataSource ID="dsCategory" runat="server" OldValuesParameterFormatString="original_" SelectMethod="SelectCategory" TypeName="DevMedia.ECommerce.Category"></asp:ObjectDataSource> </asp:Content> Aqui o Erro apresentado ao executar a webapplication no VS2008   Error 13 A diretiva 'outputcache' não oferece suporte para o atributo 'shared' em uma página. D:\MEUSASPNETWEBSITES\VS2008\Store\produtos.aspx 3      Aqui a config de meu webconfig   <connectionStrings> <add name="StoreString" connectionString="Data Source=LUIZVIDEO\SQLEXPRESS;Initial Catalog=WebProdutos;Persist Security Info=True;User ID=userWebProdutos;Password=rolu27;" providerName="System.Data.SqlClient"/> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=LUIZVIDEO\SQLEXPRESS;Initial Catalog=WebProdutos;Persist Security Info=True;User ID=userWebProdutos;Password=rolu27;" providerName="System.Data.SqlClient"/> <!--<add name="StoreString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DevStore.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>--> <add connectionString="server=mysqlserver.com;database=mysqldatabase;user id=mysqlid;pwd=mysqlpwd" name="SimpleProviderConnectionString" providerName="MySql.Data.MySqlClient"/> </connectionStrings> <system.web> <!-- INCIO CONFIGS MYSQLSITEMAPPROVIDER --> <roleManager enabled="true"/> <authentication mode="Forms"/> <caching> <sqlCacheDependency enabled="true" pollTime="15000"> <databases> <add name="WebProdutos" connectionStringName="StoreString"/> </databases> </sqlCacheDependency> </caching> <siteMap defaultProvider="siteMapProvider" enabled="true"> <providers> <clear/> <add name="siteMapProvider" type="Simple.Providers.MySQL.MysqlSiteMapProvider" connectionStringName="SimpleProviderConnectionString" applicationName="WebProdutos" description="MySQL site map provider" securityTrimmingEnabled="true"/> </providers> </siteMap> <!-- FIM CONFIGS MYSQL SITEMAPPROVIDER --> Aqui as minhas SP atuais    SP - SelectAllCategory ALTER PROCEDURE [dbo].[dev_SelectAllCategory] ( @Grupo VarChar(150) ) AS SELECT CategoryID, Title FROM dbo.dev_Categories Where Grupo = @Grupo ORDER BY Title SET NOCOUNT ON RETURN SP CategorySelect   ALTER PROCEDURE [dbo].[dev_CategorySelect] ( @Id Int ) AS SELECT CategoryId, Grupo, Title FROM dev_Categories WHERE CategoryId = @Id   Que tem a haver com a pagina products ou produtos.aspx do frontend   E aqui a minha classe atual Category.cs     using System; using System.Data; using System.Configuration; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Web.Configuration; namespace DevMedia.ECommerce { /// <summary> /// Representa a Categoria de um Produto ou Servio /// e contem mtodos para trabalhar com a Categoria /// </summary> [System.ComponentModel.DataObject] public class Category { private static readonly string _connectionString; private int _id; //private string _grupo; private string _title; public int CategoryID { get { return _id; } set { _id = value; } } //public string Grupo ///{ //get { return _grupo; } //set { _grupo = value; } /// } public string Title { get { return _title; } set { _title = value; } } static Category() { _connectionString = WebConfigurationManager.ConnectionStrings["StoreString"].ConnectionString; } public Category(SqlDataReader reader) { _id = (int)reader["CategoryID"]; //_grupo = (string)reader["Grupo"]; _title = (string)reader["Title"]; } /// <summary> /// Seleciona Todas as Categorias do Banco de Dados /// </summary> /// <returns></returns> [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select,true)] public static List<Category> SelectCategory() { string Grupo = HttpContext.Current.Request.QueryString["sessao"]; //Inicializar Comando SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("dev_SelectAllCategory", con); cmd.CommandType = CommandType.StoredProcedure; //Initialize parameters cmd.Parameters.AddWithValue("@Grupo", Grupo); List<Category> results = new List<Category>(); using (con) { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { results.Add(new Category(reader)); } con.Close(); return results; } } /// <summary> /// Seleciona Todas as Categorias do Banco de Dados /// Baseado na SubSessao em Servios /// </summary> /// <returns></returns> [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select, false)] public static List<Category> Services() { string Grupo = HttpContext.Current.Request.QueryString["subsessao"]; //Inicializar Comando SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("dev_SelectAllCategory", con); cmd.CommandType = CommandType.StoredProcedure; //Initialize parameters cmd.Parameters.AddWithValue("@Grupo", Grupo); List<Category> results = new List<Category>(); using (con) { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { results.Add(new Category(reader)); } con.Close(); return results; } } /// <summary> /// Seleciona uma Categoria por Category ID /// </summary> /// <param name="CategoryID"></param> /// <returns></returns> [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)] public static Category SelecById(int CategoryID) { //Inicializar o Command SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("dev_CategorySelect", con); cmd.CommandType = CommandType.StoredProcedure; //Inicializar Parameters p/ Evitar SqlInjection cmd.Parameters.AddWithValue("@Id", CategoryID); //Criar Variavel para Retorno de Resultados Category result = null; using (con) { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) result = new Category(reader); } con.Close(); return result; }//<summary> //Create a new category //</summary> //<param name="parentId"></param> [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)] public static void Insert(string grupo, string title) { //Initialize command SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("dev_CategoryInsert ", con); cmd.CommandType = CommandType.StoredProcedure; //Initialize parameters cmd.Parameters.AddWithValue("@Grupo", grupo); cmd.Parameters.AddWithValue("@Title", title); using (con) { con.Open(); cmd.ExecuteNonQuery(); } con.Close(); } /// <summary> /// Update numa CategoryID Existente /// </summary> /// <param name="CategoryId"></param> /// <param name="Title"></param> [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)] public static void Update(int CategoryId, string Title) { //Inicializar o Command SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("dev_CategoryUpdate", con); cmd.CommandType = CommandType.StoredProcedure; //Inicializar Parameters p/ Evitar SqlInjection cmd.Parameters.AddWithValue("@Id", CategoryId); cmd.Parameters.AddWithValue("@Title", Title); using (con) { con.Open(); cmd.ExecuteNonQuery(); } con.Close(); } /// <summary> /// Delete a category /// </summary> [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)] public static void DeleteCat(int CategoryId) { // Initialize command SqlConnection con = new SqlConnection(_connectionString); SqlCommand cmd = new SqlCommand("dev_CategoryDelete", con); cmd.CommandType = CommandType.StoredProcedure; // Initialize parameters cmd.Parameters.AddWithValue("@CategoryId", CategoryId); using (con) { con.Open(); cmd.ExecuteNonQuery(); } } } } Fico no aguardo e desde já agradeço para saber  como eu teria que adaptar e resolver este erro da diretiva Shared na pagina produtos.aspx