mcs/class/System.Data/System.Data.OleDb.jvm/OleDbDataAdapter.cs

   1 //\r
   2 // System.Data.OleDb.OleDbDataAdapter\r
   3 //\r
   4 // Authors:\r
   5 //   Rodrigo Moya (rodrigo@ximian.com)\r
   6 //   Tim Coleman (tim@timcoleman.com)\r
   7 //      Konstantin Triger <kostat@mainsoft.com>
   8 //      Boris Kirzner <borisk@mainsoft.com>\r
   9 //\r
  10 // Copyright (C) Rodrigo Moya, 2002\r
  11 // Copyright (C) Tim Coleman, 2002\r
  12 // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
  13 //
  14
  15 //
  16 // Permission is hereby granted, free of charge, to any person obtaining
  17 // a copy of this software and associated documentation files (the
  18 // "Software"), to deal in the Software without restriction, including
  19 // without limitation the rights to use, copy, modify, merge, publish,
  20 // distribute, sublicense, and/or sell copies of the Software, and to
  21 // permit persons to whom the Software is furnished to do so, subject to
  22 // the following conditions:
  23 //
  24 // The above copyright notice and this permission notice shall be
  25 // included in all copies or substantial portions of the Software.
  26 //
  27 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  28 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  29 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  30 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  31 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  32 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  33 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  34 //\r
  35 \r
  36 \r
  37 using System;\r
  38 using System.ComponentModel;\r
  39 using System.Data;\r
  40 using System.Data.Common;\r
  41 \r
  42 namespace System.Data.OleDb\r
  43 {\r
  44         public sealed class OleDbDataAdapter : DbDataAdapter, IDbDataAdapter\r
  45         {\r
  46                 #region Fields\r
  47 \r
  48                 OleDbCommand deleteCommand;\r
  49                 OleDbCommand insertCommand;\r
  50                 OleDbCommand selectCommand;\r
  51                 OleDbCommand updateCommand;\r
  52 \r
  53                 #endregion\r
  54 \r
  55                 #region Constructors\r
  56 \r
  57                 public OleDbDataAdapter ()\r
  58                         : this (new OleDbCommand ())\r
  59                 {\r
  60                 }\r
  61 \r
  62                 public OleDbDataAdapter (OleDbCommand selectCommand)\r
  63                 {\r
  64                         DeleteCommand = new OleDbCommand ();\r
  65                         InsertCommand = new OleDbCommand ();\r
  66                         SelectCommand = selectCommand;\r
  67                         UpdateCommand = new OleDbCommand ();\r
  68                 }\r
  69 \r
  70                 public OleDbDataAdapter (string selectCommandText, OleDbConnection selectConnection)\r
  71                         : this (new OleDbCommand (selectCommandText, selectConnection))\r
  72                 {\r
  73                 }\r
  74 \r
  75                 public OleDbDataAdapter (string selectCommandText, string selectConnectionString)\r
  76                         : this (selectCommandText, new OleDbConnection (selectConnectionString))\r
  77                 {\r
  78                 }\r
  79 \r
  80                 #endregion // Fields\r
  81 \r
  82                 #region Properties\r
  83 \r
  84                 public OleDbCommand DeleteCommand {\r
  85                         get {\r
  86                                 return deleteCommand;\r
  87                         }\r
  88                         set {\r
  89                                 deleteCommand = value;\r
  90                         }\r
  91                 }\r
  92 \r
  93                 public OleDbCommand InsertCommand {\r
  94                         get {\r
  95                                 return insertCommand;\r
  96                         }\r
  97                         set {\r
  98                                 insertCommand = value;\r
  99                         }\r
 100                 }\r
 101 \r
 102                 public OleDbCommand SelectCommand {\r
 103                         get {\r
 104                                 return selectCommand;\r
 105                         }\r
 106                         set {\r
 107                                 selectCommand = value;\r
 108                         }\r
 109                 }\r
 110 \r
 111                 public OleDbCommand UpdateCommand {\r
 112                         get {\r
 113                                 return updateCommand;\r
 114                         }\r
 115                         set {\r
 116                                 updateCommand = value;\r
 117                         }\r
 118                 }\r
 119 \r
 120                 IDbCommand IDbDataAdapter.DeleteCommand {\r
 121                         get {\r
 122                                 return DeleteCommand;\r
 123                         }\r
 124                         set { \r
 125                                 if (value != null && !(value is OleDbCommand))\r
 126                                         throw new ArgumentException ("DeleteCommand is not of Type OleDbCommand");\r
 127                                 DeleteCommand = (OleDbCommand)value;\r
 128                         }\r
 129                 }\r
 130 \r
 131                 IDbCommand IDbDataAdapter.InsertCommand {\r
 132                         get {\r
 133                                 return InsertCommand;\r
 134                         }\r
 135                         set { \r
 136                                 if (value != null && !(value is OleDbCommand))\r
 137                                         throw new ArgumentException ("InsertCommand is not of Type OleDbCommand");\r
 138                                 InsertCommand = (OleDbCommand)value;\r
 139                         }\r
 140                 }\r
 141 \r
 142                 IDbCommand IDbDataAdapter.SelectCommand {\r
 143                         get {\r
 144                                 return SelectCommand;\r
 145                         }\r
 146                         set { \r
 147                                 if (value != null && !(value is OleDbCommand))\r
 148                                         throw new ArgumentException ("SelectCommand is not of Type OleDbCommand");\r
 149                                 SelectCommand = (OleDbCommand)value;\r
 150                         }\r
 151                 }\r
 152 \r
 153                 \r
 154                 IDbCommand IDbDataAdapter.UpdateCommand {\r
 155                         get {\r
 156                                 return UpdateCommand;\r
 157                         }\r
 158                         set { \r
 159                                 if (value != null && !(value is OleDbCommand))\r
 160                                         throw new ArgumentException ("UpdateCommand is not of Type OleDbCommand");\r
 161                                 UpdateCommand = (OleDbCommand)value;\r
 162                         }\r
 163                 }\r
 164 \r
 165                 ITableMappingCollection IDataAdapter.TableMappings {\r
 166                         get {\r
 167                                 return TableMappings;\r
 168                         }\r
 169                 }\r
 170 \r
 171                 #endregion // Properties\r
 172 \r
 173                 #region Methods\r
 174 \r
 175                 protected override RowUpdatedEventArgs CreateRowUpdatedEvent (DataRow dataRow,\r
 176                                                                               IDbCommand command,\r
 177                                                                               StatementType statementType,\r
 178                                                                               DataTableMapping tableMapping) \r
 179                 {\r
 180                         return new OleDbRowUpdatedEventArgs (dataRow, command, statementType, tableMapping);\r
 181                 }\r
 182 \r
 183 \r
 184                 protected override RowUpdatingEventArgs CreateRowUpdatingEvent (DataRow dataRow,\r
 185                                                                                 IDbCommand command,\r
 186                                                                                 StatementType statementType,\r
 187                                                                                 DataTableMapping tableMapping) \r
 188                 {\r
 189                         return new OleDbRowUpdatingEventArgs (dataRow, command, statementType, tableMapping);\r
 190                 }\r
 191 \r
 192                 protected override void OnRowUpdated (RowUpdatedEventArgs value) \r
 193                 {\r
 194                         if (RowUpdated != null)\r
 195                                 RowUpdated (this, (OleDbRowUpdatedEventArgs) value);\r
 196                 }\r
 197 \r
 198                 protected override void OnRowUpdating (RowUpdatingEventArgs value) \r
 199                 {\r
 200                         if (RowUpdating != null)\r
 201                                 RowUpdating (this, (OleDbRowUpdatingEventArgs) value);\r
 202                 }\r
 203                 \r
 204                 #endregion // Methods\r
 205 \r
 206                 #region Events and Delegates\r
 207 \r
 208                 public event OleDbRowUpdatedEventHandler RowUpdated;\r
 209                 public event OleDbRowUpdatingEventHandler RowUpdating;\r
 210 \r
 211                 #endregion // Events and Delegates\r
 212 \r
 213         }\r
 214 }\r