SqlParameterCollection.cs 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. //
  2. // System.Data.Common.SqlParameterCollection
  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.SqlClient
  32. {
  33. public class SqlParameterCollection : AbstractDbParameterCollection
  34. {
  35. #region Constructors
  36. public SqlParameterCollection(SqlCommand parent): base(parent)
  37. {
  38. }
  39. #endregion // Constructors
  40. #region Properties
  41. public SqlParameter this[string parameterName]
  42. {
  43. get { return (SqlParameter)base[parameterName]; }
  44. set {
  45. OnSchemaChanging();
  46. base[parameterName] = value;
  47. }
  48. }
  49. public SqlParameter this[int index]
  50. {
  51. get { return (SqlParameter)base[index]; }
  52. set {
  53. base.OnSchemaChanging();
  54. base[index] = value;
  55. }
  56. }
  57. protected override Type ItemType {
  58. get { return typeof(SqlParameter); }
  59. }
  60. #endregion // Properties
  61. #region Methods
  62. public SqlParameter Add(SqlParameter value)
  63. {
  64. base.Add(value);
  65. return value;
  66. }
  67. public SqlParameter Add(string parameterName, object value)
  68. {
  69. SqlParameter param = new SqlParameter(parameterName,value);
  70. return Add(param);
  71. }
  72. public SqlParameter Add(string parameterName, SqlDbType sqlDbType)
  73. {
  74. SqlParameter param = new SqlParameter(parameterName,sqlDbType);
  75. return Add(param);
  76. }
  77. public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size)
  78. {
  79. SqlParameter param = new SqlParameter(parameterName,sqlDbType,size);
  80. return Add(param);
  81. }
  82. public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn)
  83. {
  84. SqlParameter param = new SqlParameter(parameterName,sqlDbType,size,sourceColumn);
  85. return Add(param);
  86. }
  87. #if NET_2_0
  88. public void AddRange (SqlParameter [] values)
  89. {
  90. base.AddRange (values);
  91. }
  92. public SqlParameter AddWithValue (string parameterName, object value)
  93. {
  94. return Add (parameterName, value);
  95. }
  96. public bool Contains (SqlParameter value)
  97. {
  98. return base.Contains (value);
  99. }
  100. public int IndexOf (SqlParameter value)
  101. {
  102. return base.IndexOf (value);
  103. }
  104. public void CopyTo (SqlParameter [] array, int index)
  105. {
  106. base.CopyTo (array, index);
  107. }
  108. public void Insert (int index, SqlParameter value)
  109. {
  110. base.Insert (index, value);
  111. }
  112. public void Remove (SqlParameter value)
  113. {
  114. base.Remove (value);
  115. }
  116. #endif
  117. #endregion // Methods
  118. }
  119. }