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

hi andrea

please read question carefully

thanks

Hi,

nedash

On click of button Btninsert you need to update sms value to 1 of all records which already bind in gridview or you need to do it  with particular single record by selecting single gridrecord? If you want to update all record then use below query as inline query or

make it  as stored procedure call it in your code. 

UPDATE information
SET Sms = 1
WHERE Sms = 0

or you can update single record by using below query.

For this you need to use for loop on gridview records and find id value update sms value based on id value. 

UPDATE information
SET Sms = 1
WHERE id = @id

hi zameer

ok I write SP and write below code for gridview

  using (SqlConnection conn = General.GetConnection())
        {
            using (SqlCommand _cmd = General.GetCommand("malkeSms_insert", conn))
            {
                conn.Open();
                foreach (GridViewRow row in Grdmalek.Rows)
                {
                    _cmd.Parameters.Clear();
                    string id = (row.FindControl("LblmalekId") as Label).Text.Trim();


                    _cmd.Parameters.AddWithValue("@id", id);

                }
                _cmd.ExecuteNonQuery();
            }
        }

but it just run SP just for one Id from gridview

I want do it for all id that are in grid view

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();
        }
    }
}