ASP.NET Veritabanından Veri Çekme ve Yazdırma

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<asp:SqlDataSource ID="sdsmenu" runat="server" ConnectionString="<%$ ConnectionStrings:caglayanCS %>"SelectCommand="SELECT * FROM [urunTablosu]">
</asp:SqlDataSource>
   
   <% 
     DataView viewmenu1 = (DataView)sdsmenu.Select(new DataSourceSelectArguments());
     DataTable dtmenu1 = viewmenu1.ToTable();
   %>
<% foreach (DataRow drmenu1 in dtmenu1.Rows)
    { %>
                 
<table>
        <tr>

<td><a href="urundetay.aspx?id=<%Response.Write(drmenu1["urunid"].ToString());%>"><%Response.Write(drmenu1["urunadi"].ToString());%> </a></td>
<td><a href="urundetay.aspx?id=<%Response.Write(drmenu1["urunid"].ToString());%>"><%Response.Write(drmenu1["fiyat"].ToString());%></a></td>
<td><a href="urundetay.aspx?id=<%Response.Write(drmenu1["urunid"].ToString());%>"><img src="<%Response.Write(drmenu1["urunresmi"].ToString());%>" width="100" height="100"/></a></td>
</tr> </table> <% }; %>

Hiç yorum yok:

Yorum Gönder