Update Table column to one for each row of GridView using C# in ASP.Net

Hi ,

nedash

As per your query i have created the sample.

Please refer the below sample. If you have any doubt revert my reply.

Update Procedure

CREATE PROCEDURE [dbo].[information_UpdateInformation]
	@Id INT
AS
BEGIN
	
	UPDATE information
	SET Sms = '1'
	WHERE id = @Id
END

HTML

<div>
    <asp:GridView ID="Grdmalek" runat="server" AutoGenerateColumns="false">
        <Columns>
            <asp:TemplateField ItemStyle-Width="200px" ItemStyle-VerticalAlign="Middle" ShowHeader="true"
                HeaderText="MalkeMobile">
                <ItemTemplate>
                    <asp:Label ID="LblNamemalek" runat="server" Text='<%#Eval("MalkeMobile")%>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField ItemStyle-Width="200px" ItemStyle-VerticalAlign="Middle" ShowHeader="true"
                HeaderText="Id">
                <ItemTemplate>
                    <asp:Label ID="LblIdmalek" runat="server" Text='<%#Eval("id")%>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <asp:Button ID="btnInsert" runat="server" Text="Insert" OnClick="Insert" />
</div>

Code

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

private void BindGrid()
{
    string cns = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(cns))
    {
        SqlCommand cmd = new SqlCommand("ViewMalekInfo");
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Connection = con;
        con.Open();
        SqlDataReader rdr = cmd.ExecuteReader();
        Grdmalek.DataSource = rdr;
        Grdmalek.DataBind();
        con.Close();
    }
}

protected void Insert(object sender, EventArgs e)
{
    for (int i = 0; i < Grdmalek.Rows.Count; i++)
    {
        int id = Convert.ToInt32((Grdmalek.Rows[i].FindControl("LblIdmalek") as Label).Text);
        string cns = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(cns))
        {
            SqlCommand cmd = new SqlCommand("information_UpdateInformation");
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = con;
            cmd.Parameters.AddWithValue("@Id", id);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}