Exemplo n.º 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.adpDetalles         = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.conexion            = new System.Data.OleDb.OleDbConnection();
     this.ds                  = new retiros_condonaciones.DataSet1();
     this.adpEncabezado       = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
     //
     // adpDetalles
     //
     this.adpDetalles.SelectCommand = this.oleDbSelectCommand1;
     this.adpDetalles.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "DETALLES", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
             new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
             new System.Data.Common.DataColumnMapping("TOTAL_01", "TOTAL_01"),
             new System.Data.Common.DataColumnMapping("TOTAL_02", "TOTAL_02"),
             new System.Data.Common.DataColumnMapping("TOTAL_03", "TOTAL_03"),
             new System.Data.Common.DataColumnMapping("TOTAL_04", "TOTAL_04"),
             new System.Data.Common.DataColumnMapping("TOTAL_05", "TOTAL_05"),
             new System.Data.Common.DataColumnMapping("TOTAL_06", "TOTAL_06"),
             new System.Data.Common.DataColumnMapping("TOTAL_07", "TOTAL_07"),
             new System.Data.Common.DataColumnMapping("TOTAL_08", "TOTAL_08"),
             new System.Data.Common.DataColumnMapping("TOTAL_09", "TOTAL_09"),
             new System.Data.Common.DataColumnMapping("TOTAL_10", "TOTAL_10"),
             new System.Data.Common.DataColumnMapping("TOTAL_11", "TOTAL_11"),
             new System.Data.Common.DataColumnMapping("TOTAL_12", "TOTAL_12")
         })
     });
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS CARR_TDESC, \'\' AS TING_TDESC, 0 AS TOTAL_01, 0 AS TOTAL_02, 0 AS TOT" +
                                            "AL_03, 0 AS TOTAL_04, 0 AS TOTAL_05, 0 AS TOTAL_06, 0 AS TOTAL_07, 0 AS TOTAL_08" +
                                            ", 0 AS TOTAL_09, 0 AS TOTAL_10, 0 AS TOTAL_11, 0 AS TOTAL_12 FROM DUAL";
     this.oleDbSelectCommand1.Connection = this.conexion;
     //
     // conexion
     //
     this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // ds
     //
     this.ds.DataSetName = "DataSet1";
     this.ds.Locale      = new System.Globalization.CultureInfo("es-CL");
     this.ds.Namespace   = "http://www.tempuri.org/DataSet1.xsd";
     //
     // adpEncabezado
     //
     this.adpEncabezado.SelectCommand = this.oleDbSelectCommand2;
     this.adpEncabezado.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "ENCABEZADO", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD"),
             new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC")
         })
     });
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT 0 AS ANOS_CCOD, \'\' AS SEDE_TDESC FROM DUAL";
     this.oleDbSelectCommand2.Connection  = this.conexion;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
 }
Exemplo n.º 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.adpDetalles = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.conexion = new System.Data.OleDb.OleDbConnection();
     this.ds = new retiros_condonaciones.DataSet1();
     this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
     //
     // adpDetalles
     //
     this.adpDetalles.SelectCommand = this.oleDbSelectCommand1;
     this.adpDetalles.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                           new System.Data.Common.DataTableMapping("Table", "DETALLES", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_01", "TOTAL_01"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_02", "TOTAL_02"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_03", "TOTAL_03"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_04", "TOTAL_04"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_05", "TOTAL_05"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_06", "TOTAL_06"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_07", "TOTAL_07"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_08", "TOTAL_08"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_09", "TOTAL_09"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_10", "TOTAL_10"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_11", "TOTAL_11"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TOTAL_12", "TOTAL_12")})});
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS CARR_TDESC, \'\' AS TING_TDESC, 0 AS TOTAL_01, 0 AS TOTAL_02, 0 AS TOT" +
         "AL_03, 0 AS TOTAL_04, 0 AS TOTAL_05, 0 AS TOTAL_06, 0 AS TOTAL_07, 0 AS TOTAL_08" +
         ", 0 AS TOTAL_09, 0 AS TOTAL_10, 0 AS TOTAL_11, 0 AS TOTAL_12 FROM DUAL";
     this.oleDbSelectCommand1.Connection = this.conexion;
     //
     // conexion
     //
     this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // ds
     //
     this.ds.DataSetName = "DataSet1";
     this.ds.Locale = new System.Globalization.CultureInfo("es-CL");
     this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd";
     //
     // adpEncabezado
     //
     this.adpEncabezado.SelectCommand = this.oleDbSelectCommand2;
     this.adpEncabezado.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                             new System.Data.Common.DataTableMapping("Table", "ENCABEZADO", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD"),
                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC")})});
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT 0 AS ANOS_CCOD, \'\' AS SEDE_TDESC FROM DUAL";
     this.oleDbSelectCommand2.Connection = this.conexion;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
 }