OleDbDataAdapter.cs 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179
  1. //
  2. // System.Data.OleDb.OleDbDataAdapter
  3. //
  4. // Authors:
  5. // Rodrigo Moya ([email protected])
  6. // Tim Coleman ([email protected])
  7. //
  8. // Copyright (C) Rodrigo Moya, 2002
  9. // Copyright (C) Tim Coleman, 2002
  10. //
  11. using System;
  12. using System.ComponentModel;
  13. using System.Data;
  14. using System.Data.Common;
  15. namespace System.Data.OleDb
  16. {
  17. public sealed class OleDbDataAdapter : DbDataAdapter, IDbDataAdapter
  18. {
  19. #region Fields
  20. OleDbCommand deleteCommand;
  21. OleDbCommand insertCommand;
  22. OleDbCommand selectCommand;
  23. OleDbCommand updateCommand;
  24. MissingMappingAction missingMappingAction;
  25. MissingSchemaAction missingSchemaAction;
  26. static readonly object EventRowUpdated = new object ();
  27. static readonly object EventRowUpdating = new object ();
  28. #endregion
  29. #region Constructors
  30. public OleDbDataAdapter ()
  31. : this (new OleDbCommand ())
  32. {
  33. }
  34. public OleDbDataAdapter (OleDbCommand selectCommand)
  35. {
  36. DeleteCommand = new OleDbCommand ();
  37. InsertCommand = new OleDbCommand ();
  38. SelectCommand = selectCommand;
  39. UpdateCommand = new OleDbCommand ();
  40. }
  41. public OleDbDataAdapter (string selectCommandText, OleDbConnection selectConnection)
  42. : this (new OleDbCommand (selectCommandText, selectConnection))
  43. {
  44. }
  45. public OleDbDataAdapter (string selectCommandText, string selectConnectionString)
  46. : this (selectCommandText, new OleDbConnection (selectConnectionString))
  47. {
  48. }
  49. #endregion // Fields
  50. #region Properties
  51. public OleDbCommand DeleteCommand {
  52. get { return deleteCommand; }
  53. set { deleteCommand = value; }
  54. }
  55. public OleDbCommand InsertCommand {
  56. get { return insertCommand; }
  57. set { insertCommand = value; }
  58. }
  59. public OleDbCommand SelectCommand {
  60. get { return selectCommand; }
  61. set { selectCommand = value; }
  62. }
  63. public OleDbCommand UpdateCommand {
  64. get { return updateCommand; }
  65. set { updateCommand = value; }
  66. }
  67. IDbCommand IDbDataAdapter.DeleteCommand {
  68. get { return DeleteCommand; }
  69. set {
  70. if (!(value is OleDbCommand))
  71. throw new ArgumentException ();
  72. DeleteCommand = (OleDbCommand)value;
  73. }
  74. }
  75. IDbCommand IDbDataAdapter.InsertCommand {
  76. get { return InsertCommand; }
  77. set {
  78. if (!(value is OleDbCommand))
  79. throw new ArgumentException ();
  80. InsertCommand = (OleDbCommand)value;
  81. }
  82. }
  83. IDbCommand IDbDataAdapter.SelectCommand {
  84. get { return SelectCommand; }
  85. set {
  86. if (!(value is OleDbCommand))
  87. throw new ArgumentException ();
  88. SelectCommand = (OleDbCommand)value;
  89. }
  90. }
  91. MissingMappingAction IDataAdapter.MissingMappingAction {
  92. get { return missingMappingAction; }
  93. set { missingMappingAction = value; }
  94. }
  95. MissingSchemaAction IDataAdapter.MissingSchemaAction {
  96. get { return missingSchemaAction; }
  97. set { missingSchemaAction = value; }
  98. }
  99. IDbCommand IDbDataAdapter.UpdateCommand {
  100. get { return UpdateCommand; }
  101. set {
  102. if (!(value is OleDbCommand))
  103. throw new ArgumentException ();
  104. UpdateCommand = (OleDbCommand)value;
  105. }
  106. }
  107. ITableMappingCollection IDataAdapter.TableMappings {
  108. get { return TableMappings; }
  109. }
  110. #endregion // Properties
  111. #region Methods
  112. protected override RowUpdatedEventArgs CreateRowUpdatedEvent (DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
  113. {
  114. return new OleDbRowUpdatedEventArgs (dataRow, command, statementType, tableMapping);
  115. }
  116. protected override RowUpdatingEventArgs CreateRowUpdatingEvent (DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
  117. {
  118. return new OleDbRowUpdatingEventArgs (dataRow, command, statementType, tableMapping);
  119. }
  120. protected override void OnRowUpdated (RowUpdatedEventArgs value)
  121. {
  122. OleDbRowUpdatedEventHandler handler = (OleDbRowUpdatedEventHandler) Events[EventRowUpdated];
  123. if ((handler != null) && (value is OleDbRowUpdatedEventArgs))
  124. handler (this, (OleDbRowUpdatedEventArgs) value);
  125. }
  126. protected override void OnRowUpdating (RowUpdatingEventArgs value)
  127. {
  128. OleDbRowUpdatingEventHandler handler = (OleDbRowUpdatingEventHandler) Events[EventRowUpdated];
  129. if ((handler != null) && (value is OleDbRowUpdatingEventArgs))
  130. handler (this, (OleDbRowUpdatingEventArgs) value);
  131. }
  132. #endregion // Methods
  133. #region Events and Delegates
  134. public event OleDbRowUpdatedEventHandler RowUpdated {
  135. add { Events.AddHandler (EventRowUpdated, value); }
  136. remove { Events.RemoveHandler (EventRowUpdated, value); }
  137. }
  138. public event OleDbRowUpdatedEventHandler RowUpdating {
  139. add { Events.AddHandler (EventRowUpdating, value); }
  140. remove { Events.RemoveHandler (EventRowUpdating, value); }
  141. }
  142. #endregion // Events and Delegates
  143. }
  144. }