public void search() { conn.Open(); string str1 = "select top 1 Price,Descriptions,Title, Image1 + '~/AdImage/' as url ,descriptions from AdMaster1 order by NEWID() "; SqlCommand cmd1 = new SqlCommand(str1, conn); SqlDataAdapter sd1 = new SqlDataAdapter(cmd1); DataTable dt = new DataTable(); sd1.Fill(dt); if (dt.Rows.Count > 0) { cdcatalog.DataSource = dt; cdcatalog.DataBind(); } conn.Close(); }
<asp:Repeater id="cdcatalog" runat="server"> <ItemTemplate> <table> <tr> <td><b>Price:-<%# Eval("Price")%></b></td> </tr> <tr> <td> <asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("url") %>' width="200px" height="200px" /> </td> <td> <h3> <%# Eval("descriptions")%>]</h3> </td> </tr> <tr> <td><b> <%# Eval("Title")%></b></td> </tr> </table>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)