Example #1
0
 /// <summary>
 /// Método necesario para admitir el Diseñador, no se puede modificar
 /// el contenido del método con el editor de código.
 /// </summary>
 private void InitializeComponent()
 {
     System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
     this.oleDbDataAdapter1   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.contratos1          = new imprimir_anexos.contratos();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("CDOC_NCORR", "CDOC_NCORR"),
             new System.Data.Common.DataColumnMapping("pers_ncorr", "pers_ncorr"),
             new System.Data.Common.DataColumnMapping("Nombre_Docente", "Nombre_Docente"),
             new System.Data.Common.DataColumnMapping("Rut_Docente", "Rut_Docente"),
             new System.Data.Common.DataColumnMapping("DV", "DV"),
             new System.Data.Common.DataColumnMapping("Fecha_Nac", "Fecha_Nac"),
             new System.Data.Common.DataColumnMapping("Estado_Civil", "Estado_Civil"),
             new System.Data.Common.DataColumnMapping("Direccion", "Direccion"),
             new System.Data.Common.DataColumnMapping("Comuna", "Comuna"),
             new System.Data.Common.DataColumnMapping("Ciudad", "Ciudad"),
             new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
             new System.Data.Common.DataColumnMapping("BLOQ_ANEXO", "BLOQ_ANEXO"),
             new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
             new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
             new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"),
             new System.Data.Common.DataColumnMapping("ASIG_NHORAS", "ASIG_NHORAS"),
             new System.Data.Common.DataColumnMapping("ASIG_TDESC", "ASIG_TDESC"),
             new System.Data.Common.DataColumnMapping("DUAS_TDESC", "DUAS_TDESC"),
             new System.Data.Common.DataColumnMapping("monto_sesion", "monto_sesion"),
             new System.Data.Common.DataColumnMapping("Valor", "Valor"),
             new System.Data.Common.DataColumnMapping("INST_TRAZON_SOCIAL", "INST_TRAZON_SOCIAL"),
             new System.Data.Common.DataColumnMapping("NombreRepLeg", "NombreRepLeg"),
             new System.Data.Common.DataColumnMapping("TipoDocente", "TipoDocente"),
             new System.Data.Common.DataColumnMapping("Nacionalidad", "Nacionalidad"),
             new System.Data.Common.DataColumnMapping("FechaI", "FechaI"),
             new System.Data.Common.DataColumnMapping("FechaF", "FechaF"),
             new System.Data.Common.DataColumnMapping("horas_coordinacion", "horas_coordinacion"),
             new System.Data.Common.DataColumnMapping("SECC_TDESC", "SECC_TDESC"),
             new System.Data.Common.DataColumnMapping("sede_tdesc", "sede_tdesc"),
             new System.Data.Common.DataColumnMapping("num_cuotas", "num_cuotas"),
             new System.Data.Common.DataColumnMapping("fecha_inicio", "fecha_inicio"),
             new System.Data.Common.DataColumnMapping("fecha_fin", "fecha_fin"),
             new System.Data.Common.DataColumnMapping("porcentaje", "porcentaje"),
             new System.Data.Common.DataColumnMapping("monto_colacion", "monto_colacion"),
             new System.Data.Common.DataColumnMapping("institucion_t", "institucion_t"),
             new System.Data.Common.DataColumnMapping("grado", "grado"),
             new System.Data.Common.DataColumnMapping("institucion_g", "institucion_g"),
             new System.Data.Common.DataColumnMapping("horario", "horario"),
             new System.Data.Common.DataColumnMapping("jerarquia", "jerarquia")
         })
     });
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     this.oleDbConnection1.InfoMessage     += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
     //
     // contratos1
     //
     this.contratos1.DataSetName = "contratos";
     this.contratos1.Locale      = new System.Globalization.CultureInfo("en-US");
     this.contratos1.Namespace   = "http://www.tempuri.org/contratos.xsd";
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS CDOC_NCORR, 0 AS pers_ncorr, '' AS Nombre_Docente, 0 AS Rut_Docente, '' AS DV, '' AS Fecha_Nac, '' AS Estado_Civil, '' AS Direccion, '' AS Comuna, '' AS Ciudad, '' AS PROFESION, 0 AS BLOQ_ANEXO, 0 AS CARR_CCOD, '' AS CARR_TDESC, '' AS ASIG_CCOD, 0 AS ASIG_NHORAS, '' AS ASIG_TDESC, '' AS DUAS_TDESC, 0 AS monto_sesion, 0 AS Valor, '' AS INST_TRAZON_SOCIAL, '' AS NombreRepLeg, '' AS TipoDocente, '' AS Nacionalidad, '' AS FechaI, '' AS FechaF, 0 AS horas_coordinacion, '' AS SECC_TDESC, '' AS sede_tdesc, '' AS num_cuotas, '' AS fecha_inicio, '' AS fecha_fin, '' AS porcentaje, '' AS monto_colacion, '' AS institucion_t, '' AS grado, '' AS institucion_g, '' AS horario, '' AS jerarquia";
     this.oleDbSelectCommand1.Connection  = this.oleDbConnection1;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).EndInit();
 }
Example #2
0
 /// <summary>
 /// M�todo necesario para admitir el Dise�ador, no se puede modificar
 /// el contenido del m�todo con el editor de c�digo.
 /// </summary>
 private void InitializeComponent()
 {
     System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
     this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.contratos1 = new imprimir_anexos.contratos();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CDOC_NCORR", "CDOC_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("pers_ncorr", "pers_ncorr"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Nombre_Docente", "Nombre_Docente"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Rut_Docente", "Rut_Docente"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DV", "DV"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Fecha_Nac", "Fecha_Nac"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Estado_Civil", "Estado_Civil"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Direccion", "Direccion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Comuna", "Comuna"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Ciudad", "Ciudad"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("BLOQ_ANEXO", "BLOQ_ANEXO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ASIG_NHORAS", "ASIG_NHORAS"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ASIG_TDESC", "ASIG_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DUAS_TDESC", "DUAS_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("monto_sesion", "monto_sesion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Valor", "Valor"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INST_TRAZON_SOCIAL", "INST_TRAZON_SOCIAL"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("NombreRepLeg", "NombreRepLeg"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("TipoDocente", "TipoDocente"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Nacionalidad", "Nacionalidad"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("FechaI", "FechaI"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("FechaF", "FechaF"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("horas_coordinacion", "horas_coordinacion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SECC_TDESC", "SECC_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("sede_tdesc", "sede_tdesc"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("num_cuotas", "num_cuotas"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("fecha_inicio", "fecha_inicio"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("fecha_fin", "fecha_fin"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("porcentaje", "porcentaje"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("monto_colacion", "monto_colacion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("institucion_t", "institucion_t"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("grado", "grado"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("institucion_g", "institucion_g"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("horario", "horario"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("jerarquia", "jerarquia")})});
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
     //
     // contratos1
     //
     this.contratos1.DataSetName = "contratos";
     this.contratos1.Locale = new System.Globalization.CultureInfo("en-US");
     this.contratos1.Namespace = "http://www.tempuri.org/contratos.xsd";
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS CDOC_NCORR, 0 AS pers_ncorr, '' AS Nombre_Docente, 0 AS Rut_Docente, '' AS DV, '' AS Fecha_Nac, '' AS Estado_Civil, '' AS Direccion, '' AS Comuna, '' AS Ciudad, '' AS PROFESION, 0 AS BLOQ_ANEXO, 0 AS CARR_CCOD, '' AS CARR_TDESC, '' AS ASIG_CCOD, 0 AS ASIG_NHORAS, '' AS ASIG_TDESC, '' AS DUAS_TDESC, 0 AS monto_sesion, 0 AS Valor, '' AS INST_TRAZON_SOCIAL, '' AS NombreRepLeg, '' AS TipoDocente, '' AS Nacionalidad, '' AS FechaI, '' AS FechaF, 0 AS horas_coordinacion, '' AS SECC_TDESC, '' AS sede_tdesc, '' AS num_cuotas, '' AS fecha_inicio, '' AS fecha_fin, '' AS porcentaje, '' AS monto_colacion, '' AS institucion_t, '' AS grado, '' AS institucion_g, '' AS horario, '' AS jerarquia";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).EndInit();
 }
Example #3
0
 /// <summary>
 /// M�todo necesario para admitir el Dise�ador, no se puede modificar
 /// el contenido del m�todo con el editor de c�digo.
 /// </summary>
 private void InitializeComponent()
 {
     this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.contratos1 = new imprimir_anexos.contratos();
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CDOC_NCORR", "CDOC_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("pers_ncorr", "pers_ncorr"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Nombre_Docente", "Nombre_Docente"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Rut_Docente", "Rut_Docente"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DV", "DV"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Fecha_Nac", "Fecha_Nac"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Estado_Civil", "Estado_Civil"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Direccion", "Direccion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Comuna", "Comuna"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Ciudad", "Ciudad"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("BLOQ_ANEXO", "BLOQ_ANEXO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ASIG_NHORAS", "ASIG_NHORAS"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ASIG_TDESC", "ASIG_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DUAS_TDESC", "DUAS_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("monto_sesion", "monto_sesion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Valor", "Valor"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INST_TRAZON_SOCIAL", "INST_TRAZON_SOCIAL"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("MombreRepLeg", "MombreRepLeg"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("TipoDocente", "TipoDocente"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("Nacionalidad", "Nacionalidad"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("FechaI", "FechaI"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("FechaF", "FechaF"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("horas_coordinacion", "horas_coordinacion"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SECC_TDESC", "SECC_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("sede_tdesc", "sede_tdesc"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("num_cuotas", "num_cuotas"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("fecha_inicio", "fecha_inicio"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("fecha_fin", "fecha_fin")})});
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS CDOC_NCORR, 0 AS pers_ncorr, '' AS Nombre_Docente, 0 AS Rut_Docente, '' AS DV, '' AS Fecha_Nac, '' AS Estado_Civil, '' AS Direccion, '' AS Comuna, '' AS Ciudad, '' AS PROFESION, 0 AS BLOQ_ANEXO, 0 AS CARR_CCOD, '' AS CARR_TDESC, '' AS ASIG_CCOD, 0 AS ASIG_NHORAS, '' AS ASIG_TDESC, '' AS DUAS_TDESC, 0 AS monto_sesion, 0 AS Valor, '' AS INST_TRAZON_SOCIAL, '' AS NombreRepLeg, '' AS TipoDocente, '' AS Nacionalidad, '' AS FechaI, '' AS FechaF, 0 AS horas_coordinacion, '' AS SECC_TDESC, '' AS sede_tdesc, '' AS num_cuotas, '' AS fecha_inicio, '' AS fecha_fin, '' AS porcentaje, '' AS monto_colacion, '' AS institucion_t, '' AS grado, '' AS institucion_g, '' AS horario";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = @"Provider=SQLOLEDB.1;Password=,.protic;Persist Security Info=True;User ID=protic;Initial Catalog=sigaupa;Data Source=sbd01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=JDURAN;Use Encryption for Data=False;Tag with column collation when possible=False";
     this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
     //
     // contratos1
     //
     this.contratos1.DataSetName = "contratos";
     this.contratos1.Locale = new System.Globalization.CultureInfo("en-US");
     this.contratos1.Namespace = "http://www.tempuri.org/contratos.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).EndInit();
 }
Example #4
0
 /// <summary>
 /// Método necesario para admitir el Diseñador, no se puede modificar
 /// el contenido del método con el editor de código.
 /// </summary>
 private void InitializeComponent()
 {
     this.oleDbDataAdapter1   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.contratos1          = new imprimir_anexos.contratos();
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("CDOC_NCORR", "CDOC_NCORR"),
             new System.Data.Common.DataColumnMapping("pers_ncorr", "pers_ncorr"),
             new System.Data.Common.DataColumnMapping("Nombre_Docente", "Nombre_Docente"),
             new System.Data.Common.DataColumnMapping("Rut_Docente", "Rut_Docente"),
             new System.Data.Common.DataColumnMapping("DV", "DV"),
             new System.Data.Common.DataColumnMapping("Fecha_Nac", "Fecha_Nac"),
             new System.Data.Common.DataColumnMapping("Estado_Civil", "Estado_Civil"),
             new System.Data.Common.DataColumnMapping("Direccion", "Direccion"),
             new System.Data.Common.DataColumnMapping("Comuna", "Comuna"),
             new System.Data.Common.DataColumnMapping("Ciudad", "Ciudad"),
             new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
             new System.Data.Common.DataColumnMapping("BLOQ_ANEXO", "BLOQ_ANEXO"),
             new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
             new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
             new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"),
             new System.Data.Common.DataColumnMapping("ASIG_NHORAS", "ASIG_NHORAS"),
             new System.Data.Common.DataColumnMapping("ASIG_TDESC", "ASIG_TDESC"),
             new System.Data.Common.DataColumnMapping("DUAS_TDESC", "DUAS_TDESC"),
             new System.Data.Common.DataColumnMapping("monto_sesion", "monto_sesion"),
             new System.Data.Common.DataColumnMapping("Valor", "Valor"),
             new System.Data.Common.DataColumnMapping("INST_TRAZON_SOCIAL", "INST_TRAZON_SOCIAL"),
             new System.Data.Common.DataColumnMapping("MombreRepLeg", "MombreRepLeg"),
             new System.Data.Common.DataColumnMapping("TipoDocente", "TipoDocente"),
             new System.Data.Common.DataColumnMapping("Nacionalidad", "Nacionalidad"),
             new System.Data.Common.DataColumnMapping("FechaI", "FechaI"),
             new System.Data.Common.DataColumnMapping("FechaF", "FechaF"),
             new System.Data.Common.DataColumnMapping("horas_coordinacion", "horas_coordinacion"),
             new System.Data.Common.DataColumnMapping("SECC_TDESC", "SECC_TDESC"),
             new System.Data.Common.DataColumnMapping("sede_tdesc", "sede_tdesc"),
             new System.Data.Common.DataColumnMapping("num_cuotas", "num_cuotas"),
             new System.Data.Common.DataColumnMapping("fecha_inicio", "fecha_inicio"),
             new System.Data.Common.DataColumnMapping("fecha_fin", "fecha_fin")
         })
     });
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS CDOC_NCORR, 0 AS pers_ncorr, '' AS Nombre_Docente, 0 AS Rut_Docente, '' AS DV, '' AS Fecha_Nac, '' AS Estado_Civil, '' AS Direccion, '' AS Comuna, '' AS Ciudad, '' AS PROFESION, 0 AS BLOQ_ANEXO, 0 AS CARR_CCOD, '' AS CARR_TDESC, '' AS ASIG_CCOD, 0 AS ASIG_NHORAS, '' AS ASIG_TDESC, '' AS DUAS_TDESC, 0 AS monto_sesion, 0 AS Valor, '' AS INST_TRAZON_SOCIAL, '' AS NombreRepLeg, '' AS TipoDocente, '' AS Nacionalidad, '' AS FechaI, '' AS FechaF, 0 AS horas_coordinacion, '' AS SECC_TDESC, '' AS sede_tdesc, '' AS num_cuotas, '' AS fecha_inicio, '' AS fecha_fin, '' AS porcentaje, '' AS monto_colacion, '' AS institucion_t, '' AS grado, '' AS institucion_g, '' AS horario";
     this.oleDbSelectCommand1.Connection  = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = @"Provider=SQLOLEDB.1;Password=,.protic;Persist Security Info=True;User ID=protic;Initial Catalog=sigaupa;Data Source=sbd01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=JDURAN;Use Encryption for Data=False;Tag with column collation when possible=False";
     this.oleDbConnection1.InfoMessage     += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
     //
     // contratos1
     //
     this.contratos1.DataSetName = "contratos";
     this.contratos1.Locale      = new System.Globalization.CultureInfo("en-US");
     this.contratos1.Namespace   = "http://www.tempuri.org/contratos.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.contratos1)).EndInit();
 }