/// <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(); }
/// <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(); }