Click here to Skip to main content
15,901,035 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
<div class="datalist"> <div class="datalistheading">    <asp:Label CssClass="titlebackground" ID="Label7" runat="server" Text='<%#Eval("title")%>'></asp:Label></div>
       <div class="datalistimage"><asp:Image  ID="Image1" runat="server" ImageUrl='<%#Eval("product_imgpath") %>' Height="150px" Width="150px" /></div>
       <div class="datalistitem">
        <div class="dataitembed"><asp:Label ID="Label8" runat="server" Text='<%#"Product Type:"+Eval("product_category")%>'></asp:Label></div>
     <div class="dataitembed">  <asp:Label ID="Label1" runat="server" Text='<%#"Bedroom(s):"+ Eval("property_type")+"BHK"%>'></asp:Label></div>
       <div class="dataitembed"><asp:Label ID="Label3" runat="server" Text='<%#"City:"+Eval("city")%>'></asp:Label></div>
       <div class="dataitembed"><asp:Label ID="Label4" runat="server" Text='<%#"Location:"+ Eval("location")%>'></asp:Label></div>
      <div class="dataitembed"><asp:HyperLink ID="HyperLink4" runat="server" Text='<%#Eval("paymentplan_imgpath") %>'>Payment Plan</asp:HyperLink> </div>
        <div class="dataitembed"><asp:HyperLink ID="HyperLink5" runat="server" Text='<%#Eval("pricelist_imgpath") %>'>Pricelist</asp:HyperLink> </div>

      <div class="dataitembed"> <asp:Label ID="Label6" runat="server" Text='<%#"Contact No:"+ Eval("contact_no")%>'></asp:Label></div></div>
     <div class="datalistdispription"><asp:Label ID="Label2" runat="server" Text='<%#Eval("pdiscription")%>'></asp:Label></div>
    <div class="layout"><div>
        <asp:HyperLink CssClass="hyperlinkfloat" ID="HyperLink1" runat="server" NavigateUrl='<%#Eval("Layout_Plan_imgpath")%>' Target="_blank">Layout Plan</asp:HyperLink></div>
     <div>
         <asp:HyperLink CssClass="hyperlinkfloat" ID="HyperLink2" runat="server" NavigateUrl='<%#Eval("Floor_Plan_imgpath_1bhk")%>' Target="_blank">Floor Plan</asp:HyperLink></div>
     <div>
         <asp:HyperLink CssClass="hyperlinkfloat" ID="HyperLink3" runat="server" NavigateUrl='<%#Eval("Unit_plan_imgpath")%>' Target="_blank">Unit Plan</asp:HyperLink></div></div>
     </div>
       <img alt="" style="width:100%; " src="images/line.JPG" />
  </ItemTemplate>
   </asp:DataList>


protected void Page_Load(object sender, EventArgs e)
   {
       //getcommercialproductid();
       //datalistsearchresult();
       DataTable dt = new DataTable();

       String strConnString = System.Configuration.ConfigurationManager.

           ConnectionStrings["DataSourceConnectionString"].ConnectionString;
       pc = "Residential";
       string strQuery = "select title,product_imgpath,product_category,pdiscription,contact_no,city,location,property_type,pricelist_imgpath,paymentplan_imgpath,Layout_Plan_imgpath,Floor_Plan_imgpath_1bhk,Floor_Plan_imgpath_2bhk,Floor_Plan_imgpath_3bhk,Floor_Plan_imgpath_4bhk,Unit_plan_imgpath from tbl_project where product_category = '  pc  '";

       SqlCommand cmd = new SqlCommand(strQuery);

       SqlConnection con = new SqlConnection(strConnString);

       SqlDataAdapter sda = new SqlDataAdapter();

       //cmd.CommandType = CommandType.Text;

       cmd.Connection = con;

       try
       {

           con.Open();

           sda.SelectCommand = cmd;

           sda.Fill(dt);

           DataList3.DataSource = dt;

           DataList3.DataBind();

       }

       catch (Exception ex)
       {

           //Response.Write(ex.Message);

       }

       finally
       {

           con.Close();

           sda.Dispose();

           con.Dispose();

       }

   }
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900