ASP.NET FormView + ItemTemplate 使用方法

ASP.NET FormView + ItemTemplate 使用方法

   <table border="0" cellpadding="0" cellspacing="0" width="850">

   <asp:SqlDataSource ID="SqlDataSource1" runat="server"
   ConnectionString="Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI"
   SelectCommand="SELECT dbo.Team.Team_ID, dbo.Team.Team_Name FROM dbo.Team ORDER BY dbo.Team.Team_ID;"
   InsertCommand="INSERT INTO dbo.Team (Team_ID, Team_Name, League_ID) VALUES (@Team_ID, @Team_Name, @League_ID) "
   UpdateCommand="UPDATE dbo.Team SET dbo.Team.Team_Name = @Team_Name WHERE dbo.Team.Team_ID = @Team_ID;"
   DeleteCommand="DELETE FROM dbo.Team WHERE dbo.Team.Team_ID = @Team_ID">
   </asp:SqlDataSource>

   <asp:FormView ID="a1" runat="server" DataSourceID="SqlDataSource1" AllowPaging="true" DataKeyNames="Team_ID">

   <ItemTemplate>
      <tr><td>
         <asp:Label ID="Label2" runat="server" Text='<%# Eval("Team_ID") %>' />
         <asp:Label ID="Label1" runat="server" Text='<%# Eval("Team_Name") %>' />
      </td></tr>

      <tr><td>
         <asp:Button ID="Add" runat="server" Text="Add" CommandName="New" />
         <asp:Button ID="Edit" runat="server" Text="Edit" CommandName="Edit" />
         <asp:Button ID="Delete" runat="server" Text="Delete" CommandName="Delete" />
      </td></tr>
   </ItemTemplate>

   <EditItemTemplate>
      <tr><td>
         <asp:Label ID="Label3" runat="server" Text='<%# Bind("Team_ID") %>' />
         <asp:Textbox ID="Textbox1" runat="server" Text='<%# Bind("Team_Name") %>' />
      </td></tr>

      <tr><td>
         <asp:Button ID="Update" runat="server" Text="Update" CommandName="Update" />
         <asp:Button ID="Cancel" runat="server" Text="Cancel" CommandName="Cancel" />
      </td></tr>
   </EditItemTemplate>

   <InsertItemTemplate>
      <tr><td>
         <asp:Textbox ID="Textbox3" runat="server" Text='<%# Bind("Team_ID") %>' />
         <asp:Textbox ID="Textbox2" runat="server" Text='<%# Bind("Team_Name") %>' />
         <asp:Textbox ID="Textbox4" runat="server" Text='<%# Bind("League_ID") %>' />
      </td></tr>

      <tr><td>
         <asp:Button ID="Insert" runat="server" Text="Insert" CommandName="Insert" />
         <asp:Button ID="Cancel" runat="server" Text="Cancel" CommandName="Cancel" />
      </td></tr>
   </InsertItemTemplate>

   </asp:FormView>

   </table>

註: Select (Read) 用 Eval, Update / Insert (Write) 用 Bind