コード例 #1
0
ファイル: acta_final.aspx.cs プロジェクト: yesashii/upa
 /// <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();
 }
コード例 #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.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();
 }