<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Search the guitarist database by entering any keyword (first name, last name, performance title, playing style, rock , etc)
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br /><br />
<asp:Button ID="Button1" runat="server" Text="Submit Query" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [topguitarist] WHERE (([playername] LIKE '%' + @playername + '%') OR ([associatedacts] LIKE '%' + @associatedacts + '%') OR ([famousperformance] LIKE '%' + @famousperformance + '%') OR ([playerstyle] LIKE '%' + @playerstyle + '%'))">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="playername"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="associatedacts"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="famousperformance"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="playerstyle"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<br /><br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="guitaristid" DataSourceID="SqlDataSource1"
EmptyDataText="Sorry but no associated database records related to your query">
<Columns>
<asp:BoundField DataField="playername" HeaderText="playername"
SortExpression="playername" />
<asp:BoundField DataField="playerstyle" HeaderText="playerstyle"
SortExpression="playerstyle" />
<asp:BoundField DataField="associatedacts" HeaderText="associatedacts"
SortExpression="associatedacts" />
<asp:BoundField DataField="famousperformance" HeaderText="famousperformance"
SortExpression="famousperformance" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>