/// <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.adpAlumnos = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.conexion = new System.Data.OleDb.OleDbConnection(); this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.ds = new acta_final.DataSet1(); ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit(); // // adpAlumnos // this.adpAlumnos.SelectCommand = this.oleDbSelectCommand1; this.adpAlumnos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ALUMNOS", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("RUT", "RUT"), new System.Data.Common.DataColumnMapping("PERS_NRUT", "PERS_NRUT"), new System.Data.Common.DataColumnMapping("PERS_TAPE_PATERNO", "PERS_TAPE_PATERNO"), new System.Data.Common.DataColumnMapping("PERS_TAPE_MATERNO", "PERS_TAPE_MATERNO"), new System.Data.Common.DataColumnMapping("PERS_TNOMBRE", "PERS_TNOMBRE"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_PRESENTACION", "CARG_NNOTA_PRESENTACION"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_EXAMEN", "CARG_NNOTA_EXAMEN"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_REPETICION", "CARG_NNOTA_REPETICION"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_FINAL", "CARG_NNOTA_FINAL")})}); this.adpAlumnos.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.adpAlumnos_RowUpdated); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS RUT, \'\' AS PERS_NRUT, \'\' AS PERS_TAPE_PATERNO, \'\' AS PERS_TAPE_MATER" + "NO, \'\' AS PERS_TNOMBRE, \'\' AS CARG_NNOTA_PRESENTACION, \'\' AS CARG_NNOTA_EXAMEN, " + "\'\' AS CARG_NNOTA_REPETICION, \'\' AS CARG_NNOTA_FINAL, \'\' AS PERS_NCORR, \'\' AS SIT" + "F_CCOD"; this.oleDbSelectCommand1.Connection = this.conexion; // // conexion // this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); this.conexion.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.conexion_InfoMessage); // // 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("ASIG_TDESC", "ASIG_TDESC"), new System.Data.Common.DataColumnMapping("DUAS_TDESC", "DUAS_TDESC"), new System.Data.Common.DataColumnMapping("SECC_TDESC", "SECC_TDESC"), new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"), new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD"), new System.Data.Common.DataColumnMapping("PLEC_CCOD", "PLEC_CCOD"), new System.Data.Common.DataColumnMapping("PROFESOR", "PROFESOR"), new System.Data.Common.DataColumnMapping("PROFESOR_MIN", "PROFESOR_MIN"), new System.Data.Common.DataColumnMapping("DIRECTOR_CARRERA", "DIRECTOR_CARRERA"), new System.Data.Common.DataColumnMapping("SECC_CCOD", "SECC_CCOD"), new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"), new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"), new System.Data.Common.DataColumnMapping("PERI_CCOD", "PERI_CCOD")})}); this.adpEncabezado.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.adpEncabezado_RowUpdated); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS ASIG_TDESC, \'\' AS DUAS_TDESC, \'\' AS SECC_TDESC, \'\' AS CARR_TDESC, \'\'" + " AS ANOS_CCOD, \'\' AS PLEC_CCOD, \'\' AS PROFESOR, \'\' AS PROFESOR_MIN, \'\' AS DIRECT" + "OR_CARRERA, \'\' AS SECC_CCOD, \'\' AS ASIG_CCOD, \'\' AS CARR_CCOD, \'\' AS PERI_CCOD"; this.oleDbSelectCommand2.Connection = this.conexion; // // ds // this.ds.DataSetName = "DataSet1"; this.ds.Locale = new System.Globalization.CultureInfo("es-CL"); this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd"; 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.adpAlumnos = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.conexion = new System.Data.OleDb.OleDbConnection(); this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.ds = new acta_final.DataSet1(); ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit(); // // adpAlumnos // this.adpAlumnos.SelectCommand = this.oleDbSelectCommand1; this.adpAlumnos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ALUMNOS", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("RUT", "RUT"), new System.Data.Common.DataColumnMapping("PERS_NRUT", "PERS_NRUT"), new System.Data.Common.DataColumnMapping("PERS_TAPE_PATERNO", "PERS_TAPE_PATERNO"), new System.Data.Common.DataColumnMapping("PERS_TAPE_MATERNO", "PERS_TAPE_MATERNO"), new System.Data.Common.DataColumnMapping("PERS_TNOMBRE", "PERS_TNOMBRE"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_PRESENTACION", "CARG_NNOTA_PRESENTACION"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_EXAMEN", "CARG_NNOTA_EXAMEN"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_REPETICION", "CARG_NNOTA_REPETICION"), new System.Data.Common.DataColumnMapping("CARG_NNOTA_FINAL", "CARG_NNOTA_FINAL") }) }); this.adpAlumnos.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.adpAlumnos_RowUpdated); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS RUT, \'\' AS PERS_NRUT, \'\' AS PERS_TAPE_PATERNO, \'\' AS PERS_TAPE_MATER" + "NO, \'\' AS PERS_TNOMBRE, \'\' AS CARG_NNOTA_PRESENTACION, \'\' AS CARG_NNOTA_EXAMEN, " + "\'\' AS CARG_NNOTA_REPETICION, \'\' AS CARG_NNOTA_FINAL, \'\' AS PERS_NCORR, \'\' AS SIT" + "F_CCOD"; this.oleDbSelectCommand1.Connection = this.conexion; // // conexion // this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); this.conexion.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.conexion_InfoMessage); // // 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("ASIG_TDESC", "ASIG_TDESC"), new System.Data.Common.DataColumnMapping("DUAS_TDESC", "DUAS_TDESC"), new System.Data.Common.DataColumnMapping("SECC_TDESC", "SECC_TDESC"), new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"), new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD"), new System.Data.Common.DataColumnMapping("PLEC_CCOD", "PLEC_CCOD"), new System.Data.Common.DataColumnMapping("PROFESOR", "PROFESOR"), new System.Data.Common.DataColumnMapping("PROFESOR_MIN", "PROFESOR_MIN"), new System.Data.Common.DataColumnMapping("DIRECTOR_CARRERA", "DIRECTOR_CARRERA"), new System.Data.Common.DataColumnMapping("SECC_CCOD", "SECC_CCOD"), new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"), new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"), new System.Data.Common.DataColumnMapping("PERI_CCOD", "PERI_CCOD") }) }); this.adpEncabezado.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.adpEncabezado_RowUpdated); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS ASIG_TDESC, \'\' AS DUAS_TDESC, \'\' AS SECC_TDESC, \'\' AS CARR_TDESC, \'\'" + " AS ANOS_CCOD, \'\' AS PLEC_CCOD, \'\' AS PROFESOR, \'\' AS PROFESOR_MIN, \'\' AS DIRECT" + "OR_CARRERA, \'\' AS SECC_CCOD, \'\' AS ASIG_CCOD, \'\' AS CARR_CCOD, \'\' AS PERI_CCOD"; this.oleDbSelectCommand2.Connection = this.conexion; // // ds // this.ds.DataSetName = "DataSet1"; this.ds.Locale = new System.Globalization.CultureInfo("es-CL"); this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd"; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit(); }