[Quantproject-developers] QuantProject/b2_DataAccess OleDbSingleTableAdapter.cs, 1.7, 1.8

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv16793/b2_DataAccess

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

Index: OleDbSingleTableAdapter.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/OleDbSingleTableAdapter.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** OleDbSingleTableAdapter.cs	4 Jul 2004 18:00:29 -0000	1.7
--- OleDbSingleTableAdapter.cs	30 Dec 2008 00:13:18 -0000	1.8
***************
*** 23,35 ****
  using System;
  using System.Data;
! using System.Data.OleDb;
  
  namespace QuantProject.DataAccess
  {
  	/// <summary>
! 	/// Returns a complete OleDbDataAdapter (with proper edit commands already set) to work with
  	/// the given table
  	/// </summary>
! 	public class OleDbSingleTableAdapter
  	{
  		private string tableName;
--- 23,35 ----
  using System;
  using System.Data;
! using System.Data.Common;
  
  namespace QuantProject.DataAccess
  {
  	/// <summary>
! 	/// Returns a complete DbDataAdapter (with proper edit commands already set) to work with
  	/// the given table
  	/// </summary>
! 	public class SingleTableDbDataAdapter
  	{
  		private string tableName;
***************
*** 39,46 ****
  			set { this.tableName = value; }
  		}
! 		private OleDbDataAdapter oleDbDataAdapter;
! 		public OleDbDataAdapter OleDbDataAdapter
  		{
! 			get { return this.oleDbDataAdapter; }
  		}
  		
--- 39,46 ----
  			set { this.tableName = value; }
  		}
! 		private DbDataAdapter dbDataAdapter;
! 		public DbDataAdapter DbDataAdapter
  		{
! 			get { return this.dbDataAdapter; }
  		}
  		
***************
*** 55,65 ****
  			try
  			{
! 				this.oleDbDataAdapter =
! 					new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection );
! 				OleDbCommandBuilder oleDbCommandBuilder = new OleDbCommandBuilder( oleDbDataAdapter );
! 				this.oleDbDataAdapter.InsertCommand = oleDbCommandBuilder.GetInsertCommand();
! 				this.oleDbDataAdapter.UpdateCommand = oleDbCommandBuilder.GetUpdateCommand();
! 				this.oleDbDataAdapter.DeleteCommand = oleDbCommandBuilder.GetDeleteCommand();
! 				this.oleDbDataAdapter.Fill( this.dataTable );
  			}
  			catch ( Exception ex )
--- 55,68 ----
  			try
  			{
! //				this.dbDataAdapter =
! //					new DbDataAdapter( selectStatement , ConnectionProvider.DbConnection );
! 				this.dbDataAdapter = DbDataAdapterProvider.GetDbDataAdapter( selectStatement );
! //				DbCommandBuilder oleDbCommandBuilder = new DbCommandBuilder( dbDataAdapter );
! 				DbCommandBuilder dbCommandBuilder =
! 					DbCommandBuilderProvider.GetDbCommanBuilder( this.dbDataAdapter );
! 				this.dbDataAdapter.InsertCommand = dbCommandBuilder.GetInsertCommand();
! 				this.dbDataAdapter.UpdateCommand = dbCommandBuilder.GetUpdateCommand();
! 				this.dbDataAdapter.DeleteCommand = dbCommandBuilder.GetDeleteCommand();
! 				this.dbDataAdapter.Fill( this.dataTable );
  			}
  			catch ( Exception ex )
***************
*** 71,81 ****
  		}
  
! 		public OleDbSingleTableAdapter( string selectStatement )
  		{
  			this.dataTable = new DataTable();
! 			setAdapter( selectStatement );
  		}
      
!     public OleDbSingleTableAdapter(string selectStatement, DataTable table )
      {
  			this.dataTable = table;
--- 74,84 ----
  		}
  
! 		public SingleTableDbDataAdapter( string selectStatement )
  		{
  			this.dataTable = new DataTable();
! 			this.setAdapter( selectStatement );
  		}
      
!     public SingleTableDbDataAdapter(string selectStatement, DataTable table )
      {
  			this.dataTable = table;
***************
*** 83,87 ****
      }
  
! 		public OleDbSingleTableAdapter()
  		{
  			this.dataTable = new DataTable();
--- 86,90 ----
      }
  
! 		public SingleTableDbDataAdapter()
  		{
  			this.dataTable = new DataTable();