/// <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.datosContrato2 = new contrato_antiguo.datosContrato(); ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).BeginInit(); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("text_antiguo", "text_antiguo"), new System.Data.Common.DataColumnMapping("jorn_tdesc", "jorn_tdesc"), new System.Data.Common.DataColumnMapping("emailp", "emailp"), new System.Data.Common.DataColumnMapping("eciv_tdescp", "eciv_tdescp"), new System.Data.Common.DataColumnMapping("pais_tdescp", "pais_tdescp"), new System.Data.Common.DataColumnMapping("pers_tprofesionp", "pers_tprofesionp"), new System.Data.Common.DataColumnMapping("emailppc", "emailppc"), new System.Data.Common.DataColumnMapping("eciv_tdescppc", "eciv_tdescppc"), new System.Data.Common.DataColumnMapping("pais_tdescppc", "pais_tdescppc"), new System.Data.Common.DataColumnMapping("pers_tprofesionppc", "pers_tprofesionppc"), new System.Data.Common.DataColumnMapping("nro_informe", "nro_informe"), new System.Data.Common.DataColumnMapping("NRO_INFORME1", "NRO_INFORME1"), new System.Data.Common.DataColumnMapping("NOMBRE_INFORME", "NOMBRE_INFORME"), new System.Data.Common.DataColumnMapping("NRO_CONTRATO", "NRO_CONTRATO"), 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("NOMBRE_REPRESENTANTE", "NOMBRE_REPRESENTANTE"), new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"), new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"), new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"), new System.Data.Common.DataColumnMapping("EDAD", "EDAD"), 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("PROFESION", "PROFESION"), new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"), new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"), new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"), new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"), new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"), new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"), new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"), new System.Data.Common.DataColumnMapping("NRO_DOCTO", "NRO_DOCTO"), new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"), new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A")})}); this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NRO_INFORME, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS NOMBRE_REPRESENTANTE, '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" + "ial catalog=protic2"; // // datosContrato2 // this.datosContrato2.DataSetName = "datosContrato"; this.datosContrato2.Locale = new System.Globalization.CultureInfo("es-ES"); this.datosContrato2.Namespace = "http://www.tempuri.org/datosContrato.xsd"; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).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.datosContrato2 = new contrato_antiguo.datosContrato(); ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).BeginInit(); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("text_antiguo", "text_antiguo"), new System.Data.Common.DataColumnMapping("jorn_tdesc", "jorn_tdesc"), new System.Data.Common.DataColumnMapping("emailp", "emailp"), new System.Data.Common.DataColumnMapping("eciv_tdescp", "eciv_tdescp"), new System.Data.Common.DataColumnMapping("pais_tdescp", "pais_tdescp"), new System.Data.Common.DataColumnMapping("pers_tprofesionp", "pers_tprofesionp"), new System.Data.Common.DataColumnMapping("emailppc", "emailppc"), new System.Data.Common.DataColumnMapping("eciv_tdescppc", "eciv_tdescppc"), new System.Data.Common.DataColumnMapping("pais_tdescppc", "pais_tdescppc"), new System.Data.Common.DataColumnMapping("pers_tprofesionppc", "pers_tprofesionppc"), new System.Data.Common.DataColumnMapping("nro_informe", "nro_informe"), new System.Data.Common.DataColumnMapping("NRO_INFORME1", "NRO_INFORME1"), new System.Data.Common.DataColumnMapping("NOMBRE_INFORME", "NOMBRE_INFORME"), new System.Data.Common.DataColumnMapping("NRO_CONTRATO", "NRO_CONTRATO"), 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("NOMBRE_REPRESENTANTE", "NOMBRE_REPRESENTANTE"), new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"), new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"), new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"), new System.Data.Common.DataColumnMapping("EDAD", "EDAD"), 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("PROFESION", "PROFESION"), new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"), new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"), new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"), new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"), new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"), new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"), new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"), new System.Data.Common.DataColumnMapping("NRO_DOCTO", "NRO_DOCTO"), new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"), new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"), new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A") }) }); this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NRO_INFORME, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS NOMBRE_REPRESENTANTE, '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" + "ial catalog=protic2"; // // datosContrato2 // this.datosContrato2.DataSetName = "datosContrato"; this.datosContrato2.Locale = new System.Globalization.CultureInfo("es-ES"); this.datosContrato2.Namespace = "http://www.tempuri.org/datosContrato.xsd"; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.datosContrato2)).EndInit(); }