コード例 #1
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.DbConnection        = new System.Data.OleDb.OleDbConnection();
     this.DataAdapter         = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.dataSetDatos1       = new Res_Morosidad.DataSetDatos();
     ((System.ComponentModel.ISupportInitialize)(this.dataSetDatos1)).BeginInit();
     //
     // DbConnection
     //
     this.DbConnection.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // DataAdapter
     //
     this.DataAdapter.SelectCommand = this.oleDbSelectCommand1;
     this.DataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "T_Datos", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("FECHA_CORTE", "FECHA_CORTE"),
             new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"),
             new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
             new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
             new System.Data.Common.DataColumnMapping("COMPROMETIDO", "COMPROMETIDO"),
             new System.Data.Common.DataColumnMapping("SALDO", "SALDO")
         })
     });
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS FECHA_CORTE, \'\' AS SEDE_TDESC, \'\' AS CARRERA, \'\' AS TING_TDESC, \'\' A" +
                                            "S COMPROMETIDO, \'\' AS SALDO FROM DUAL";
     this.oleDbSelectCommand1.Connection = this.DbConnection;
     //
     // dataSetDatos1
     //
     this.dataSetDatos1.DataSetName = "DataSetDatos";
     this.dataSetDatos1.Locale      = new System.Globalization.CultureInfo("es-CL");
     this.dataSetDatos1.Namespace   = "http://www.tempuri.org/DataSetDatos.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSetDatos1)).EndInit();
 }
コード例 #2
0
ファイル: Res_Morosidad.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.DbConnection = new System.Data.OleDb.OleDbConnection();
     this.DataAdapter = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.dataSetDatos1 = new Res_Morosidad.DataSetDatos();
     ((System.ComponentModel.ISupportInitialize)(this.dataSetDatos1)).BeginInit();
     //
     // DbConnection
     //
     this.DbConnection.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // DataAdapter
     //
     this.DataAdapter.SelectCommand = this.oleDbSelectCommand1;
     this.DataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                           new System.Data.Common.DataTableMapping("Table", "T_Datos", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                      new System.Data.Common.DataColumnMapping("FECHA_CORTE", "FECHA_CORTE"),
                                                                                                                                                                                                      new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"),
                                                                                                                                                                                                      new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
                                                                                                                                                                                                      new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
                                                                                                                                                                                                      new System.Data.Common.DataColumnMapping("COMPROMETIDO", "COMPROMETIDO"),
                                                                                                                                                                                                      new System.Data.Common.DataColumnMapping("SALDO", "SALDO")})});
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS FECHA_CORTE, \'\' AS SEDE_TDESC, \'\' AS CARRERA, \'\' AS TING_TDESC, \'\' A" +
         "S COMPROMETIDO, \'\' AS SALDO FROM DUAL";
     this.oleDbSelectCommand1.Connection = this.DbConnection;
     //
     // dataSetDatos1
     //
     this.dataSetDatos1.DataSetName = "DataSetDatos";
     this.dataSetDatos1.Locale = new System.Globalization.CultureInfo("es-CL");
     this.dataSetDatos1.Namespace = "http://www.tempuri.org/DataSetDatos.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSetDatos1)).EndInit();
 }