Radiobutton Checked changed event in gridview

See more:

ASP.NET

When i am updating in gridview radio button its not updating in database. here's my code:

protected void rdbdiscontinued_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rd = (RadioButton)sender;
            GridViewRow row = (GridViewRow)rd.NamingContainer;
            Label lblprodid = (Label)row.FindControl("lblproductid");
            Label lbproductname = (Label)row.FindControl("lblproductname");
            Label lbcategoryid = (Label)row.FindControl("lblcategoryid");
            Label lbunit = (Label)row.FindControl("lblunitprice");
            Label txtunitstock = (Label)row.FindControl("lblunitsinstock");
            if (rd.Checked == true)
            {
                Productsbll pbl = new Productsbll();
                Products prod = new Products();
                row.Visible = false;
                prod.Productid = Convert.ToInt32(lblprodid.Text);
                prod.ProductName = lbproductname.Text;
                prod.CategoryID = Convert.ToInt32(lbcategoryid.Text);
                prod.UnitPrice = Convert.ToInt32(lbunit.Text);
                prod.UnitsinStock = Convert.ToInt32(txtunitstock.Text);
                pbl.UpdateProduct(prod);
            }
            GetProducts();
        }

in Updateproduct.cs

public int UpdateProduct(Products prod)
        {
            con = new SqlConnection(cons);
            try
            {
                string query = "Update Products set ProductName=@productname, CategoryID=@categoryid, UnitPrice=@unitprice, UnitsInStock=@UnitsinStock, Discontinued=@Discontinued where ProductID=@productid";
                cmd = new SqlCommand(query, con);
                cmd.Parameters.AddWithValue("@productid", prod.Productid);
                cmd.Parameters.AddWithValue("@productname", prod.ProductName);
                cmd.Parameters.AddWithValue("@CategoryID", prod.CategoryID);
                cmd.Parameters.AddWithValue("@unitprice", prod.UnitPrice);
                cmd.Parameters.AddWithValue("@UnitsinStock", prod.UnitsinStock);
                cmd.Parameters.AddWithValue("@Discontinued", prod.Discontinued);
                con.Open();
                int i = cmd.ExecuteNonQuery();
                return i;
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }

please help me where i did wrong and here when i click on radio button that row should be hide.

thank you.