private void InitializeComponent() { System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.dataSet11 = new CuentaCorriente.DataSet1(); this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter4 = new System.Data.OleDb.OleDbDataAdapter(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_detalles", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"), new System.Data.Common.DataColumnMapping("INST_CCOD", "INST_CCOD"), new System.Data.Common.DataColumnMapping("COMP_NDOCTO", "COMP_NDOCTO"), new System.Data.Common.DataColumnMapping("TCOM_CCOD", "TCOM_CCOD"), new System.Data.Common.DataColumnMapping("DCOM_NCOMPROMISO", "DCOM_NCOMPROMISO"), new System.Data.Common.DataColumnMapping("NCUOTA", "NCUOTA"), new System.Data.Common.DataColumnMapping("COMP_FDOCTO", "COMP_FDOCTO"), new System.Data.Common.DataColumnMapping("DCOM_FCOMPROMISO", "DCOM_FCOMPROMISO"), new System.Data.Common.DataColumnMapping("DCOM_MCOMPROMISO", "DCOM_MCOMPROMISO"), new System.Data.Common.DataColumnMapping("TING_CCOD", "TING_CCOD"), new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"), new System.Data.Common.DataColumnMapping("ABONOS", "ABONOS"), new System.Data.Common.DataColumnMapping("SALDO", "SALDO"), new System.Data.Common.DataColumnMapping("EDIN_CCOD", "EDIN_CCOD"), new System.Data.Common.DataColumnMapping("EDIN_TDESC", "EDIN_TDESC"), new System.Data.Common.DataColumnMapping("TCOM_TDESC", "TCOM_TDESC"), new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"), new System.Data.Common.DataColumnMapping("DOCUMENTADO", "DOCUMENTADO") }) }); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS PERS_NCORR, '' AS INST_CCOD, '' AS COMP_NDOCTO, '' AS TCOM_CCOD, '' AS DCOM_NCOMPROMISO, '' AS NCUOTA, '' AS COMP_FDOCTO, '' AS DCOM_FCOMPROMISO, '' AS DCOM_MCOMPROMISO, '' AS TING_CCOD, '' AS DING_NDOCTO, '' AS ABONOS, '' AS SALDO, '' AS EDIN_CCOD, '' AS EDIN_TDESC, '' AS TCOM_TDESC, '' AS TING_TDESC, '' AS DOCUMENTADO "; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL"); this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd"; // // oleDbDataAdapter2 // this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2; this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Alumno", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"), new System.Data.Common.DataColumnMapping("RUT", "RUT"), new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"), new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"), new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"), new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"), new System.Data.Common.DataColumnMapping("ESTADO_MATRICULA", "ESTADO_MATRICULA"), new System.Data.Common.DataColumnMapping("ESTADO_ALUMNO", "ESTADO_ALUMNO") }) }); this.oleDbDataAdapter2.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter2_RowUpdated); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS PERS_NCORR, \'\' AS RUT, \'\' AS NOMBRE, \'\' AS CARR_TDESC, \'\' AS SEDE_TD" + "ESC, \'\' AS ANO_INGRESO, \'\' AS ESTADO_MATRICULA, \'\' AS ESTADO_ALUMNO, \'\' AS ingre" + "so_u, \'\' AS PERI_TDESC"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbDataAdapter3 // this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3; this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Creditos", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("STDE_CCOD", "STDE_CCOD"), new System.Data.Common.DataColumnMapping("STDE_TDESC", "STDE_TDESC"), new System.Data.Common.DataColumnMapping("BENE_MMONTO", "BENE_MMONTO"), new System.Data.Common.DataColumnMapping("MONE_CCOD", "MONE_CCOD"), new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_MATRICULA", "BENE_NPORCENTAJE_MATRICULA"), new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_COLEGIATURA", "BENE_NPORCENTAJE_COLEGIATURA"), new System.Data.Common.DataColumnMapping("TBEN_CCOD", "TBEN_CCOD"), new System.Data.Common.DataColumnMapping("BENE_FBENEFICIO", "BENE_FBENEFICIO") }) }); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS contrato, \'\' AS CONT_NCORR, \'\' AS STDE_CCOD, \'\' AS STDE_TDESC, \'\' AS" + " BENE_MMONTO, \'\' AS MONE_CCOD, \'\' AS BENE_NPORCENTAJE_MATRICULA, \'\' AS BENE_NPOR" + "CENTAJE_COLEGIATURA, \'\' AS TBEN_CCOD, \'\' AS BENE_FBENEFICIO"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT \'\' AS COME_NCORR, \'\' AS COME_TCOMENTARIO, \'\' AS COME_FCOMENTARIO, \'\' AS TI" + "CO_TDESC, \'\' AS PERS_NCORR_AUTOR"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbDataAdapter4 // this.oleDbDataAdapter4.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbDataAdapter4.InsertCommand = this.oleDbInsertCommand1; this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4; this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Comentarios", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("COME_NCORR", "COME_NCORR"), new System.Data.Common.DataColumnMapping("COME_TCOMENTARIO", "COME_TCOMENTARIO"), new System.Data.Common.DataColumnMapping("COME_FCOMENTARIO", "COME_FCOMENTARIO"), new System.Data.Common.DataColumnMapping("TICO_TDESC", "TICO_TDESC"), new System.Data.Common.DataColumnMapping("PERS_NCORR_AUTOR", "PERS_NCORR_AUTOR") }) }); this.oleDbDataAdapter4.UpdateCommand = this.oleDbUpdateCommand1; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); }
private void InitializeComponent() { System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.dataSet11 = new CuentaCorriente.DataSet1(); this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter4 = new System.Data.OleDb.OleDbDataAdapter(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_detalles", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"), new System.Data.Common.DataColumnMapping("INST_CCOD", "INST_CCOD"), new System.Data.Common.DataColumnMapping("COMP_NDOCTO", "COMP_NDOCTO"), new System.Data.Common.DataColumnMapping("TCOM_CCOD", "TCOM_CCOD"), new System.Data.Common.DataColumnMapping("DCOM_NCOMPROMISO", "DCOM_NCOMPROMISO"), new System.Data.Common.DataColumnMapping("NCUOTA", "NCUOTA"), new System.Data.Common.DataColumnMapping("COMP_FDOCTO", "COMP_FDOCTO"), new System.Data.Common.DataColumnMapping("DCOM_FCOMPROMISO", "DCOM_FCOMPROMISO"), new System.Data.Common.DataColumnMapping("DCOM_MCOMPROMISO", "DCOM_MCOMPROMISO"), new System.Data.Common.DataColumnMapping("TING_CCOD", "TING_CCOD"), new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"), new System.Data.Common.DataColumnMapping("ABONOS", "ABONOS"), new System.Data.Common.DataColumnMapping("SALDO", "SALDO"), new System.Data.Common.DataColumnMapping("EDIN_CCOD", "EDIN_CCOD"), new System.Data.Common.DataColumnMapping("EDIN_TDESC", "EDIN_TDESC"), new System.Data.Common.DataColumnMapping("TCOM_TDESC", "TCOM_TDESC"), new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"), new System.Data.Common.DataColumnMapping("DOCUMENTADO", "DOCUMENTADO")})}); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS PERS_NCORR, '' AS INST_CCOD, '' AS COMP_NDOCTO, '' AS TCOM_CCOD, '' AS DCOM_NCOMPROMISO, '' AS NCUOTA, '' AS COMP_FDOCTO, '' AS DCOM_FCOMPROMISO, '' AS DCOM_MCOMPROMISO, '' AS TING_CCOD, '' AS DING_NDOCTO, '' AS ABONOS, '' AS SALDO, '' AS EDIN_CCOD, '' AS EDIN_TDESC, '' AS TCOM_TDESC, '' AS TING_TDESC, '' AS DOCUMENTADO "; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL"); this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd"; // // oleDbDataAdapter2 // this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2; this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Alumno", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"), new System.Data.Common.DataColumnMapping("RUT", "RUT"), new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"), new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"), new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"), new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"), new System.Data.Common.DataColumnMapping("ESTADO_MATRICULA", "ESTADO_MATRICULA"), new System.Data.Common.DataColumnMapping("ESTADO_ALUMNO", "ESTADO_ALUMNO")})}); this.oleDbDataAdapter2.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter2_RowUpdated); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS PERS_NCORR, \'\' AS RUT, \'\' AS NOMBRE, \'\' AS CARR_TDESC, \'\' AS SEDE_TD" + "ESC, \'\' AS ANO_INGRESO, \'\' AS ESTADO_MATRICULA, \'\' AS ESTADO_ALUMNO, \'\' AS ingre" + "so_u, \'\' AS PERI_TDESC"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbDataAdapter3 // this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3; this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Creditos", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("STDE_CCOD", "STDE_CCOD"), new System.Data.Common.DataColumnMapping("STDE_TDESC", "STDE_TDESC"), new System.Data.Common.DataColumnMapping("BENE_MMONTO", "BENE_MMONTO"), new System.Data.Common.DataColumnMapping("MONE_CCOD", "MONE_CCOD"), new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_MATRICULA", "BENE_NPORCENTAJE_MATRICULA"), new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_COLEGIATURA", "BENE_NPORCENTAJE_COLEGIATURA"), new System.Data.Common.DataColumnMapping("TBEN_CCOD", "TBEN_CCOD"), new System.Data.Common.DataColumnMapping("BENE_FBENEFICIO", "BENE_FBENEFICIO")})}); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS contrato, \'\' AS CONT_NCORR, \'\' AS STDE_CCOD, \'\' AS STDE_TDESC, \'\' AS" + " BENE_MMONTO, \'\' AS MONE_CCOD, \'\' AS BENE_NPORCENTAJE_MATRICULA, \'\' AS BENE_NPOR" + "CENTAJE_COLEGIATURA, \'\' AS TBEN_CCOD, \'\' AS BENE_FBENEFICIO"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT \'\' AS COME_NCORR, \'\' AS COME_TCOMENTARIO, \'\' AS COME_FCOMENTARIO, \'\' AS TI" + "CO_TDESC, \'\' AS PERS_NCORR_AUTOR"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbDataAdapter4 // this.oleDbDataAdapter4.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbDataAdapter4.InsertCommand = this.oleDbInsertCommand1; this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4; this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Comentarios", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("COME_NCORR", "COME_NCORR"), new System.Data.Common.DataColumnMapping("COME_TCOMENTARIO", "COME_TCOMENTARIO"), new System.Data.Common.DataColumnMapping("COME_FCOMENTARIO", "COME_FCOMENTARIO"), new System.Data.Common.DataColumnMapping("TICO_TDESC", "TICO_TDESC"), new System.Data.Common.DataColumnMapping("PERS_NCORR_AUTOR", "PERS_NCORR_AUTOR")})}); this.oleDbDataAdapter4.UpdateCommand = this.oleDbUpdateCommand1; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); }