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 |