<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" DeleteCommand="DELETE FROM [BOOKS] WHERE [BOOK_ID] = @BOOK_ID" InsertCommand="INSERT INTO [BOOKS] ([BOOK_ID], [NAME], [PIC_URL], [BID_PRICE]) VALUES (@BOOK_ID, @NAME, @PIC_URL, @BID_PRICE)" SelectCommand="SELECT * FROM [BOOKS]" UpdateCommand="UPDATE [BOOKS] SET [NAME] = @NAME, [PIC_URL] = @PIC_URL, [BID_PRICE] = @BID_PRICE WHERE [BOOK_ID] = @BOOK_ID"> <DeleteParameters> <asp:Parameter Name="BOOK_ID" Type="String" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="NAME" Type="String" /> <asp:Parameter Name="PIC_URL" Type="String" /> <asp:Parameter Name="BID_PRICE" Type="Double" /> <asp:Parameter Name="BOOK_ID" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="BOOK_ID" Type="String" /> <asp:Parameter Name="NAME" Type="String" /> <asp:Parameter Name="PIC_URL" Type="String" /> <asp:Parameter Name="BID_PRICE" Type="Double" /> </InsertParameters> </asp:SqlDataSource> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="BOOK_ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" AllowPaging="True" PageSize="5"> <RowStyle BackColor="#FFFBD6" ForeColor="#333333" /> <Columns> <asp:TemplateField> <ItemTemplate> <div id='<%# Eval("BOOK_ID") + "_SLICE" %>' class="hslice" style="width:300px"> <a href='<%#"BookDetail.aspx?ID="+Eval("BOOK_ID") %>' rel="feedurl" style="visibility:hidden"></a> <%# Eval("BOOK_ID") %> <span class="entry-title" style="visibility: hidden"> <%# Eval("Name") %></span> <div class="entry-content"> <p> <%# Eval("Name") %></p> <asp:Image ID="Image1" runat="server" Height="120" Width="80" ImageUrl='<%# Eval("PIC_URL") %>' /> <br /> BID Price: <asp:Label ID="Label1" runat="server" Text='<%# Eval("BID_PRICE") %>' /> </div> </div> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="White" /> </asp:GridView> </div> </form> </body> </html> |