<script runat="server">
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table border="0" cellpadding="0" cellspacing="0" style="font-size: 8pt; font-family: Verdana">
<caption>
<span>
<br />
<br />
<span style="font-size: 10pt"><span style="font-size: 12pt">
<span style="color: #af4945"><strong>
Ricerca il tuo immobile</strong></span><br />
</span>
<br />
</span>
</span>
</caption>
<tr>
<td style="width: 297px; height: 19px" align="center" contenteditable="false" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
tipo</td>
<td style="width: 154px; height: 19px" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
tipologia</td>
<td style="width: 345px; height: 19px" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
località</td>
<td style="width: 169px; height: 19px" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
prezzo massimo</td>
</tr>
<tr>
<td style="width: 297px; height: 22px;" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource1" DataTextField="TIPO" DataValueField="TIPO" AppendDataBoundItems="True">
<asp:ListItem Selected="True" Value="Tutti">Tutti</asp:ListItem>
</asp:DropDownList></td>
<td style="width: 154px; height: 22px;" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="AccessDataSource2" DataTextField="TIPOLOGIA" DataValueField="TIPOLOGIA">
</asp:DropDownList></td>
<td style="width: 345px; height: 22px;" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="AccessDataSource3" DataTextField="Località" DataValueField="Località">
</asp:DropDownList></td>
<td style="width: 169px; height: 22px;" align="center" valign="top" bordercolor="#ffffff" bordercolorlight="#ffffff">
<asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="AccessDataSource4" DataTextField="Prezzo_Massimo" DataValueField="Prezzo_Massimo">
</asp:DropDownList></td>
</tr>
</table>
<br />
<asp:Button ID="Button1" runat="server" Text="cerca" Width="110px" /> <br />
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataSourceID="AccessDataSource5" CellPadding="4" ForeColor="#333333" GridLines="None" DataKeyNames="IDImmobile" AllowSorting="True">
<Columns>
<asp:BoundField DataField="IDImmobile" HeaderText="IDImmobile" InsertVisible="False"
ReadOnly="True" SortExpression="IDImmobile" />
<asp:BoundField DataField="Tipo" HeaderText="Tipo" SortExpression="Tipo" />
<asp:BoundField DataField="Tipologia" HeaderText="Tipologia" SortExpression="Tipologia" />
<asp:BoundField DataField="Località" HeaderText="Località" SortExpression="Località" />
<asp:BoundField DataField="Comune" HeaderText="Comune" SortExpression="Comune" />
<asp:BoundField DataField="Prezzo" HeaderText="Prezzo" SortExpression="Prezzo" />
<asp:BoundField DataField="Metri_Quadri" HeaderText="Metri_Quadri" SortExpression="Metri_Quadri" />
<asp:HyperLinkField DataNavigateUrlFields="IDImmobile" DataNavigateUrlFormatString="~/public/VediImmobile.aspx?IDImmobile={0}"
DataTextFormatString="{0:c}" Text="Vedi" />
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" Font-Names="Verdana" Font-Size="X-Small"
ForeColor="White" />
<RowStyle BackColor="#FFE0C0" Font-Names="Verdana" Font-Size="Small" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFC0C0" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFE0C0" Font-Names="Verdana" Font-Size="Small" ForeColor="#333333"
HorizontalAlign="Center" />
<HeaderStyle BackColor="#AF4945" Font-Bold="True" Font-Names="Verdana" Font-Size="X-Small"
Font-Strikeout="False" Font-Underline="False" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<EmptyDataTemplate>
<span style="font-family: Verdana">
Nessun Immobile trovato per la tua ricerca<br />
<br />
<strong>NON HAI TROVATO QUELLO CHE CERCAVI ?!<br />
<br />
</strong><a href="richiestaimmobile.aspx"></href><span style="font-size: 10pt">richiedici l'immobile con le caratteristiche
che preferisci ti ricontatteremo non appena abbiamo qualcosa che fa al caso tuo.</span></span>
</EmptyDataTemplate>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/mdb-database/DomekImmobiliare.mdb" SelectCommand="SELECT [TIPO] FROM [TIPO]"></asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/mdb-database/DomekImmobiliare.mdb" SelectCommand="SELECT [TIPOLOGIA] FROM [TIPOLOGIA] ORDER BY [TIPOLOGIA]"></asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/mdb-database/DomekImmobiliare.mdb" SelectCommand="SELECT [Località] FROM [LOCALITA]"></asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/mdb-database/DomekImmobiliare.mdb" SelectCommand="SELECT [Prezzo Massimo] AS Prezzo_Massimo FROM [Prezzo Massimo]"></asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/mdb-database/DomekImmobiliare.mdb" SelectCommand="SELECT [IDImmobile], [Tipo], [Tipologia], [Località], [Comune], [Prezzo], [Metri Quadri] AS Metri_Quadri FROM [DomekImmobili] WHERE (([Tipo] = ?) AND ([Tipologia] = ?) AND ([Località] = ?) AND ([Prezzo] <= ?))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="Tipo" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="DropDownList2" Name="Tipologia" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="DropDownList3" Name="Località" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="DropDownList4" Name="Prezzo" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>
<asp:Label ID="Label1" runat="server"></asp:Label>
</asp:Content>
