/// <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.adpDatos = new System.Data.OleDb.OleDbDataAdapter(); this.conexion = new System.Data.OleDb.OleDbConnection(); this.ds = new flujo_venc_cursos.DataSet1(); this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit(); // // adpDatos // this.adpDatos.SelectCommand = this.oleDbSelectCommand1; this.adpDatos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "CURSOS", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("TDET_TDESC", "TDET_TDESC"), new System.Data.Common.DataColumnMapping("IGAS_TCODIGO", "IGAS_TCODIGO"), new System.Data.Common.DataColumnMapping("CCOS_TCODIGO", "CCOS_TCODIGO"), new System.Data.Common.DataColumnMapping("SEMESTRE", "SEMESTRE"), new System.Data.Common.DataColumnMapping("COMP_01", "COMP_01"), new System.Data.Common.DataColumnMapping("COMP_02", "COMP_02"), new System.Data.Common.DataColumnMapping("COMP_03", "COMP_03"), new System.Data.Common.DataColumnMapping("COMP_04", "COMP_04"), new System.Data.Common.DataColumnMapping("COMP_05", "COMP_05"), new System.Data.Common.DataColumnMapping("COMP_06", "COMP_06"), new System.Data.Common.DataColumnMapping("REAL_01", "REAL_01"), new System.Data.Common.DataColumnMapping("REAL_02", "REAL_02"), new System.Data.Common.DataColumnMapping("REAL_03", "REAL_03"), new System.Data.Common.DataColumnMapping("REAL_04", "REAL_04"), new System.Data.Common.DataColumnMapping("REAL_05", "REAL_05"), new System.Data.Common.DataColumnMapping("REAL_06", "REAL_06"), new System.Data.Common.DataColumnMapping("VARIACION_01", "VARIACION_01"), new System.Data.Common.DataColumnMapping("VARIACION_02", "VARIACION_02"), new System.Data.Common.DataColumnMapping("VARIACION_03", "VARIACION_03"), new System.Data.Common.DataColumnMapping("VARIACION_04", "VARIACION_04"), new System.Data.Common.DataColumnMapping("VARIACION_05", "VARIACION_05"), new System.Data.Common.DataColumnMapping("VARIACION_06", "VARIACION_06"), new System.Data.Common.DataColumnMapping("COMP_SEMESTRE", "COMP_SEMESTRE"), new System.Data.Common.DataColumnMapping("REAL_SEMESTRE", "REAL_SEMESTRE"), new System.Data.Common.DataColumnMapping("VARIACION_SEMESTRE", "VARIACION_SEMESTRE") }) }); // // 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("SEDE_TDESC", "SEDE_TDESC"), new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD") }) }); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT A.SEDE_TDESC, B.ANOS_CCOD, A.SEDE_CCOD FROM SEDES A, ANOS B WHERE (A.SEDE_" + "CCOD = ?) AND (B.ANOS_CCOD = ?)"; this.oleDbSelectCommand2.Connection = this.conexion; this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SEDE_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "SEDE_CCOD", System.Data.DataRowVersion.Current, null)); this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ANOS_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(0)), "ANOS_CCOD", System.Data.DataRowVersion.Current, null)); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS TDET_TDESC, '' AS IGAS_TCODIGO, '' AS CCOS_TCODIGO, 0 AS SEMESTRE, 0 AS COMP_01, 0 AS COMP_02, 0 AS COMP_03, 0 AS COMP_04, 0 AS COMP_05, 0 AS COMP_06, 0 AS REAL_01, 0 AS REAL_02, 0 AS REAL_03, 0 AS REAL_04, 0 AS REAL_05, 0 AS REAL_06, 0 AS VARIACION_01, 0 AS VARIACION_02, 0 AS VARIACION_03, 0 AS VARIACION_04, 0 AS VARIACION_05, 0 AS VARIACION_06, 0 AS COMP_SEMESTRE, 0 AS REAL_SEMESTRE, 0 AS VARIACION_SEMESTRE FROM DUAL"; this.oleDbSelectCommand1.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.adpDatos = new System.Data.OleDb.OleDbDataAdapter(); this.conexion = new System.Data.OleDb.OleDbConnection(); this.ds = new flujo_venc_cursos.DataSet1(); this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit(); // // adpDatos // this.adpDatos.SelectCommand = this.oleDbSelectCommand1; this.adpDatos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "CURSOS", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("TDET_TDESC", "TDET_TDESC"), new System.Data.Common.DataColumnMapping("IGAS_TCODIGO", "IGAS_TCODIGO"), new System.Data.Common.DataColumnMapping("CCOS_TCODIGO", "CCOS_TCODIGO"), new System.Data.Common.DataColumnMapping("SEMESTRE", "SEMESTRE"), new System.Data.Common.DataColumnMapping("COMP_01", "COMP_01"), new System.Data.Common.DataColumnMapping("COMP_02", "COMP_02"), new System.Data.Common.DataColumnMapping("COMP_03", "COMP_03"), new System.Data.Common.DataColumnMapping("COMP_04", "COMP_04"), new System.Data.Common.DataColumnMapping("COMP_05", "COMP_05"), new System.Data.Common.DataColumnMapping("COMP_06", "COMP_06"), new System.Data.Common.DataColumnMapping("REAL_01", "REAL_01"), new System.Data.Common.DataColumnMapping("REAL_02", "REAL_02"), new System.Data.Common.DataColumnMapping("REAL_03", "REAL_03"), new System.Data.Common.DataColumnMapping("REAL_04", "REAL_04"), new System.Data.Common.DataColumnMapping("REAL_05", "REAL_05"), new System.Data.Common.DataColumnMapping("REAL_06", "REAL_06"), new System.Data.Common.DataColumnMapping("VARIACION_01", "VARIACION_01"), new System.Data.Common.DataColumnMapping("VARIACION_02", "VARIACION_02"), new System.Data.Common.DataColumnMapping("VARIACION_03", "VARIACION_03"), new System.Data.Common.DataColumnMapping("VARIACION_04", "VARIACION_04"), new System.Data.Common.DataColumnMapping("VARIACION_05", "VARIACION_05"), new System.Data.Common.DataColumnMapping("VARIACION_06", "VARIACION_06"), new System.Data.Common.DataColumnMapping("COMP_SEMESTRE", "COMP_SEMESTRE"), new System.Data.Common.DataColumnMapping("REAL_SEMESTRE", "REAL_SEMESTRE"), new System.Data.Common.DataColumnMapping("VARIACION_SEMESTRE", "VARIACION_SEMESTRE")})}); // // 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("SEDE_TDESC", "SEDE_TDESC"), new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD")})}); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT A.SEDE_TDESC, B.ANOS_CCOD, A.SEDE_CCOD FROM SEDES A, ANOS B WHERE (A.SEDE_" + "CCOD = ?) AND (B.ANOS_CCOD = ?)"; this.oleDbSelectCommand2.Connection = this.conexion; this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SEDE_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "SEDE_CCOD", System.Data.DataRowVersion.Current, null)); this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ANOS_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(0)), "ANOS_CCOD", System.Data.DataRowVersion.Current, null)); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS TDET_TDESC, '' AS IGAS_TCODIGO, '' AS CCOS_TCODIGO, 0 AS SEMESTRE, 0 AS COMP_01, 0 AS COMP_02, 0 AS COMP_03, 0 AS COMP_04, 0 AS COMP_05, 0 AS COMP_06, 0 AS REAL_01, 0 AS REAL_02, 0 AS REAL_03, 0 AS REAL_04, 0 AS REAL_05, 0 AS REAL_06, 0 AS VARIACION_01, 0 AS VARIACION_02, 0 AS VARIACION_03, 0 AS VARIACION_04, 0 AS VARIACION_05, 0 AS VARIACION_06, 0 AS COMP_SEMESTRE, 0 AS REAL_SEMESTRE, 0 AS VARIACION_SEMESTRE FROM DUAL"; this.oleDbSelectCommand1.Connection = this.conexion; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit(); }