skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • NEW: Design Kits for Figma
    • Online Training
    • Document Processing Library
    • Embedded Reporting for web and desktop
    Web
    Kendo UI UI for jQuery UI for Angular UI for React UI for Vue UI for ASP.NET AJAX UI for ASP.NET MVC UI for ASP.NET Core UI for Blazor UI for Silverlight UI for PHP UI for JSP
    Mobile
    UI for .NET MAUI UI for Xamarin
    Document Management
    Telerik Document Processing
    Desktop
    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF UI for UWP
    Reporting & Mocking
    Telerik Reporting Telerik Report Server Telerik JustMock
    Automated Testing
    Test Studio Test Studio Dev Edition
    CMS
    Sitefinity
    UI/UX Tools
    ThemeBuilder
    Debugging
    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Jam FiddlerCap FiddlerCore
    Extended Reality
    UI for Unity XR
    Free Tools
    JustAssembly JustDecompile VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • What's New
    • Roadmap
    • Release History
  • Docs & Support
  • Pricing
  • Search
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Class SqlDataSourceParameterCollection

Represents a collection of SqlDataSourceParameter objects.

Inheritance
System.Object
System.Collections.ObjectModel.Collection<SqlDataSourceParameter>
SqlDataSourceParameterCollection
Inherited Members
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Add(Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Clear()
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.CopyTo(Telerik.Reporting.SqlDataSourceParameter[], System.Int32)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Contains(Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.GetEnumerator()
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.IndexOf(Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Insert(System.Int32, Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Remove(Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.RemoveAt(System.Int32)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.ClearItems()
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.InsertItem(System.Int32, Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.RemoveItem(System.Int32)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.SetItem(System.Int32, Telerik.Reporting.SqlDataSourceParameter)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IEnumerable.GetEnumerator()
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.ICollection.CopyTo(System.Array, System.Int32)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.get_Item(System.Int32)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.set_Item(System.Int32, System.Object)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.Add(System.Object)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.Contains(System.Object)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.IndexOf(System.Object)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.Insert(System.Int32, System.Object)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.Remove(System.Object)
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Count
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Items
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.Item[System.Int32]
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.Generic.ICollection<Telerik.Reporting.SqlDataSourceParameter>.IsReadOnly
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.ICollection.IsSynchronized
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.ICollection.SyncRoot
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.Item[System.Int32]
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.IsReadOnly
System.Collections.ObjectModel.Collection<Telerik.Reporting.SqlDataSourceParameter>.System.Collections.IList.IsFixedSize
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Reporting
Assembly: Telerik.Reporting.dll

Syntax

public class SqlDataSourceParameterCollection : Collection<SqlDataSourceParameter>, IList<SqlDataSourceParameter>, ICollection<SqlDataSourceParameter>, IList, ICollection, IReadOnlyList<SqlDataSourceParameter>, IReadOnlyCollection<SqlDataSourceParameter>, IEnumerable<SqlDataSourceParameter>, IEnumerable

Constructors

SqlDataSourceParameterCollection()

Initializes a new instance of the SqlDataSourceParameterCollection class.

Declaration
public SqlDataSourceParameterCollection()

SqlDataSourceParameterCollection(SqlDataSourceParameter[])

Initializes a new instance of the SqlDataSourceParameterCollection class.

Declaration
public SqlDataSourceParameterCollection(SqlDataSourceParameter[] parameters)
Parameters
SqlDataSourceParameter[] parameters

Specifies a range of parameters to add to the collection.

SqlDataSourceParameterCollection(SqlDataSourceParameterCollection)

Initializes a new instance of the SqlDataSourceParameterCollection class.

Declaration
public SqlDataSourceParameterCollection(SqlDataSourceParameterCollection parameters)
Parameters
SqlDataSourceParameterCollection parameters

Specifies a range of parameters to add to the collection.

Properties

Item[String]

Gets the parameter with the specified name from the collection.

Declaration
public SqlDataSourceParameter this[string name] { get; }
Parameters
System.String name

Specifies the name of a parameter from the collection.

Property Value
SqlDataSourceParameter

The parameter with the specified name from the collection.

Methods

Add(String)

Adds a new parameter with the specified name to the collection.

Declaration
public void Add(string name)
Parameters
System.String name

Specifies the name of the new parameter to add to the collection.

Add(String, DbType)

Adds a new parameter with the specified name and data type to the collection.

Declaration
public void Add(string name, DbType dataType)
Parameters
System.String name

Specifies the name of the new parameter to add to the collection.

System.Data.DbType dataType

Specifies the data type of the new parameter to add to the collection.

Add(String, DbType, Object)

Adds a new parameter with the specified name, data type and value to the collection.

Declaration
public void Add(string name, DbType dataType, object value)
Parameters
System.String name

Specifies the name of the new parameter to add to the collection.

System.Data.DbType dataType

Specifies the data type of the new parameter to add to the collection.

System.Object value

Specifies the value of the new parameter to add to the collection.

AddRange(IEnumerable<SqlDataSourceParameter>)

Adds a range of parameters to the collection.

Declaration
public void AddRange(IEnumerable<SqlDataSourceParameter> parameters)
Parameters
System.Collections.Generic.IEnumerable<SqlDataSourceParameter> parameters

Specifies a range of parameters to add to the collection.

AddRange(SqlDataSourceParameterCollection)

Adds a range of parameters to the collection.

Declaration
public void AddRange(SqlDataSourceParameterCollection parameters)
Parameters
SqlDataSourceParameterCollection parameters

Specifies a range of parameters to add to the collection.

Clone(SqlDataSourceParameterCollection)

Declaration
public void Clone(SqlDataSourceParameterCollection source)
Parameters
SqlDataSourceParameterCollection source

Contains(String)

Determines if the collection contains a parameter with the specified name.

Declaration
public bool Contains(string name)
Parameters
System.String name

Specifies the name of a parameter from the collection.

Returns
System.Boolean

True if a parameter with the specified name exists, False otherwise.

FirstOrNullWithCaseFallback(String)

Declaration
public SqlDataSourceParameter FirstOrNullWithCaseFallback(string parameterName)
Parameters
System.String parameterName

Returns
SqlDataSourceParameter

ToArray()

Converts the collection to an array of parameters.

Declaration
public SqlDataSourceParameter[] ToArray()
Returns
SqlDataSourceParameter[]

Array of parameters contained in the collection.

Was this article helpful?

Tell us how we can improve this article

Skip
Getting Started
  • Install Now
  • Online Demos
Support Resources
  • Documentation
  • Knowledge Base
  • Videos
  • Reporting Samples Repository
  • Reporting Release History
Community
  • Forums
  • Blogs
  • Reporting Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.