Beispiel #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()
 {
     this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.datosContrato2 = new contrato_antiguo.datosContrato();
     ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("text_antiguo", "text_antiguo"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("jorn_tdesc", "jorn_tdesc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("emailp", "emailp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("eciv_tdescp", "eciv_tdescp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pais_tdescp", "pais_tdescp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pers_tprofesionp", "pers_tprofesionp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("emailppc", "emailppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("eciv_tdescppc", "eciv_tdescppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pais_tdescppc", "pais_tdescppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pers_tprofesionppc", "pers_tprofesionppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("nro_informe", "nro_informe"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NRO_INFORME1", "NRO_INFORME1"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_INFORME", "NOMBRE_INFORME"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NRO_CONTRATO", "NRO_CONTRATO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_REPRESENTANTE", "NOMBRE_REPRESENTANTE"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("EDAD", "EDAD"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NRO_DOCTO", "NRO_DOCTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A")})});
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NRO_INFORME, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS NOMBRE_REPRESENTANTE, '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" +
         "ial catalog=protic2";
     //
     // datosContrato2
     //
     this.datosContrato2.DataSetName = "datosContrato";
     this.datosContrato2.Locale = new System.Globalization.CultureInfo("es-ES");
     this.datosContrato2.Namespace = "http://www.tempuri.org/datosContrato.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).EndInit();
 }
Beispiel #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()
 {
     this.oleDbDataAdapter1   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.datosContrato2      = new contrato_antiguo.datosContrato();
     ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("text_antiguo", "text_antiguo"),
             new System.Data.Common.DataColumnMapping("jorn_tdesc", "jorn_tdesc"),
             new System.Data.Common.DataColumnMapping("emailp", "emailp"),
             new System.Data.Common.DataColumnMapping("eciv_tdescp", "eciv_tdescp"),
             new System.Data.Common.DataColumnMapping("pais_tdescp", "pais_tdescp"),
             new System.Data.Common.DataColumnMapping("pers_tprofesionp", "pers_tprofesionp"),
             new System.Data.Common.DataColumnMapping("emailppc", "emailppc"),
             new System.Data.Common.DataColumnMapping("eciv_tdescppc", "eciv_tdescppc"),
             new System.Data.Common.DataColumnMapping("pais_tdescppc", "pais_tdescppc"),
             new System.Data.Common.DataColumnMapping("pers_tprofesionppc", "pers_tprofesionppc"),
             new System.Data.Common.DataColumnMapping("nro_informe", "nro_informe"),
             new System.Data.Common.DataColumnMapping("NRO_INFORME1", "NRO_INFORME1"),
             new System.Data.Common.DataColumnMapping("NOMBRE_INFORME", "NOMBRE_INFORME"),
             new System.Data.Common.DataColumnMapping("NRO_CONTRATO", "NRO_CONTRATO"),
             new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"),
             new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"),
             new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"),
             new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_REPRESENTANTE", "NOMBRE_REPRESENTANTE"),
             new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"),
             new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"),
             new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"),
             new System.Data.Common.DataColumnMapping("EDAD", "EDAD"),
             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
             new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
             new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"),
             new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
             new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
             new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
             new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"),
             new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"),
             new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
             new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"),
             new System.Data.Common.DataColumnMapping("NRO_DOCTO", "NRO_DOCTO"),
             new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
             new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"),
             new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A")
         })
     });
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NRO_INFORME, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS NOMBRE_REPRESENTANTE, '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A";
     this.oleDbSelectCommand1.Connection  = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" +
                                              "ial catalog=protic2";
     //
     // datosContrato2
     //
     this.datosContrato2.DataSetName = "datosContrato";
     this.datosContrato2.Locale      = new System.Globalization.CultureInfo("es-ES");
     this.datosContrato2.Namespace   = "http://www.tempuri.org/datosContrato.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).EndInit();
 }