Всем привет! Продолжим. Сегодня пойдёт речь о моём сайте недвижимости. См тут Моя золотая мечта 05.01.2025 и тут Недвижимость 02.05.2024. Короче хотел найти работу в Immowelt. Покажу не всё, а только часть.

Вот так отображается информация о недвижимости:

Details.aspx:

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" 
CodeFile="Details.aspx.cs" Inherits="Details" Title="Exposé" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
            <ul class="nav nav-tabs">
                <li class="active"><a href="#description" data-toggle="tab">Beschreibung</a></li>
                <li><a href="#contact" data-toggle="tab">Kontakt</a></li>
            </ul>
    <!-- Tab panes -->
    <div class="tab-content">
    <div class="tab-pane active" id="description">
    <asp:FormView ID="frmResult" runat="server" AllowPaging="false">
        <ItemTemplate>
            <img src="./immoimages/<%#Eval("ImageURL") %>" width="300px" height="200px" 
            class="img-rounded" />
            <br />
            <br />
                    <h3>Objektdaten</h3>
                    <table class="table">
                        <tr>
                            <td>Typ</td>
                            <td><%#Eval("WohnBez") %></td>
                        </tr>
                        <tr>
                            <td>PLZ</td>
                            <td><%#Eval("PLZ") %></td>
                        </tr>
                        <tr>
                            <td>Stadt</td>
                            <td><%#Eval("StadtBez") %></td>
                        </tr>
                        <tr>
                            <td>Etage</td>
                            <td><%#Eval("Etage") %></td>
                        </tr>
                        <tr>
                            <td>Anz. Zimmer</td>
                            <td><%#Eval("AnzZimmer") %></td>
                        </tr>
                        <tr>
                            <td>Fläche</td>
                            <td><%#Eval("Groesse") %></td>
                        </tr>
                        <tr>
                            <td>Preis</td>
                            <td><%#Eval("Preis", "{0:c}") %></td>
                        </tr>
                    </table>
                    <br />
                    <br />
                    <%#Eval("Beschreibung") %>              
        </ItemTemplate>
    </asp:FormView>
              </div>
              <div class="tab-pane" id="contact">
                  <label>Anrede:</label>
                  <br />
                  <asp:DropDownList ID="cboAnrede" runat="server" CssClass="form-control" Width="200px">
                    <asp:ListItem Text="Frau" Value="1" Selected="True"></asp:ListItem>
                    <asp:ListItem Text="Herr" Value="2"></asp:ListItem>
                  </asp:DropDownList>
                  <br />
                  <label>Vorname:</label>
                  <br />
                  <asp:TextBox ID="txtVorname" runat="server" CssClass="form-control" Width="200px">
                  </asp:TextBox>
                  <br />
                  <label>Nachname:</label>
                  <br />
                  <asp:TextBox ID="txtNachname" runat="server" CssClass="form-control" Width="200px">
                  </asp:TextBox>
                  <br />
                  <label>E-Mail:</label>
                  <br />
                  <asp:TextBox ID="txtEmail" runat="server" CssClass="form-control" Width="200px"></asp:TextBox>
                  <br />
                  <label>Nachricht:</label>
                  <br />
                  <asp:TextBox ID="txtNachricht" runat="server" CssClass="form-control"  Rows="10" Columns="10" 
                  TextMode="MultiLine">
                  </asp:TextBox>
                  <br />
                  <br />
                  <asp:Button ID="btnSend" runat="server" Text="Senden" CssClass="btn btn-info" 
                      onclick="btnSend_Click" />
              </div>
            </div>                  
    <asp:HiddenField ID="hdnUserID" runat="server" />
</asp:Content>

Details.aspx.cs:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    { }

    protected void btnSearch_Click(object sender, EventArgs e)
    {
        try
        {
            DataTable dt = new DataTable();
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ConnectionString);
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter("SELECT i.InseratID, i.PLZ, s.Bezeichnung AS StadtBez, i.Etage" +
            ", i.AnzZimmer, i.Preis, i.Groesse FROM Inserat AS i INNER JOIN Stadt AS s ON i.StadtID = s.StadtID WHERE " +
            "s.Bezeichnung LIKE '%" + this.txtWhere.Text + "%' AND i.Preis <= " + this.txtPrice.Text + 
            " AND i.AnzZimmer >= " + this.txtRooms.Text + " AND i.Groesse >= " + this.txtSquare.Text, con);
            da.Fill(dt);
            lvMain.DataSource = dt;
            lvMain.DataBind();
        }
        catch (Exception ex)
        { }
    }
}