how to find label inside GridView and insert all row from GridView into Database in ASP.Net

Hi nedash,

You need to use findcontrol to find the controls and cast those to lable to get the text value like below. For quantity and price assign the value from where you want to assign.

protected void LBsabt_Click(object sender, EventArgs e)
{
    using (SqlConnection conn = General.GetConnection())
    {
        using (SqlCommand _cmd = General.GetCommand("Order_Confirm", conn))
        {
            conn.Open();
            foreach (GridViewRow row in gvOrders.Rows)
            {
                string Pcode = (row.FindControl("LblPcode") as Label).Text.Trim();
                string OrderType = (row.FindControl("LblOrderType") as Label).Text.Trim();
                string format = (row.FindControl("LblFormat") as Label).Text.Trim();
                string Ptype = (row.FindControl("LblPtype") as Label).Text.Trim();
                string PSectionName = (row.FindControl("LblPSectionName") as Label).Text.Trim();
                string PName = (row.FindControl("LblName") as Label).Text.Trim();
                string PriceT = (row.FindControl("LblPriceT") as Label).Text.Trim();
                string Quantity = (row.FindControl("Quantity") as Label).Text.Trim();
                string PriceP = (row.FindControl("PriceP") as Label).Text.Trim();
                _cmd.Parameters.Clear();
                _cmd.Parameters.AddWithValue("@Name", Txtname.Text);
                _cmd.Parameters.AddWithValue("@Zone", Ddlzone.SelectedItem.Text);
                _cmd.Parameters.AddWithValue("@State", DdlState.SelectedItem.Text);
                _cmd.Parameters.AddWithValue("@City", DdlCity.SelectedItem.Text);
                _cmd.Parameters.AddWithValue("@Mobile", Txtmob.Text);
                _cmd.Parameters.AddWithValue("@Tell", Txttell.Text);
                _cmd.Parameters.AddWithValue("@PostCode", Txtcode.Text);
                _cmd.Parameters.AddWithValue("@Address", Txtadd.Text);
                _cmd.Parameters.AddWithValue("@Email", Txtemail.Text);
                _cmd.Parameters.AddWithValue("@PostType", LblpostS.Text);
                _cmd.Parameters.AddWithValue("@PriceTotal", Lblprice.Text);
                _cmd.Parameters.AddWithValue("@PriceTotalBaste", Lblkol.Text);
                _cmd.Parameters.AddWithValue("@PostPrice", LblPostT.Text);
                _cmd.Parameters.AddWithValue("@Pcode", Pcode);
                _cmd.Parameters.AddWithValue("@Ptype", Ptype);
                _cmd.Parameters.AddWithValue("@PSectionName", PSectionName);
                _cmd.Parameters.AddWithValue("@PName", PName);
                _cmd.Parameters.AddWithValue("@OrderType", OrderType);
                _cmd.Parameters.AddWithValue("@format", format);
                _cmd.Parameters.AddWithValue("@Quantity", Quantity);
                _cmd.Parameters.AddWithValue("@PriceP", PriceP);
                _cmd.Parameters.AddWithValue("@PriceT", PriceT);
                _cmd.ExecuteNonQuery();

            }
        }
    }
}