<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test_sql_ds_param2.aspx.cs" Inherits="test_sql_ds_param2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Test 2 - Paramètres</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
        </asp:GridView>
        <br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:bancaConnectionString %>"
            SelectCommand="SELECT * FROM [compte] where [solde]>@solde" CacheDuration="30" CacheExpirationPolicy="Sliding">
            <SelectParameters>
            <asp:Parameter Name="solde" Type="Int32" DefaultValue="30" />
            </SelectParameters>            
            </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
