protected void btnGuardarComu_Click(object sender, EventArgs e)
        {
            int orderId = Convert.ToInt32(lbl_IdInstrumentoSupervisionN.Text);

            InstrumentoSupervisionDao insSupDao = new InstrumentoSupervisionDao();
            if (insSupDao.updateInstrumentoSupervision(orderId, vigencia) == "Ok")
            {
                Alerta.Text = "Datos Modificados en forma Correcta";
                Response.Redirect("MantenedorInstrumentoSupervision");

            }
            else
            {

                Alerta.Text = insSupDao.updateInstrumentoSupervision(orderId, vigencia);
            }
        }
        protected void btnGuardarInstrumentoSupervision_Click(object sender, EventArgs e)
        {
            Alerta.Enabled = true;

            //int intManInstrumentoSupervisionProvincia = int.Parse(ddlProvincia.SelectedItem.Value);

            String manInstrumentoSupervisionNombre = txtManInstrumentoSupervision.Text;

            InstrumentoSupervisionDao insSupDao = new InstrumentoSupervisionDao();
            if (insSupDao.insertInstrumentoSupervision(manInstrumentoSupervisionNombre) == "Ok")
            {
                Alerta.Text = "Se ha guardado correctamente";
                Response.Redirect("MantenedorInstrumentoSupervision");
            }
            else
            {
                Alerta.Text = insSupDao.insertInstrumentoSupervision(manInstrumentoSupervisionNombre);
            }
        }
        void getTableInstrumentoSupervision()
        {
            InstrumentoSupervisionDao insSupDao = new InstrumentoSupervisionDao();
            //Populating a DataTable from database.
            //DataTable dt = regDao.getTableRegion();

            DataSet ds = new DataSet();

            da = insSupDao.getInstrumentoSupervision();
            da.Fill(ds);
            this.GV_InstrumentoSupervision.DataSource = ds;
            this.GV_InstrumentoSupervision.DataBind();
        }
        private void LoadEditData(int orderId)
        {
            lblIdInstrumentoSupervision.Text = Convert.ToString(orderId);
            InstrumentoSupervisionDao insSupDao = new InstrumentoSupervisionDao();

            DataSet ds = new DataSet();

            da = insSupDao.getInstrumentoSupervisionId(orderId);

            DataTable dt = new DataTable();
            dt = insSupDao.getTableInstrumentoSupervisionId();

            foreach (DataRow row in dt.Rows)
            {

                lbl_IdInstrumentoSupervisionN.Text = row[0].ToString();
                txt_DescripcionInstrumentoSupervision.Text = row[1].ToString();
                txt_VigenciaInstrumentoSupervision.Text = row[2].ToString();

            }
        }