SqlDataSource
Represents an SQL database to data items.
Definition
Namespace:Telerik.Reporting
Assembly:Telerik.Reporting.dll
Syntax:
public class SqlDataSource : DataSource, IDataSourceInheritance: objectMarshalByRefObjectComponentDataSourceSqlDataSource
Implements:
Inherited Members
Constructors
Initializes a new instance of the SqlDataSource class.
public SqlDataSource()Initializes a new instance of the SqlDataSource class.
public SqlDataSource(string providerName, string connectionString, string selectCommand, SqlDataSourceCommandType selectCommandType, string schemaRestrictions)Specifies the managed provider name used to connect to data.
connectionStringstringSpecifies the connection string used to connect to data.
selectCommandstringSpecifies the SQL select statement or stored procedure to execute.
selectCommandTypeSqlDataSourceCommandTypeSpecifies how the select command string to be interpreted.
schemaRestrictionsstringSpecifies the schema restrictions used by the query builder while resolving the database schema.
Initializes a new instance of the SqlDataSource class.
public SqlDataSource(string providerName, string connectionString, string selectCommand, string schemaRestrictions)Specifies the managed provider name used to connect to data.
connectionStringstringSpecifies the connection string used to connect to data.
selectCommandstringSpecifies the SQL select statement or stored procedure to execute.
schemaRestrictionsstringSpecifies the schema restrictions used by the query builder while resolving the database schema.
Initializes a new instance of the SqlDataSource class.
public SqlDataSource(string providerName, string connectionString, string selectCommand)Specifies the managed provider name used to connect to data.
connectionStringstringSpecifies the connection string used to connect to data.
selectCommandstringSpecifies the SQL select statement or stored procedure to execute.
Initializes a new instance of the SqlDataSource class.
public SqlDataSource(string connectionString, string selectCommand)Specifies the connection string used to connect to data.
selectCommandstringSpecifies the SQL select statement or stored procedure to execute.
Properties
Gets or sets the wait time in seconds before terminating the attempt to retrieve data.
public int CommandTimeout { get; set; }The time in seconds to wait before terminating the attempt to retrieve data. The default value of the CommandTimeout property is 30 seconds.
The provided value should be valid for the currently used data provider.
ConnectionString
string
Gets or sets the connection string used to connect to data.
public string ConnectionString { get; set; }The ConnectionString property contains either a valid connection string or the name of a ConnectionStringSettings in the application configuration file.
Gets a collection with data source parameters.
public SqlDataSourceParameterCollection Parameters { get; }ProviderName
string
Gets or sets the managed provider name used to connect to data.
[TypeConverter("Telerik.Reporting.Data.Design.DataProviderNameConverter, Telerik.Reporting.Design, Version=20.1.26.615, Culture=neutral, PublicKeyToken=a9d7983dfcc261be")]
public string ProviderName { get; set; }If the ProviderName property is set to null (Nothing in Visual Basic) or an empty string, the default provider is System.Data.SqlClient.
SchemaRestrictions
string
Gets or sets the schema restrictions used by the query builder while resolving the database schema.
public string SchemaRestrictions { get; set; }A comma-separated list of schema restrictions used to limit the amount of information returned. The position of each item in the list is equivalent to the restriction number.
SelectCommand
string
Gets or sets the SQL select statement or stored procedure to execute.
public string SelectCommand { get; set; }Gets or sets a value indicating how the select command to be interpreted.
public SqlDataSourceCommandType SelectCommandType { get; set; }One of the SqlDataSourceCommandType enumeration values. The default value of the SelectCommandType property is Text.