ASP.NET GridView Update Record + SqlDataSource

 
ASP.NET GridView Update Record + SqlDataSource
 

   Default.aspx
 
   <asp:sqldatasource ID="SqlDataSource1" runat="server" />
 
   <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
   AutoGenerateEditButton="true" AutoGenerateColumns="False">
   <Columns>
      <asp:BoundField DataField="Team_Name" HeaderText="Team Name" SortExpression="Team_Name" />
      <asp:BoundField DataField="League_Name" HeaderText="League Name" ReadOnly="true" SortExpression="League_Name"/>
   </Columns>
   </asp:GridView>
 

 

   Default.aspx.vb
 
   Shared Team_Name_Condition As String
 
   Protected Sub GridView1_Update2(ByVal sender As Object, _
   ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) _
   Handles GridView1.RowEditing
 
      Team_Name_Condition = GridView1.Rows(e.NewEditIndex).Cells(1).Text.Trim
 
   End Sub
 
   Protected Sub GridView1_Update(ByVal sender As Object, _
   ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) _
   Handles GridView1.RowUpdating
 
      SqlDataSource1.UpdateParameters.Add("Team_Name_Condition", Team_Name_Condition)
      SqlDataSource1.UpdateParameters.Add("Team_Name", e.NewValues.Item(0).ToString())
      SqlDataSource1.Update()
 
   End Sub
 
   Protected Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Init
 
      SqlDataSource1.ConnectionString = "Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI"
      SqlDataSource1.SelectCommand = "SELECT dbo.Team.Team_Name, dbo.League.League_Name FROM dbo.Team " & _
            "INNER JOIN dbo.League ON dbo.Team.League_ID=dbo.League.League_ID " & _
            "ORDER BY dbo.League.League_Name, dbo.Team.Team_Name;"
      SqlDataSource1.UpdateCommand = "UPDATE Team SET Team_Name = " & _
            "@Team_Name WHERE Team_Name = @Team_Name_Condition;"
 
   End Sub