ASP.NET SQLDataSource + GridView + ItemTemplate + Update Record

 
ASP.NET SQLDataSource + GridView + Update Record
 

   Default.aspx
 
   <asp:SqlDataSource ID="SqlDataSource1" runat="server" />
 
   <asp:GridView ID="GridView1" runat="server"
   DataSourceID="SqlDataSource1" AutoGenerateColumns="false">
 
      <Columns>
 
         <asp:TemplateField HeaderText="Player ID">
 
            <ItemTemplate>
               <asp:Label ID="label1" runat="server"
               Text='<%# Eval("Player ID") %>' />
            </ItemTemplate>
 
            <EditItemTemplate>
               <asp:Label ID="label1" runat="server"
               Text='<%# Eval("Player ID") %>' />
            </EditItemTemplate>
 
         </asp:TemplateField>
 
 
         <asp:TemplateField HeaderText="Player Name">
 
            <ItemTemplate>
               <asp:Label ID="label2" runat="server"
               Text='<%# Eval("Player Name") %>' />
            </ItemTemplate>
 
            <EditItemTemplate>
               <asp:TextBox ID="TextBox2" runat="server"
               Text='<%# Eval("Player Name") %>' />
            </EditItemTemplate>
 
         </asp:TemplateField>
 
 
         <asp:TemplateField HeaderText="Team ID">
 
            <ItemTemplate>
               <asp:Label ID="label3" runat="server"
               Text='<%# Eval("Team ID") %>' />
            </ItemTemplate>
 
            <EditItemTemplate>
               <asp:Label ID="label3" runat="server"
               Text='<%# Eval("Team ID") %>' />
            </EditItemTemplate>
 
         </asp:TemplateField>
 
 
         <asp:TemplateField HeaderText="Button">
 
            <ItemTemplate>
               <asp:Button ID="Button1" runat="server"
               Text="Button" CommandName="Edit" />
            </ItemTemplate>
 
            <EditItemTemplate>
               <asp:Button ID="Button1" runat="server"
               Text="Button" CommandName="Update"
               CommandArgument='<%# Eval("Player ID") %>'
               oncommand="btnUpdate_Command" />
            </EditItemTemplate>
 
         </asp:TemplateField>
 
 
      </Columns>
 
   </asp:GridView>
 

 

   Default.aspx.vb
 
   Protected Sub Page_Load(ByVal sender As Object, _
   ByVal e As System.EventArgs) Handles Me.Load
      GetData()
   End Sub
 
   Protected Sub btnUpdate_Command(ByVal sender As Object, _
   ByVal e As System.Web.UI.WebControls.CommandEventArgs)
 
      Dim A As String = TryCast(sender.FindControl("TextBox2"), TextBox).Text
      SqlDataSource1.UpdateCommand = "UPDATE dbo.Player SET Player_Name = '" & A & _
      "' WHERE Player_ID = " & e.CommandArgument
 
   End Sub
 
   Private Sub GetData()
 
      SqlDataSource1.ConnectionString = "Data Source=.\SqlExpress;"
      SqlDataSource1.ConnectionString &= "Initial Catalog=Soccer; "
      SqlDataSource1.ConnectionString &= "Integrated Security=SSPI"
      SqlDataSource1.SelectCommand = "SELECT Player_ID AS 'Player ID', Player_Name AS 'Player Name', " & _
      "Team_ID AS 'Team ID' FROM dbo.Player"
 
   End Sub