OleDbParameterCollection.cs 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. //
  2. // System.Data.Common.OleDbParameterCollection
  3. //
  4. // Authors:
  5. // Konstantin Triger <[email protected]>
  6. // Boris Kirzner <[email protected]>
  7. //
  8. // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
  9. //
  10. //
  11. // Permission is hereby granted, free of charge, to any person obtaining
  12. // a copy of this software and associated documentation files (the
  13. // "Software"), to deal in the Software without restriction, including
  14. // without limitation the rights to use, copy, modify, merge, publish,
  15. // distribute, sublicense, and/or sell copies of the Software, and to
  16. // permit persons to whom the Software is furnished to do so, subject to
  17. // the following conditions:
  18. //
  19. // The above copyright notice and this permission notice shall be
  20. // included in all copies or substantial portions of the Software.
  21. //
  22. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  23. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  24. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  25. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  26. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  27. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  28. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  29. //
  30. using System.Data.ProviderBase;
  31. namespace System.Data.OleDb
  32. {
  33. public sealed class OleDbParameterCollection : AbstractDbParameterCollection
  34. {
  35. #region Constructors
  36. public OleDbParameterCollection(OleDbCommand parent): base(parent)
  37. {
  38. }
  39. #endregion // Constructors
  40. #region Properties
  41. public OleDbParameter this[int index]
  42. {
  43. get { return (OleDbParameter)base[index]; }
  44. set {
  45. OnSchemaChanging();
  46. base[index] = value;
  47. }
  48. }
  49. public OleDbParameter this[string parameterName]
  50. {
  51. get { return (OleDbParameter)base[parameterName]; }
  52. set {
  53. OnSchemaChanging();
  54. base[parameterName] = value;
  55. }
  56. }
  57. protected override Type ItemType {
  58. get { return typeof(OleDbParameter); }
  59. }
  60. #endregion // Properties
  61. #region Methods
  62. public OleDbParameter Add(OleDbParameter value)
  63. {
  64. base.Add(value);
  65. return value;
  66. }
  67. public OleDbParameter Add(string parameterName, object value)
  68. {
  69. OleDbParameter param = new OleDbParameter(parameterName, value);
  70. return Add(param);
  71. }
  72. public OleDbParameter Add(string parameterName, OleDbType sqlDbType)
  73. {
  74. OleDbParameter param = new OleDbParameter(parameterName, sqlDbType);
  75. return Add(param);
  76. }
  77. public OleDbParameter Add(string parameterName, OleDbType sqlDbType, int size)
  78. {
  79. OleDbParameter param = new OleDbParameter(parameterName, sqlDbType, size);
  80. return Add(param);
  81. }
  82. public OleDbParameter Add(string parameterName, OleDbType sqlDbType, int size, string sourceColumn)
  83. {
  84. OleDbParameter param = new OleDbParameter(parameterName, sqlDbType, size, sourceColumn);
  85. return Add(param);
  86. }
  87. #if NET_2_0
  88. public bool Contains (OleDbParameter value)
  89. {
  90. return base.Contains (value);
  91. }
  92. public void CopyTo (OleDbParameter [] array, int index)
  93. {
  94. base.CopyTo (array, index);
  95. }
  96. public void Insert (int index, OleDbParameter value)
  97. {
  98. base.Insert (index, value);
  99. }
  100. public void Remove (OleDbParameter value)
  101. {
  102. base.Remove (value);
  103. }
  104. #endif
  105. #endregion // Methods
  106. }
  107. }