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 |