[Solved] Update checked GridView Row cell values on Button click in ASP.Net

Hi Appache,

First you have to bind the gridview.

Then you have to go to the update button click event.

You have to use a foreach loop on gridview row and find the checkbox and the change value through an ID. If the checkbox is checked, then your update command will run and the value will change on the selected checkbox. 

Please refer below sample.

HTML

<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateField HeaderText="Select">
            <ItemTemplate>
                <asp:CheckBox ID="chkselect" runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="CustomerId" HeaderText="Id" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
    </Columns>
</asp:GridView>
<br>
<asp:Label ID="lblName" runat="server">Name</asp:Label>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
<asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="btnUpdate_Click" />

Namespaces

C#

using System.Data;
using System.Configuration;
using System.Data.SqlClient;

VB.Net

Imports System.Data
Imports System.Configuration
Imports System.Data.SqlClient

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.GridView();
    }
}

protected void btnUpdate_Click(object sender, EventArgs e)
{
    foreach (GridViewRow row in gvCustomers.Rows)
    {
        CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
        if (chkSelect.Checked)
        {
            int id = int.Parse(row.Cells[1].Text);
            string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constring))
            {
                using (SqlCommand cmd = new SqlCommand("UPDATE Customers SET Name = @Name WHERE CustomerId = @CustomerId", con))
                {
                    con.Open();
                    cmd.Parameters.AddWithValue("@Name", txtName.Text);
                    cmd.Parameters.AddWithValue("@CustomerId", id);
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
        this.GridView();
    }
}

private void GridView()
{
    string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT CustomerId, Name, Country FROM Customers", con))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    gvCustomers.DataSource = dt;
                    gvCustomers.DataBind();
                }
            }
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        Me.GridView()
    End If
End Sub

Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs)
    For Each row As GridViewRow In GridView1.Rows
        Dim chkSelect As CheckBox = CType(row.FindControl("chkSelect"), CheckBox)
        If chkSelect.Checked Then
            Dim id As Integer = Integer.Parse(row.Cells(1).Text)
            Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
            Using con As SqlConnection = New SqlConnection(constring)
                Using cmd As SqlCommand = New SqlCommand("UPDATE Customers SET Name=@Name WHERE CustomerId=@CustomerId", con)
                    con.Open()
                    cmd.Parameters.AddWithValue("@Name", txtName.Text)
                    cmd.Parameters.AddWithValue("@CustomerId", id)
                    cmd.ExecuteNonQuery()
                    con.Close()
                End Using
            End Using
        End If
    Next
    Me.GridView()
End Sub

Private Sub GridView()
    Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constring)
        Using cmd As SqlCommand = New SqlCommand("SELECT CustomerId, Name, Country FROM Customers", con)
            Using sda As SqlDataAdapter = New SqlDataAdapter(cmd)
                Using dt As DataTable = New DataTable()
                    sda.Fill(dt)
                    GridView1.DataSource = dt
                    GridView1.DataBind()
                End Using
            End Using
        End Using
    End Using
End Sub

Screenshot