protected void GVFloat_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            FloatAmountDAL floatDAL = new FloatAmountDAL {
                ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
            };

            Float TheFloat = new Float()
            {
                OrderNo               = (GVFloat.Rows[e.RowIndex].FindControl("LblFloatOrderNo") as Label).Text,
                OrderDate             = DateTime.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatOrderDate") as Label).Text),
                MemberName            = (GVFloat.Rows[e.RowIndex].FindControl("LblFloatMemberName") as Label).Text,
                Totalcost             = Double.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatCost") as Label).Text),
                Deliveryfees          = Double.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatFees") as Label).Text),
                Status                = (GVFloat.Rows[e.RowIndex].FindControl("DLLStatusList") as DropDownList).Text,
                TotalCostwithDelivery = Double.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatTotal") as Label).Text),
                CardTypeandAmount     = (GVFloat.Rows[e.RowIndex].FindControl("LblFloatProduct") as Label).Text,
                Quantity              = Int32.Parse((GVFloat.Rows[e.RowIndex].FindControl("LblFloatQuantity") as Label).Text),
                DeliveryDate          = ((GVFloat.Rows[e.RowIndex].FindControl("TxtFloatDeliveryDate") as TextBox).Text == string.Empty) ? (DateTime?)null : DateTime.Parse((GVFloat.Rows[e.RowIndex].FindControl("TxtFloatDeliveryDate") as TextBox).Text)
            };

            floatDAL.InsertFloat(TheFloat);
            GVFloat.EditIndex = -1;

            FetchFloat();
        }