ASP.NET GridView Delete Record + SqlDataSource (2)

 

   Default.aspx
 
   <form id="form1" runat="server">
   <div>
      <asp:SqlDataSource ID="SqlDataSource1" runat="server"
      ConnectionString="Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI" />
 
      <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="true" />
   </div>
   </form>
 

 

   Default.aspx.vb
 
   Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
 
      SqlDataSource1.SelectCommand = "SELECT dbo.Team.Team_Name " & _
                                                              "AS 'Team Name', dbo.League.League_Name AS '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"
 
   End Sub
 
   Sub GV1_Deleting(ByVal sender As Object, ByVal e As WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
 
      SqlDataSource1.DeleteCommand = "DELETE FROM dbo.Team WHERE dbo.Team.Team_Name = '" & _
                                                               GridView1.Rows(e.RowIndex).Cells(1).Text & "'"
 
   End Sub