2 // System.Data.Common.OleDbParameterCollection
5 // Konstantin Triger <kostat@mainsoft.com>
6 // Boris Kirzner <borisk@mainsoft.com>
8 // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
12 // Permission is hereby granted, free of charge, to any person obtaining
13 // a copy of this software and associated documentation files (the
14 // "Software"), to deal in the Software without restriction, including
15 // without limitation the rights to use, copy, modify, merge, publish,
16 // distribute, sublicense, and/or sell copies of the Software, and to
17 // permit persons to whom the Software is furnished to do so, subject to
18 // the following conditions:
20 // The above copyright notice and this permission notice shall be
21 // included in all copies or substantial portions of the Software.
23 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
24 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
25 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
26 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
27 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
28 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
29 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
33 using System.Data.ProviderBase;
35 namespace System.Data.OleDb
37 public sealed class OleDbParameterCollection : AbstractDbParameterCollection
41 public OleDbParameterCollection(OleDbCommand parent): base(parent)
45 #endregion // Constructors
49 public OleDbParameter this[int index]
51 get { return (OleDbParameter)base[index]; }
58 public OleDbParameter this[string parameterName]
60 get { return (OleDbParameter)base[parameterName]; }
63 base[parameterName] = value;
67 protected override Type ItemType {
68 get { return typeof(OleDbParameter); }
71 #endregion // Properties
75 public OleDbParameter Add(OleDbParameter value)
81 public OleDbParameter Add(string parameterName, object value)
83 OleDbParameter param = new OleDbParameter(parameterName, value);
87 public OleDbParameter Add(string parameterName, OleDbType sqlDbType)
89 OleDbParameter param = new OleDbParameter(parameterName, sqlDbType);
93 public OleDbParameter Add(string parameterName, OleDbType sqlDbType, int size)
95 OleDbParameter param = new OleDbParameter(parameterName, sqlDbType, size);
99 public OleDbParameter Add(string parameterName, OleDbType sqlDbType, int size, string sourceColumn)
101 OleDbParameter param = new OleDbParameter(parameterName, sqlDbType, size, sourceColumn);
105 public void AddRange (OleDbParameter [] values)
107 base.AddRange (values);
110 public OleDbParameter AddWithValue (string parameterName, object value)
112 return Add (parameterName, value);
115 public bool Contains (OleDbParameter value)
117 return base.Contains (value);
120 public void CopyTo (OleDbParameter [] array, int index)
122 base.CopyTo (array, index);
125 public void Insert (int index, OleDbParameter value)
127 base.Insert (index, value);
130 public void Remove (OleDbParameter value)
135 public int IndexOf (OleDbParameter value)
137 return base.IndexOf (value);
140 #endregion // Methods