Пример #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.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.dataSet11           = new informe_beneficios.DataSet1();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).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("TBEN_TDESC", "TBEN_TDESC"),
             new System.Data.Common.DataColumnMapping("STDE_CCOD", "STDE_CCOD"),
             new System.Data.Common.DataColumnMapping("STDE_TDESC", "STDE_TDESC"),
             new System.Data.Common.DataColumnMapping("ESDE_TDESC", "ESDE_TDESC"),
             new System.Data.Common.DataColumnMapping("POST_NCORR", "POST_NCORR"),
             new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"),
             new System.Data.Common.DataColumnMapping("ESDE_TDESC1", "ESDE_TDESC1"),
             new System.Data.Common.DataColumnMapping("OFER_NCORR", "OFER_NCORR"),
             new System.Data.Common.DataColumnMapping("SEDE_CCOD", "SEDE_CCOD"),
             new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"),
             new System.Data.Common.DataColumnMapping("PERS_NRUT", "PERS_NRUT"),
             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
             new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
             new System.Data.Common.DataColumnMapping("SDES_MMATRICULA", "SDES_MMATRICULA"),
             new System.Data.Common.DataColumnMapping("SDES_NPORC_MATRICULA", "SDES_NPORC_MATRICULA"),
             new System.Data.Common.DataColumnMapping("SDES_MCOLEGIATURA", "SDES_MCOLEGIATURA"),
             new System.Data.Common.DataColumnMapping("SDES_NPORC_COLEGIATURA", "SDES_NPORC_COLEGIATURA"),
             new System.Data.Common.DataColumnMapping("SUBTOTAL", "SUBTOTAL"),
             new System.Data.Common.DataColumnMapping("ESDE_CCOD", "ESDE_CCOD")
         })
     });
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' AS TBEN_TDESC, '' AS STDE_CCOD, '' AS STDE_TDESC, '' AS ESDE_TDESC, '' AS POST_NCORR, '' AS PERS_NCORR, '' AS ESDE_TDESC, '' AS OFER_NCORR, '' AS SEDE_CCOD, '' AS RUT_ALUMNO, '' AS PERS_NRUT, '' AS NOMBRE_ALUMNO, '' AS CARR_TDESC, '' AS SDES_MMATRICULA, '' AS SDES_NPORC_MATRICULA, '' AS SDES_MCOLEGIATURA, '' AS SDES_NPORC_COLEGIATURA, '' AS SUBTOTAL, '' AS ESDE_CCOD FROM DUAL";
     this.oleDbSelectCommand1.Connection  = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     this.oleDbConnection1.InfoMessage     += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
     //
     // dataSet11
     //
     this.dataSet11.DataSetName = "DataSet1";
     this.dataSet11.Locale      = new System.Globalization.CultureInfo("es-CL");
     this.dataSet11.Namespace   = "http://www.tempuri.org/DataSet1.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
 }
Пример #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.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.dataSet11 = new informe_beneficios.DataSet1();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).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("TBEN_TDESC", "TBEN_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("STDE_CCOD", "STDE_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("STDE_TDESC", "STDE_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ESDE_TDESC", "ESDE_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("POST_NCORR", "POST_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ESDE_TDESC1", "ESDE_TDESC1"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("OFER_NCORR", "OFER_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SEDE_CCOD", "SEDE_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("PERS_NRUT", "PERS_NRUT"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SDES_MMATRICULA", "SDES_MMATRICULA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SDES_NPORC_MATRICULA", "SDES_NPORC_MATRICULA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SDES_MCOLEGIATURA", "SDES_MCOLEGIATURA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SDES_NPORC_COLEGIATURA", "SDES_NPORC_COLEGIATURA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SUBTOTAL", "SUBTOTAL"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ESDE_CCOD", "ESDE_CCOD")})});
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' AS TBEN_TDESC, '' AS STDE_CCOD, '' AS STDE_TDESC, '' AS ESDE_TDESC, '' AS POST_NCORR, '' AS PERS_NCORR, '' AS ESDE_TDESC, '' AS OFER_NCORR, '' AS SEDE_CCOD, '' AS RUT_ALUMNO, '' AS PERS_NRUT, '' AS NOMBRE_ALUMNO, '' AS CARR_TDESC, '' AS SDES_MMATRICULA, '' AS SDES_NPORC_MATRICULA, '' AS SDES_MCOLEGIATURA, '' AS SDES_NPORC_COLEGIATURA, '' AS SUBTOTAL, '' AS ESDE_CCOD FROM DUAL";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
     //
     // dataSet11
     //
     this.dataSet11.DataSetName = "DataSet1";
     this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL");
     this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
 }