[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
  Core Library Assemblies
 [Expand]DevExpress Data Library
 [Expand]DevExpress Pivot Grid Core Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.DataFederation
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Json
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Collapse]DevExpress.DataAccess.Sql
   [Expand]AggregateQueryInvalidSortingValidationException Class
    AggregationType Enumeration
   [Expand]AggregationWithoutAliasValidationException Class
   [Expand]AliasedBase Class
   [Expand]AllColumns Class
   [Expand]CircularRelationsValidationException Class
   [Expand]Column Class
   [Expand]ColumnBase Class
   [Expand]ColumnExpression Class
   [Expand]ColumnInfo Class
   [Expand]ColumnNotInSchemaValidationException Class
   [Expand]ColumnNullValidationException Class
    ConditionType Enumeration
   [Expand]ConfigureDataConnectionEventArgs Class
    ConfigureDataConnectionEventHandler Delegate
   [Expand]ConnectionErrorEventArgs Class
    ConnectionErrorEventHandler Delegate
   [Expand]ConnectionOptions Class
   [Expand]CustomExpression Class
   [Expand]CustomExpressionWithAmbiguousColumnValidationException Class
   [Expand]CustomExpressionWithColumnOfMissingTableValidationException Class
   [Expand]CustomExpressionWithMissingInSchemaColumnValidationException Class
   [Expand]CustomizeFilterExpressionEventArgs Class
    CustomizeFilterExpressionEventHandler Delegate
   [Expand]CustomSqlQuery Class
   [Expand]CustomSqlQueryValidationException Class
   [Expand]DatabaseConnectionException Class
   [Expand]DBSchema Class
   [Expand]DBSchemaProviderEx Class
   [Expand]DuplicatingColumnNamesValidationException Class
   [Expand]DuplicatingTableNamesValidationException Class
   [Expand]ExpressionBase Class
   [Expand]ExpressionNullValidationException Class
   [Expand]ExpressionStringNullValidationException Class
   [Expand]FilterByAmbiguousColumnValidationException Class
   [Expand]FilterByColumnOfMissingTableValidationException Class
   [Expand]FilterByMissingInSchemaColumnValidationException Class
   [Expand]Group Class
   [Expand]GroupByAggregateColumnValidationException Class
   [Expand]GroupByWithoutAggregateValidationException Class
   [Expand]GroupingInfo Class
   [Expand]GroupingInfoList Class
   [Expand]GroupNullValidationException Class
   [Expand]HavingWithoutGroupByValidationException Class
   [Expand]IDBSchemaProvider Interface
   [Expand]IDBSchemaProviderEx Interface
   [Expand]IncompleteRelationValidationException Class
   [Expand]InvalidExpressionStringValidationException Class
   [Expand]IResultSchemaProvider Interface
   [Expand]Join Class
   [Expand]MasterDetailInfo Class
   [Expand]MasterDetailInfoCollection Class
   [Expand]NegativeTopSkipValidationException Class
   [Expand]NoColumnsValidationException Class
   [Expand]NoRelationColumnsValidationException Class
   [Expand]NoTablesValidationException Class
   [Expand]PartialAggregationValidationException Class
   [Expand]QueryExecutionException Class
   [Collapse]QueryParameter Class
     QueryParameter Members
    [Expand]QueryParameter Constructor
   [Expand]RecordsCount Class
   [Expand]RelationColumnInfo Class
   [Expand]RelationColumnNotInSchemaValidationException Class
   [Expand]RelationColumnNullValidationException Class
   [Expand]RelationException Class
   [Expand]RelationInfo Class
   [Expand]RelationInfoList Class
   [Expand]RelationNullValidationException Class
   [Expand]RelationTableNotSelectedValidationException Class
   [Expand]ResultSchemaProvider Class
    SchemaLoadingMode Enumeration
   [Expand]SelectQuery Class
   [Expand]SelectQueryFluentBuilder Class
   [Expand]SkipWithoutSortingValidationException Class
   [Expand]SortByAggregateColumnValidationException Class
   [Expand]Sorting Class
   [Expand]SortingBySameColumnTwiceValidationException Class
   [Expand]SortingInfo Class
   [Expand]SortingInfoList Class
   [Expand]SortingNullValidationException Class
   [Expand]SqlDataConnection Class
   [Expand]SqlDataSource Class
   [Expand]SqlQuery Class
   [Expand]SqlQueryCollection Class
   [Expand]SqlStringEmptyValidationException Class
   [Expand]StoredProcNameNullValidationException Class
   [Expand]StoredProcNotInSchemaValidationException Class
   [Expand]StoredProcParamCountValidationException Class
   [Expand]StoredProcParamNameValidationException Class
   [Expand]StoredProcParamNullValidationException Class
   [Expand]StoredProcParamTypeValidationException Class
   [Expand]StoredProcQuery Class
   [Expand]Table Class
   [Expand]TableInfo Class
   [Expand]TableInfoList Class
   [Expand]TableNotInSchemaValidationException Class
   [Expand]TableNotSelectedValidationException Class
   [Expand]TableNullValidationException Class
   [Expand]TableQuery Class
   [Expand]TablesNotRelatedValidationException Class
   [Expand]UnnamedColumnValidationException Class
   [Expand]UnnamedTableValidationException Class
   [Expand]ValidationException Class
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.Gantt
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.Printing.ExportHelpers
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Security.Resources
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.Utils.Svg
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Native
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.Caching
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Expressions
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Rules
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

QueryParameter Class

A parameter passed to a SqlQuery.

Namespace:DevExpress.DataAccess.Sql
Assembly:DevExpress.DataAccess.v19.2.dll

Expanded Syntax

Expanded Remarks

A collection of QueryParameter objects is returned by the SqlQuery.Parameters property. This property is also available for the StoredProcQuery class.

The following code illustrates how to bind to a Microsoft SQL Server database and filter the result set of a query by a specified parameter value.

To learn how to link query parameters with report or dashboard parameters using an Expression, refer to the following tutorials.

Expanded Inheritance Hierarchy

System.Object
    DataSourceParameterBase
       QueryParameter

Expanded See Also

Is this topic helpful?​​​​​​​