1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC = "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void changeRequete(object server, EventArgs e)
{
SqlDataSource1.SelectCommand = "Select Nom,Prénom,Nationalité from Auteur where Nom like '" + Nom2.Text + "%'order by Nom";
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title> Exemple 7 </title>
</head>
<body>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Server=info-simplet; Initial Catalog=bibli; uid=ETD; password=ETD"
SelectCommand="Select Nom,Prénom,Nationalité from Auteur order by Nom"
DataSourceMode="DataSet">
</asp:SqlDataSource>
<form id="form1" runat="server">
<asp:GridView ID="ListBox1" runat="server"
DataSourceID="SqlDataSource1"
DataTextField="Nom"
DataValueField="Nom"
AutoPostBack="False"
AllowPaging="True">
</asp:GridView>
<br />
<br />
Nom : <asp:TextBox ID="Nom2" runat="server" />
<asp:Button ID="Button1" Text="Envoi" OnClick="changeRequete" runat="server" />
</form>
</body>
</html> |
Partager