[Quantproject-developers] QuantProject/b4_Business/a0_Validation ValidateDataTable.cs, 1.4, 1.5

[Glauco S. <gla...@us...>]

Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv17196/b4_Business/a0_Validation

Modified Files:
	ValidateDataTable.cs 
Log Message:
Now bot Access and MySql are supported

Index: ValidateDataTable.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/ValidateDataTable.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** ValidateDataTable.cs	26 May 2004 15:31:52 -0000	1.4
--- ValidateDataTable.cs	30 Dec 2008 00:15:34 -0000	1.5
***************
*** 1,5 ****
  using System;
  using System.Data;
! using System.Data.OleDb;
  using QuantProject.ADT;
  using QuantProject.Business.Validation.Validators;
--- 1,5 ----
  using System;
  using System.Data;
! using System.Data.Common;
  using QuantProject.ADT;
  using QuantProject.Business.Validation.Validators;
***************
*** 17,22 ****
  	{
  		private string selectStatement;
! 		private OleDbCommandBuilder oleDbCommandBuilder;
! 		private OleDbDataAdapter oleDbDataAdapter;
  		private DataTable tableOfTickersToBeValidated;
  
--- 17,22 ----
  	{
  		private string selectStatement;
! 		private DbCommandBuilder dbCommandBuilder;
! 		private DbDataAdapter dbDataAdapter;
  		private DataTable tableOfTickersToBeValidated;
  
***************
*** 42,50 ****
  			this.selectStatement =
  				"select * from quotes where 1=2";
! 			this.oleDbDataAdapter =
! 				new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection );
! 			this.oleDbCommandBuilder = new OleDbCommandBuilder( oleDbDataAdapter );
! 			this.oleDbDataAdapter.UpdateCommand = this.oleDbCommandBuilder.GetUpdateCommand();
! 			this.oleDbDataAdapter.Fill( this );
  			DataColumn dataColumn = new DataColumn( "CloseToCloseHasBeenVisuallyValidated" ,
  				System.Type.GetType( "System.Boolean" ) );
--- 42,53 ----
  			this.selectStatement =
  				"select * from quotes where 1=2";
! 			this.dbDataAdapter =
! 				DbDataAdapterProvider.GetDbDataAdapter( this.selectStatement );
! //				new OleDbDataAdapter( selectStatement , ConnectionProvider.DbConnection );
! //			this.oleDbCommandBuilder = new OleDbCommandBuilder( dbDataAdapter );
! 			this.dbCommandBuilder =
! 				DbCommandBuilderProvider.GetDbCommanBuilder( dbDataAdapter );
! 			this.dbDataAdapter.UpdateCommand = this.dbCommandBuilder.GetUpdateCommand();
! 			this.dbDataAdapter.Fill( this );
  			DataColumn dataColumn = new DataColumn( "CloseToCloseHasBeenVisuallyValidated" ,
  				System.Type.GetType( "System.Boolean" ) );
***************
*** 125,129 ****
  			try
  			{
! 				this.oleDbDataAdapter.Update( this );
  				this.AcceptChanges();
  			}
--- 128,132 ----
  			try
  			{
! 				this.dbDataAdapter.Update( this );
  				this.AcceptChanges();
  			}