hvordan tester jeg om sql server 2005 notification fungerer
HejJeg bøvler lidt med at få den nye funktion med notification til at fungere.
Jeg har lavet en lille test. men hvordan kan jeg viser om den henter data fra databasen eller fra cashen?
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="galleriID"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="galleriID" HeaderText="galleriID" ReadOnly="True" SortExpression="galleriID" />
<asp:BoundField DataField="galleriName" HeaderText="galleriName" SortExpression="galleriName" />
<asp:BoundField DataField="galleriMessage" HeaderText="galleriMessage" SortExpression="galleriMessage" />
<asp:CheckBoxField DataField="galleriPublic" HeaderText="galleriPublic" SortExpression="galleriPublic" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" EnableCaching="true" SqlCacheDependency="CommandNotification" CacheDuration="Infinite" runat="server" ConnectionString="<%$ ConnectionStrings:edtwodthdkConnectionString1 %>"
DeleteCommand="DELETE FROM [cms_galleri] WHERE [galleriID] = @galleriID" InsertCommand="INSERT INTO [cms_galleri] ([galleriName], [galleriMessage], [galleriPublic]) VALUES (@galleriName, @galleriMessage, @galleriPublic)"
ProviderName="<%$ ConnectionStrings:edtwodthdkConnectionString1.ProviderName %>"
SelectCommand="SELECT [galleriID], [galleriName], [galleriMessage], [galleriPublic] FROM [cms_galleri]"
UpdateCommand="UPDATE [cms_galleri] SET [galleriName] = @galleriName, [galleriMessage] = @galleriMessage, [galleriPublic] = @galleriPublic WHERE [galleriID] = @galleriID">
<InsertParameters>
<asp:Parameter Name="galleriName" Type="String" />
<asp:Parameter Name="galleriMessage" Type="String" />
<asp:Parameter Name="galleriPublic" Type="Boolean" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="galleriName" Type="String" />
<asp:Parameter Name="galleriMessage" Type="String" />
<asp:Parameter Name="galleriPublic" Type="Boolean" />
<asp:Parameter Name="galleriID" Type="Int32" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="galleriID" Type="Int32" />
</DeleteParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
