2 // System.Data.Common.SqlParameterCollection
\r
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.
31 using System.Data.ProviderBase;
33 namespace System.Data.SqlClient
35 public class SqlParameterCollection : AbstractDbParameterCollection
39 public SqlParameterCollection(SqlCommand parent): base(parent)
43 #endregion // Constructors
47 public SqlParameter this[string parameterName]
49 get { return (SqlParameter)base[parameterName]; }
\r
52 base[parameterName] = value;
56 public SqlParameter this[int index]
58 get { return (SqlParameter)base[index]; }
\r
60 base.OnSchemaChanging();
65 protected override Type ItemType {
\r
66 get { return typeof(SqlParameter); }
\r
69 #endregion // Properties
73 public SqlParameter Add(SqlParameter value)
79 public SqlParameter Add(string parameterName, object value)
81 SqlParameter param = new SqlParameter(parameterName,value);
85 public SqlParameter Add(string parameterName, SqlDbType sqlDbType)
87 SqlParameter param = new SqlParameter(parameterName,sqlDbType);
91 public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size)
93 SqlParameter param = new SqlParameter(parameterName,sqlDbType,size);
97 public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn)
99 SqlParameter param = new SqlParameter(parameterName,sqlDbType,size,sourceColumn);
103 #endregion // Methods
\r