<asp:DataList ID="dlImages" runat="server" RepeatColumns="6"> <ItemTemplate> <a id="imageLink" href='<%# Eval("ImageName","~/images/fabrics/{0}") %>' title='<%#Eval("Descript") %>' rel="lightbox[Brussels]" runat="server" > <asp:Image ID="Image1" ImageUrl='<%# Bind("ImageName", "~/images/fabrics/{0}") %>' runat="server" Width="100px" Height="60px" hspace="20px"/><br /> <asp:Label ID="lbl1" runat="server" Text='<%#Eval("ImageAssignedName") %>' Height="30px"></asp:Label> </a> </ItemTemplate> <ItemStyle HorizontalAlign="Center" VerticalAlign="Bottom"/> </asp:DataList>
<script type="text/javascript"> $(document).ready(function () { $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "WebForm2.aspx/BindDatatable", data: "{}", dataType: "json", success: function (data) { alert('Hello 1'); for (var i = 0; i < data.d.length; i++) { alert(data.d[i].ImageAssignedName); $("#dlImages").append(data.d[i].ImageName + data.d[i].Descript + data.d[i].ImageAssignedName); } }, error: function (result) { alert("Error"); } }); }); </script>
[WebMethod] public static UserDetails[] BindDatatable() { DataTable dt = new DataTable(); List<UserDetails> details = new List<UserDetails>(); using (SqlConnection connnection = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString.ToString())) { using (SqlCommand cmd = new SqlCommand("SELECT Fabrics.ImageName,Fabrics.Descript,ImageAssignedName from Fabrics", connnection)) { connnection.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dtrow in dt.Rows) { UserDetails user = new UserDetails(); user.ImageName = dtrow["ImageName"].ToString(); user.Descript = dtrow["Descript"].ToString(); user.ImageAssignedName = dtrow["ImageAssignedName"].ToString(); details.Add(user); } } } return details.ToArray(); } public class UserDetails { public string ImageName { get; set; } public string Descript { get; set; } public string ImageAssignedName { get; set; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)