Here is my source code for the page in question:
Expand|Select|Wrap|Line Numbers
- <asp:GridView ID="FullEditAlbumGridView" runat="server" AllowPaging="True" AllowSorting="True"
- AutoGenerateColumns="False" DataSourceID="FullEditSqlDataSource" Width="717px" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True">
- <FooterStyle BackColor="DarkGreen" BorderColor="Ivory" BorderStyle="Solid" ForeColor="Ivory" />
- <Columns>
- <asp:BoundField DataField="AlbumID" HeaderText="AlbumID" InsertVisible="False" ReadOnly="True"
- ShowHeader="False" SortExpression="AlbumID" Visible="False" />
- <asp:TemplateField HeaderText="AlbumTitle" SortExpression="AlbumTitle">
- <EditItemTemplate>
- <asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("AlbumTitle") %>'></asp:TextBox>
- <asp:RequiredFieldValidator ID="AlbumTitleValidator" runat="server" ErrorMessage="<br />Title is required" ControlToValidate="TitleTextBox" Display="Dynamic"></asp:RequiredFieldValidator>
- </EditItemTemplate>
- <ItemTemplate>
- <asp:Label ID="TitleLabel" runat="server" Text='<%# Bind("AlbumTitle") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="AlbumYear" SortExpression="AlbumYear">
- <EditItemTemplate>
- <asp:TextBox ID="YearPubTextBox" Type="Integer" runat="server" Text='<%# Bind("AlbumYear") %>'></asp:TextBox>
- <asp:RequiredFieldValidator ID="YearValidator" runat="server" ControlToValidate="YearPubTextBox" Display="Dynamic" ErrorMessage="<br />Year is a required field"></asp:RequiredFieldValidator>
- </EditItemTemplate>
- <ItemTemplate>
- <asp:Label ID="YearPubLabel" runat="server" Text='<%# Bind("AlbumYear") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="GenreName" SortExpression="GenreName">
- <EditItemTemplate>
- <asp:DropDownList ID="GenreList" runat="server" DataSourceID="GenreSqlDataSource" DataTextField="GenreName"
- DataValueField="GenreID" SelectedValue='<%# Bind("AlbumGenreID") %>'>
- </asp:DropDownList><asp:SqlDataSource ID="GenreSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:MyCdsConnectionString %>"
- SelectCommand="SELECT * FROM [Genre] ORDER BY [GenreName]"></asp:SqlDataSource>
- </EditItemTemplate> <ItemTemplate>
- <asp:Label ID="GenreLabel" runat="server" Text='<%# Bind("GenreName") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="BandName" SortExpression="BandName">
- <EditItemTemplate>
- <asp:DropDownList ID="BandNameList" runat="server" DataSourceID="BandSqlDataSource" DataTextField="BandName"
- DataValueField="BandID" SelectedValue='<%# Bind("AlbumBandID") %>'>
- </asp:DropDownList><asp:SqlDataSource ID="BandSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:MyCdsConnectionString %>"
- SelectCommand="SELECT * FROM [Band] ORDER BY [BandName]"></asp:SqlDataSource>
- </EditItemTemplate>
- <ItemTemplate>
- <asp:Label ID="BandNameLabel" runat="server" Text='<%# Bind("BandName") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- </Columns>
- <RowStyle BackColor="Beige" BorderColor="Ivory" BorderStyle="Solid" ForeColor="DarkGreen" />
- <PagerStyle BackColor="DarkGreen" BorderColor="Ivory" BorderStyle="Solid" ForeColor="Ivory" />
- <HeaderStyle BackColor="DarkGreen" BorderColor="Ivory" BorderStyle="Solid" BorderWidth="1px"
- ForeColor="Ivory" />
- <AlternatingRowStyle BackColor="Transparent" BorderColor="Ivory" ForeColor="DarkGreen" />
- </asp:GridView>
- <br />
- <asp:HyperLink ID="LoginLink" runat="server" NavigateUrl="~/Admin/Default.aspx">Log In</asp:HyperLink><br />
- <br />
- <asp:SqlDataSource ID="FullEditSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:MyCdsConnectionString %>"
- DeleteCommand="DELETE FROM [Album] WHERE [AlbumID] = @AlbumID"
- InsertCommand="INSERT INTO [Album] ([AlbumTitle], [AlbumYear], [AlbumGenreID], [AlbumBandID]) VALUES (@AlbumTitle, @AlbumYear, @AlbumGenreID, @AlbumBandID)"
- SelectCommand="SELECT Album.*, Genre.GenreName, Band.BandName FROM Album INNER JOIN Band ON Album.AlbumBandID = Band.BandID INNER JOIN Genre ON Album.AlbumGenreID = Genre.GenreID"
- UpdateCommand="UPDATE Album SET AlbumTitle = @AlbumTitle, AlbumYear = @AlbumYear, AlbumGenreID = @AlbumGenreID, AlbumBandID = @AlbumBandID WHERE (AlbumID = @AlbumID)">
- <DeleteParameters>
- <asp:Parameter Name="AlbumID" />
- </DeleteParameters>
- <UpdateParameters>
- <asp:Parameter Name="AlbumTitle" />
- <asp:Parameter Name="AlbumYear" />
- <asp:Parameter Name="AlbumGenreID" />
- <asp:Parameter Name="AlbumBandID" />
- <asp:Parameter Name="AlbumID" />
- </UpdateParameters>
- <InsertParameters>
- <asp:Parameter Name="AlbumTitle" />
- <asp:Parameter Name="AlbumYear" />
- <asp:Parameter Name="AlbumGenreID" />
- <asp:Parameter Name="AlbumBandID" />
- </InsertParameters>
- </asp:SqlDataSource>
- <asp:SqlDataSource ID="GenreSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:MyCdsConnectionString %>"
- SelectCommand="SELECT [GenreName], [GenreID] FROM [Genre]ORDER BY [GenreName]"></asp:SqlDataSource>
- <asp:SqlDataSource ID="BandSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:MyCdsConnectionString %>"
- SelectCommand="SELECT [BandID], [BandName] FROM [Band] ORDER BY [BandName]"></asp:SqlDataSource>
- <br />