/// <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.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.datosPagare1 = new imprimir_pagare.datosPagare(); ((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit(); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "pagare", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NRO_PAGARE", "NRO_PAGARE"), new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"), new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"), new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"), new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"), new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"), new System.Data.Common.DataColumnMapping("INICIO_VENCIMIENTO", "INICIO_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("FINAL_VENCIMIENTO", "FINAL_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"), new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"), new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"), new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"), new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"), new System.Data.Common.DataColumnMapping("DIRECCION_CODEUDOR", "DIRECCION_CODEUDOR"), new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR", "CIUDAD_CODEUDOR"), new System.Data.Common.DataColumnMapping("DIRECCION_POSTULANTE", "DIRECCION_POSTULANTE"), new System.Data.Common.DataColumnMapping("CONTRATO", "CONTRATO"), new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR1", "CIUDAD_CODEUDOR1") }) }); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS CIUDAD_SEDE, '' AS NRO_PAGARE, '' AS VALOR_PAGAR, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS INICIO_VENCIMIENTO, '' AS FINAL_VENCIMIENTO, '' AS RUT_POST, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION_CODEUDOR, '' AS CIUDAD_CODEUDOR, '' AS DIRECCION_POSTULANTE, '' AS CIUDAD_CODEUDOR FROM DUAL"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); // // datosPagare1 // this.datosPagare1.DataSetName = "datosPagare"; this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES"); this.datosPagare1.Namespace = "http://www.tempuri.org/datosPagare.xsd"; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).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.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.datosPagare1 = new imprimir_pagare.datosPagare(); ((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit(); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "pagare", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NRO_PAGARE", "NRO_PAGARE"), new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"), new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"), new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"), new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"), new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"), new System.Data.Common.DataColumnMapping("INICIO_VENCIMIENTO", "INICIO_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("FINAL_VENCIMIENTO", "FINAL_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"), new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"), new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"), new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"), new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"), new System.Data.Common.DataColumnMapping("DIRECCION_CODEUDOR", "DIRECCION_CODEUDOR"), new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR", "CIUDAD_CODEUDOR"), new System.Data.Common.DataColumnMapping("DIRECCION_POSTULANTE", "DIRECCION_POSTULANTE"), new System.Data.Common.DataColumnMapping("CONTRATO", "CONTRATO"), new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR1", "CIUDAD_CODEUDOR1")})}); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS CIUDAD_SEDE, '' AS NRO_PAGARE, '' AS VALOR_PAGAR, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS INICIO_VENCIMIENTO, '' AS FINAL_VENCIMIENTO, '' AS RUT_POST, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION_CODEUDOR, '' AS CIUDAD_CODEUDOR, '' AS DIRECCION_POSTULANTE, '' AS CIUDAD_CODEUDOR FROM DUAL"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); // // datosPagare1 // this.datosPagare1.DataSetName = "datosPagare"; this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES"); this.datosPagare1.Namespace = "http://www.tempuri.org/datosPagare.xsd"; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).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() { this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.datosPagare1 = new imprimir_pagare.datosPagare(); ((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit(); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "PAGARE", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CIUDAD_SEDE", "CIUDAD_SEDE"), new System.Data.Common.DataColumnMapping("NRO_PAGARE", "NRO_PAGARE"), new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"), new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"), new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"), new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"), new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"), new System.Data.Common.DataColumnMapping("INICIO_VENCIMIENTO", "INICIO_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("FINAL_VENCIMIENTO", "FINAL_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"), new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"), new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"), new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"), new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"), new System.Data.Common.DataColumnMapping("DIRECCION_CODEUDOR", "DIRECCION_CODEUDOR"), new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR", "CIUDAD_CODEUDOR"), new System.Data.Common.DataColumnMapping("DIRECCION_POSTULANTE", "DIRECCION_POSTULANTE"), new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR1", "CIUDAD_CODEUDOR1"), new System.Data.Common.DataColumnMapping("VALOR_CUOTA", "VALOR_CUOTA"), new System.Data.Common.DataColumnMapping("NUMERO_CUOTAS", "NUMERO_CUOTAS"), new System.Data.Common.DataColumnMapping("FECHA_PAGO", "FECHA_PAGO"), new System.Data.Common.DataColumnMapping("BANCO", "BANCO"), new System.Data.Common.DataColumnMapping("CUENTA_CTE", "CUENTA_CTE")})}); this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS CIUDAD_SEDE, '' AS NRO_PAGARE, '' AS VALOR_PAGAR, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS INICIO_VENCIMIENTO, '' AS FINAL_VENCIMIENTO, '' AS RUT_POST, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION_CODEUDOR, '' AS CIUDAD_CODEUDOR, '' AS DIRECCION_POSTULANTE, '' AS CIUDAD_CODEUDOR, '' AS VALOR_CUOTA, '' AS NUMERO_CUOTAS, '' AS FECHA_PAGO, '' AS BANCO, '' AS CUENTA_CTE, '' AS COMUNA_CODEUDOR"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // //this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=sbd03;OLE DB Services = -2;uid=protic;pwd=,.protic;initi" +"al catalog=sigaupa"; // CONECTOR ADMISION //this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic;pwd=proticprueba;Initial Catalog=sigaupa_prueba;Data Source=10.10.10.77;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False"; // CONECTIOS STRING DE PRODUCCION this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic;pwd=pu7685bt,yet;Initial Catalog=sigaupa;Data Source=172.16.254.2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False"; this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage); // // datosPagare1 // this.datosPagare1.DataSetName = "datosPagare"; this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES"); this.datosPagare1.Namespace = "http://www.tempuri.org/datosContrato.xsd"; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).EndInit(); }