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 |